…/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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…log_outputblogpercona.commanual log_queries_not_using_indexesblogpercona.commanual log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow_slave_statementsblogpercona.commanual log…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 10 Comments
… sample database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT * FROM nicer_… | | end | 0.000002 | 0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1 | 0.0000010000 | +———————-+———-+——-+——-+————–+ Much…
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: 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 … order query come in the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log ORDER BY start_time DESC LIMIT 100 you would find new queries coming…
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: 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…
