…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…on my personal Amazon micro instance. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query…on CentOS release 4.7 MySQL setting There were two cases considered CPU- and IO-bound. Each case had three options: logging turned off; logging queries…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…on 32 bit we cannot turn up the innodb_buffer_pool higher than 1.8G right? 2.4 kernel (cannot change to…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.log…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…on current research in data structures by professors at Stony Brook, Rutgers, and MIT). I can’t say exactly how…log reporting queries. By log analyzing I mean any kind of log producing application, it can be from simple apache logs put into mysql, application performance logs to…
