…valuable information: SET GLOBAL slow_query_log=1; SET GLOBAL long_query_time=0; With long_query_time we are logging all queries that are being …2GB of InnoDB Log Files (innodb_log_file_size=1G, innodb_log_files_in_group=2): Executed 429467 queries Spent 00:00:56.772552 executing queries versus …
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: Find unused indexes
June 30, 2012 By Leave a Comment
… SELECT INNODB_INDEX_STATS.TABLE_NAME, INNODB_INDEX_STATS.INDEX_NAME from INNODB_INDEX_STATS WHERE CONCAT(INNODB_INDEX_STATS.index_name, INNODB_INDEX_STATS…index from the slow query log. The concept is easy to understand. pt-index-usage reads the slow query log and execute every query with EXPLAIN to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_…innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… system variable 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_timestamp… to slow_query_log_use_global_control. (Oleg Tsarev) Old system variable userstat_running was renamed to userstat. (Oleg Tsarev) Old system variable innodb…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… crash or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) … some queries when hits were actually occurring. (Oleg Tsarev) Bug #676146 – The development environment test of log_slow_verbosity=innodb…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 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…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log… INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1….
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log… #1100643 (Laurynas Biveinis). InnoDB and the query plan information were being logged even if they weren’t enabled for the slow query log. Bug fixed #730173…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…). Log tracking was initialized too late during the InnoDB startup. Bug fixed #1076892 (Laurynas Biveinis). Temporary files created by binary log … stored procedures correctly, this caused Query_time to increase for every query stored procedure logged to the slow query log. Bug fixed #719386 (Alexey …
