…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query will surely… on the system as a whole. The queries the system runs, and hence the slow query log, is one of the more fruitful… 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…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… case InnoDB is not used for the query execution that information is written into the log instead the above statistics. The full slow log entry for a query using InnoDB can look like this: # User@Host: macko[macko] @ localhost [] # Thread_id: 4 # Query_time…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… 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 executed in our database. After capturing enough data and copying the slow query… 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…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…/sys/5.5.8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M…_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… table from mysqldump, the query that scans data by primary key was slow. How slow ? Let me show. The query in question is (Q1… | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 37864 | | Innodb_scan_pages_jumpy | 574 | +——————————+——-+ 2 rows in set (0.00 sec) and extended stats: # Query_time… with queries scan many records by secondary key To check if you query affected by fragmentation you can use Innodb_scan_pages_contiguous ; Innodb…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev)…Bug #677407 – The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… query_cache_size = 0M thread_concurrency = 8 max_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_file_path = ibdata1:10000M:autoextend innodb_file…
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… 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…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… 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… slow_query_log_use_global_control. (Oleg Tsarev) Old system variable userstat_running was renamed to userstat. (Oleg Tsarev) Old system variable innodb…
