…. Queries/sec: 265 Traffic: 1Mb/sec Connections:259 ‘Aborted_clients’, ’267108′ ‘Aborted_…_reset’, ’0′ ‘Com_stmt_send_long_data’, ’0′ ‘Com_truncate’, ’0′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… toolkit installed. Q: How to make the tools connect to MySQL The slides are now available here, and slide 7 provides…-query-digest. For example, with the sandbox server I used for the examples, it would be pt-query-digest –review S=/tmp/mysql… to lock the table, long running transactions that lock (part of) the table can make the tool abort with a ‘Lock wait…
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… long)+0x15d) [0x7fd959bcc81d] /usr/sbin/mysqld [0x7fd959b5749a] /usr/sbin/mysqld(mysql_execute_command(THD*)+0x40e) [0x7fd959b5afae] /usr/sbin/mysqld(mysql_…abort. Query (0x7fd1bccf90b8): is an invalid pointer Connection ID (thread ID): 495168 Status: NOT_KILLED The manual page at http://dev.mysql…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… run some statistical query or other on a little-used log table. The query took too long to complete, so I aborted with Ctrl-C. In fact, in that version of MySQL, this only caused the client to exit, and left the query…
