Hi, I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a…:autoextend innodb_log_group_home_dir = /usr/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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done … MEMORY tables which are allocated for query execution, which size can be controlled… TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS:…memory leaks like valgrind are too slow to run in production. So the…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…meeting last week, so we are a little slow to blog about this and acknowledge the …for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins…, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5….
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…: 984 InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages…. 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: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some…_db # Hosts localhost # InnoDB trxID 1153145C (2/0%), 11531626 (2/0%)… 43 more # Last errno 0 # Users prod # Query_time distribution # 1us… into a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
… might see queries which previously performed well suddenly show up on slow query log until InnoDB again updates the statistics. But when does InnoDB perform the… and InnoDB plugin’s manual: Metadata commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…-resolve is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in… 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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query may take…=3000 innodb_log_file_size=128M innodb_flush_log_at_trx_commit=1 innodb_file_per_table table_cache=2000 Depending on workload different InnoDB buffer…
