… MySQL server, you would see an entry like this in the slow query log: #…logging all queries in this fashion as opposed to the general query log, enables us to have the statistics available after the query…s analyze another query, this time query ranked #4 by pt-query-digest. # Query 4: 0.12 QPS,…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… see for simple queries due to generally fatter code. The problem in both cases was MySQL 5.0 broken…flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to… may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…whole another meaning in MySQL 5.0 MySQL generally supports legacy storage …MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL…query log (you can use mk-query-digest with tcpdump to sniff out queries if you can’t enable log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…query log, is one of the more fruitful ways to analyze the system. What I usually do is ask the client to enable…logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…production server: First, I enabled the general query log in my production …general query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql…4, $3, $2-1, “20″.$1); $dt_min = $datetime if (($datetime < $dt_min) || !(defined $dt_min)); } # query…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql…query log remained enabled – probably it caused so little overhead because there were no slow queries…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…in memory tables. So first MySQL versions did not bother naming… single insert statement. concurrent_insert – Enables concurrent insert (while Selects are …logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query… MyISAM tables still keep it 4-32MB to be used for …
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… been there for some time, but only for earlier MySQL editions such as 4.1 and 5.0. Now it’s also… course enable slow logging with –slow-query-log parameter. MySQL 5.1 has this nice feature which allows you to redirect query log (it’s actually called general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on statement execution, which generally…, undo log entries 1 MySQL thread id 1794760, query id … asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex 00000005; asc ;; —————— —TRANSACTION …
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
…query information in slow.log output. profiling_server. This variable ( ON / OFF ) enables profiling of all queries…log_slow_rate_limit logs all queries on a connection after a >1s query Bug #378761: compilation fails on 5.0.77 Bug #381900: mysql…general…
