…/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M thread_cache…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length…to detect memory leaks like valgrind are too slow to run in production. So the best …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
Hi, I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a…/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… 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: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 2 Comments
… MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and…
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… passes across same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 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
… to the amazing MySQL manual, especially the option and variable reference …conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona.commanual…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the… application time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so…
