Percona's MySQL & InnoDB performance and scalability blog
…mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1032677 | | last_optimized_word | | | deleted_doc_count…
…information_schema.TABLES GROUP BY table_schema ORDER BY sum(data_length+index_length) DESC LIMIT 10; +——–+——————–+——-+——-+——-+————+———+ | tables | table_schema | rows…
…schema with one command: mysql> create table index_analysis.used_indexes select * from information_schema…count(*) as COLUMN_CNT, group_concat( i.column_name order by SEQ_IN_INDEX ASC SEPARATOR ‘,’) as COLUMN_NAMES from information_schema…
…schema from one shard. The schema…information…row count (the first number is wall time, the second exec time, the third parse time). $ echo “select count…
Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted to post little… see number of rows in millions and data and index size in GB so I can save on counting zeros. The last…’ve added INFORMATION_SCHEMA to the query so it works whatever database you have active. It does not work with MySQL before 5…
… tables”. mysql> select count(*),sum(data_length) from information_schema.tables; +———-+——————+ | count(*) | sum(data_length) | +———-+——————+ | 143 | 159672656 | +———-+——————+ 1 row in set (1.86 sec) mysql> set global… OK, 0 rows affected (0.00 sec) mysql> select count(*),sum(data_length) from information_schema.tables; +———-+——————+ | count(*) | sum(data_length) | +———-+——————+ | 143 | 159672656 | +———-+——————+ 1 row in set…
… mysql> select count(*) from information_schema.table_statistics\G *************************** 1. row *************************** count(*): 269 1 row in set (0.00 sec) mysql> select count(*) from `table_statistics`\G *************************** 1. row *************************** count(*): 269 1 row…
… fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this … following query: select table_schema, table_name, page_type, count(*) from information_schema.innodb_buffer_pool_content group by… no database or table name — the second row in the table above. Those are a …
…INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics; +————————-+———–+————–+———————-+ | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS…
…information_schema.TABLES ORDER BY data_length+index_length DESC LIMIT 10; +———————————————-+——–+——-+——-+————+———+ | concat(table_schema,’.',table_name) | rows…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.