{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/514","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/514/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/514/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/514/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/514","id":112515911,"number":514,"title":"mycat1.4，C/S 都开启使用压缩，该异常明显 errno:1023 program err:java.nio.BufferOverflowException","user":{"login":"zhuam","id":241174,"avatar_url":"https://avatars.githubusercontent.com/u/241174?v=3","gravatar_id":"","url":"https://api.github.com/users/zhuam","html_url":"https://github.com/zhuam","followers_url":"https://api.github.com/users/zhuam/followers","following_url":"https://api.github.com/users/zhuam/following{/other_user}","gists_url":"https://api.github.com/users/zhuam/gists{/gist_id}","starred_url":"https://api.github.com/users/zhuam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhuam/subscriptions","organizations_url":"https://api.github.com/users/zhuam/orgs","repos_url":"https://api.github.com/users/zhuam/repos","events_url":"https://api.github.com/users/zhuam/events{/privacy}","received_events_url":"https://api.github.com/users/zhuam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-21T05:29:48Z","updated_at":"2015-10-21T08:06:06Z","closed_at":null,"body":"MyCAT Server startup successfully. see logs in logs/mycat.log\r\n10-21 13:29:12.640   WARN [$_NIOREACTOR-2-RW] (BufferPool.java:175) -allocate buffer size large than default chunksize:4096 he want 8192\r\n\r\njava.nio.BufferOverflowException\r\n\tat java.nio.DirectByteBuffer.put(Unknown Source)\r\n\tat java.nio.ByteBuffer.put(Unknown Source)\r\n\tat org.opencloudb.util.CompressUtil.compressMysqlPacket(CompressUtil.java:67)\r\n\tat org.opencloudb.util.CompressUtil.compressMysqlPacket(CompressUtil.java:30)\r\n\tat org.opencloudb.net.AbstractConnection.writeNotSend(AbstractConnection.java:363)\r\n\tat org.opencloudb.net.AbstractConnection.writeToBuffer(AbstractConnection.java:426)\r\n\tat org.opencloudb.mysql.nio.handler.SingleNodeHandler.rowResponse(SingleNodeHandler.java:285)\r\n\tat org.opencloudb.mysql.nio.MySQLConnectionHandler.handleRowPacket(MySQLConnectionHandler.java:203)\r\n\tat org.opencloudb.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:134)\r\n\tat org.opencloudb.net.handler.BackendAsyncHandler.offerData(BackendAsyncHandler.java:36)\r\n\tat org.opencloudb.mysql.nio.MySQLConnectionHandler.handle(MySQLConnectionHandler.java:79)\r\n\tat org.opencloudb.net.AbstractConnection.handle(AbstractConnection.java:253)\r\n\tat org.opencloudb.net.AbstractConnection.onReadData(AbstractConnection.java:307)\r\n\tat org.opencloudb.net.NIOSocketWR.asynRead(NIOSocketWR.java:186)\r\n\tat org.opencloudb.net.AbstractConnection.asynRead(AbstractConnection.java:268)\r\n\tat org.opencloudb.net.NIOReactor$RW.run(NIOReactor.java:96)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n\r\n10-21 13:29:13.921   WARN [$_NIOREACTOR-2-RW] (SingleNodeHandler.java:187) -execute  sql err : errno:1023 program err:java.nio.BufferOverflowException con:MySQLConnection [id=26, lastTime=1445405348578, schema=flight, old shema=flight, borrowed=true, fromSlaveDB=true, threadId=54897, charset=utf8, txIsolation=3, autocommit=true, attachment=dataNode2{SHOW STATUS}, respHandler=SingleNodeHandler [node=dataNode2{SHOW STATUS}, packetId=-85], host=192.168.5.11, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@5dcdf1, writeQueue=0, modifiedSQLExecuted=false]\r\n"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/149810513","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/514#issuecomment-149810513","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/514","id":149810513,"user":{"login":"zhuam","id":241174,"avatar_url":"https://avatars.githubusercontent.com/u/241174?v=3","gravatar_id":"","url":"https://api.github.com/users/zhuam","html_url":"https://github.com/zhuam","followers_url":"https://api.github.com/users/zhuam/followers","following_url":"https://api.github.com/users/zhuam/following{/other_user}","gists_url":"https://api.github.com/users/zhuam/gists{/gist_id}","starred_url":"https://api.github.com/users/zhuam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhuam/subscriptions","organizations_url":"https://api.github.com/users/zhuam/orgs","repos_url":"https://api.github.com/users/zhuam/repos","events_url":"https://api.github.com/users/zhuam/events{/privacy}","received_events_url":"https://api.github.com/users/zhuam/received_events","type":"User","site_admin":false},"created_at":"2015-10-21T08:06:06Z","updated_at":"2015-10-21T08:06:06Z","body":"测试\r\n\r\n开启压缩\r\nMYSQL直连 与 MYCAT连，不论怎么调优性能相差 5-10倍，返回的结果集数据越大，越明显\r\n\r\n不开启压缩\r\nMYSQL直连 与 MYCAT连 ，单条SQL返回的耗时，相差不大\r\n\r\n注：官方的MYSQL压缩与不压缩之间的性能消耗相差不大\r\n"}}