… last week, so we are a little slow to blog about this and acknowledge the…-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB … for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… you have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0… 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…. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option ….commanual enable_lockingblogpercona.commanual enable_named_pipeblogpercona.commanual enable_…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
… by MySQL to a file with limited amount of additional information. The 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 at least…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… you do in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live… general query log – for example connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to say “all_queries” log and…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat… Percona Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query-digest report: # Overall…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1…traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it … queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_… It is interesting though slow query log remained enabled – probably it caused so little overhead because there were no slow queries it just was left …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… slow query log, is one of the more fruitful ways to analyze the system. What I usually do is ask the client to enable…/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL… microsecond 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…
