…) * Extended “MySQL Threads” graph with all kind of threads (bug 1157911) * Some Cacti single-item …) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) …customers with a Percona Support contract and free installation services are provided as part of …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…| query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000016 | | cleaning up | 0.000004 | …time waiting in the “Opening tables” state. Now this behavior with respect …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…: mtr_commit (sync0sync.ic:221) ==9090== by 0x6B39223: fsp_fill_free_list (fsp0fsp.c:1455) ==9090== by 0x6B3DED8: fsp_header_init…_table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090== by 0x6A7D72: mysql_select(THD*, Item***, TABLE…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT…_id GROUP BY STATE ORDER BY Total_R DESC; +———————-+———-+——-+——-+————–+ | STATE | Total_R | …| 0.000032 | 0.02 | 1 | 0.0000320000 | | freeing items | 0.000027 | 0.02 | 2 | 0.0000135000…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL…state = p2.state order by p1.duration desc; +—–+———————-+———–+———-+———–+———–+——-+——-+————–+————–+——-+——-+ | seq | state… | 14 | 14 | | 16 | freeing items | 0.000049 |…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…it reflect natural state of the table as it would be in the production over time: mysql> show table… Max_data_length: 0 Index_length: 9047113728 Data_free: 6291456 Auto_increment: NULL Create_time: 2012-12…with even in regards to such a minor item – Database Scientists will never have their job…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
… | 0.000008 | | query end | 0.000004 | | closing tables | 0.000032 | | freeing items | 0.000035 | | logging slow query | 0.000004 | | cleaning up | 0…MySQL need so many accesses to the query cache lock? The answer is in the way the query cache works. Simply stated…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…” which is quite helpful for MySQL Performance optimization tasks but there…one of the reason for previous item. Query cache catches network packets… – Different transactions may see different states of the database, depending on…value of Qcache_free_blocks relatively to Qcache_free_memory. FLUSH QUERY…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…state: clean Errors behavior: Continue Filesystem OS type: Linux Inode count: 226918400 Block count: 3630694400 Reserved block count: 0 Free blocks: 3616208434 Free…11 This has a lot of interesting items and I’ll get into some… for partition you store MySQL data on, as chances are MySQL server is only…
