…MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query…query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query…INSERT…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…MySQL 5.5.16, including all the bug fixes in it, Percona Server…to remove the overhead and make it faster. By reading the rows for “INSERT…to the server. #785489 (Alexey Kopytov). The Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow…the following links: …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL…MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the server to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to…insert_idblogpercona.commanual Last_query…server…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
…servers were slowing down in a very puzzling way over a short time span (a couple of hours). Queries were taking multiple seconds to…before — for example, a query cache bottleneck, or an insert buffer bottleneck, or … we needed to disable auto-learn, (++text files and saving links to reference …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/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…
