…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
…other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that run …() { chomp; next if /^[^ ]+[ ]*$/; if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) { if (defined $q) { …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit… size could cause performance problems. MySQL Restart MySQL Restarts may …mk-query-digest (Percona Server marks Slave Thread in slow query log…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…performance over data safety for a slave. So you may want to: relax InnoDB durability (innodb_flush_log_at_trx_commit) disable binary logging…slow query logging (with long_query_time = 0) for some time during peak load. Then you can use pt-query-digest to analyze the queries…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…slow queries it just was left in tact. Other important settings: transaction-isolation = READ-COMMITTED…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…commit. For the reasons described above the implementation of Metadata Locking was changed, starting MySQL… | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query |…performed. Let’s see this scenario via a test case: session1 > start transaction; Query…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… the overall performance of your …slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql…logs every second instead of every commit (innodb_flush_log_at_trx_commit=2): Executed 429467 queries Spent 00:00:51.605932 executing queries…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…log_slow_timestamp_every was renamed to slow_query_log_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log…performance. (Oleg Tsarev) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…Query and compare it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL…query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…the server down. You can have slow query log enabled and review it occasionally, but…: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; …fall under Other_commands a few MySQL performance counters broken down by users (full joins…
