… fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server…. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and… fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO… pass any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these three tables should look like this… the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints…
Post: Researching your MySQL table sizes
March 17, 2008 By 28 Comments
…’) total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES WHERE table_name like “%performance_log%”; +——–+———+———+——-+————+———+ | tables | rows | data | idx | total_size…),2) idxfrac FROM information_schema.TABLES GROUP BY table_schema ORDER BY sum(data_length+index_length) DESC LIMIT 10; +——–+——————–+——-+——-+——-+————+———+ | tables | table_schema | rows | data | idx | total_size | idxfrac…
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
… surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for…INSERT INTO stats.TABLES SELECT DATE(NOW()), TABLE_SCHEMA, TABLE_NAME, ENGINE, TABLE_ROWS, DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES; I …
Post: Solving INFORMATION_SCHEMA slowness
December 23, 2011 By 25 Comments
… this slowness is not opening and closing tables, which can be solved with decent table cache size, and which is very fast for… table first time it opens it. Here are some numbers from my test box: mysql> select count(*),sum(data_length) from information_schema.tables… (0.00 sec) mysql> select count(*),sum(data_length) from information_schema.tables; +———-+——————+ | count(*) | sum(data_length) | +———-+——————+ | 130 | 2856365892 | +———-+——————+ 1 row in set…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…tables to Information Schema which makes this information possible. It is just few queries away: SELECT `schema` AS table_schema, innodb_sys_tables.name AS table…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.STATISTICS) When 1 / 16th of the table or… # Bytes_sent: 34187 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 SET timestamp=1316767697; show table status from `db1`; As…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…_total_size from information_schema.tables t join information_schema.statistics i using (table_schema, table_name) join information_schema.innodb_index_stats s using (table_schema, table_name, index_name) where t.table_schema like ‘sakila%’ group by t.table_schema…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…information_schema.innodb_buffer_page_lru where table_name like ‘%ssb%’ group by 1,2 ) sq order by pct_buffer_pool desc; +——————-+——————+——-+——+——+———+—————–+ | table…
