03_mycat通过debug日志来分析sql的完整执行逻辑教程.docx

1，执行 select * from travelrecord ，分析Debug日志，说明整个执行逻辑，包括连接获取，连接同步信息，数据合并，数据返回，连接释放 1.1清空debug信息 [root@wgq_idc_squid_1_11 logs]# cat /dev/null mycat.log [root@wgq_idc_squid_1_11 logs]# ll 修改日志为debug： vim log4j.xml root level value=debug / appender-ref ref=FILE / !--appender-ref ref=FILE /-- /root 获取日志： [root@wgq_idc_squid_1_11 logs]# cp mycat.log 1.log [root@wgq_idc_squid_1_11 logs]# vim 1.log 1.1连接获取 01/24 21:59:12.850 DEBUG [$_NIOREACTOR-3-RW] (EnchachePool.java:76) -SQLRouteCache miss cache ,key:TESTDBselect * from travelrecord 01/24 21:59:12.851 DEBUG [$_NIOREACTOR-3-RW] (EnchachePool.java:59) -SQLRouteCache add cache ,key:TESTDBselect * from travelrecord value:select * from travelrecord, route={ 1 - dn1{SELECT * FROM travelrecord LIMIT 100} 2 - dn2{SELECT * FROM travelrecord LIMIT 100} 3 - dn3{SELECT * FROM travelrecord LIMIT 100} } 01/24 21:59:12.852 DEBUG [$_NIOREACTOR-3-RW] (NonBlockingSession.java:113) -ServerConnection [id=4, schema=TESTDB, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=TESTDB]select * from travelrecord, route={ 1 - dn1{SELECT * FROM travelrecord LIMIT 100} 2 - dn2{SELECT * FROM travelrecord LIMIT 100} 3 - dn3{SELECT * FROM travelrecord LIMIT 100} } rrs 1.2连接同步信息： 01/24 21:59:12.852 DEBUG [$_NIOREACTOR-3-RW] (MySQLConnection.java:445) -con need syn ,total syn cmd 2 commands SET names latin1;SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;schema change:false con:MySQLConnection [id=11, lastTime=1453643952852, user=root, schema=db1, old shema=db1, borrowed=true, fromSlaveDB=true, threadId=3425, charset=latin1, txIsolation=0, autocommit=true, attachment=dn1{SELECT * FROM travelrecord LIMIT 100}, respHandler=org.opencloudb.mysql.nio.handler.MultiNodeQueryHandler@30a6aae0, host=127.0.0.1, port=3327, statusSync=null, writeQueue=0, modifiedSQLExecuted=false] 1.3数据合并 01/24 21:59:12.856 DEBUG [BusinessExecutor6] (DataMergeService.java:296) -prepare mpp merge result for select * from