….TABLE_SCHEMA, s.TABLE_NAME, s.INDEX_NAME FROM information_schema.statistics `s` LEFT JOIN information_schema.index_statistics INDXS ON (s.TABLE_SCHEMA = INDXS.TABLE_SCHEMA…) As you see query is not fast, mainly because information_schema.statistics is slow by itself, but in any case very helpful. For…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… information_schema to see how much memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema… and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE… good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to do…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
…_length, 2) idxfrac FROM information_schema.TABLES ORDER BY data_length + index_length DESC LIMIT 10; +————————————-+——–+——–+——–+————+———+ | concat(table_schema,’.',table_name) | rows | data… a lot about your schema this way. It is also worth to note queries on information_schema can be rather slow if you have…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…Debian | | microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona | GPL | | |…_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics; +————————-+———–+————–+———————-+ | TABLE_NAME |…
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
… patches were added: profiling_slow.patch This patch adds information from SHOW PROFILE to query information in slow.log output. profiling_server. … created when new db is created. New information_schema table innodb_rseg shows information about all rollback segments innodb_thread_concurrency_…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…_getrusage were merged into the Slow Query Log page. (Oleg Tsarev) Other Changes Additional information was added to the LOG …. (Vadim Tkachenko) The INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita) Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS …
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
…io_pattern.patch | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN | | microsec…| GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona | GPL | | | mysqld_safe_syslog.patch | …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also as a command…. Bug fixed #1105726 (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision variable was set…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set…, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also as a command…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… using InnoDB and talking about locking – that is what the INFORMATION_SCHEMA.INNODB_LOCK_WAITS table is for: http://dev.mysql.com…/refman/5.5/en/innodb-information-schema-transactions.html#innodb-information-schema-examples Finally, the standard MySQL has had microsecond slow query log (not table…
