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.log1.1连接获取01/24 21:59:12.850 DEBUG [$_NIOREACTOR-3-RW] (EnchachePool.java:76) -SQLRouteCache miss cache ,key:TESTDBselect * from travelrecord01/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 travelrecordLIMIT 100} 2 - dn2{SELECT *FROM travelrecordLIMIT 100} 3 - dn3{SELECT *FROM travelrecordLIMIT 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 travelrecordLIMIT 100} 2 - dn2{SELECT *FROM travelrecordLIMIT 100} 3 - dn3{SELECT *FROM travelrecordLIMIT 100}} rrs1.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 travelrecordLIMIT 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 travelrecord01/24 21:59:12.856 DEBUG [Busin