Server: mysql wampserver »Database: mysql »Table: innodb_index_stats
Showing rows 0 - 11 (12 total, Query took 0.0552 sec)
SELECT * FROM `innodb_index_stats`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

|
|
Number of rows:
Sort by key:

Full texts database_name table_name index_name last_update stat_name stat_value sample_size stat_description
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'nombres personales\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
nombres personales readme PRIMARY 2023-10-23 20:02:14 n_diff_pfx01 1 1 id
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'nombres personales\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
nombres personales readme PRIMARY 2023-10-23 20:02:14 n_leaf_pages 1 NULLNumber of leaf pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'nombres personales\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
nombres personales readme PRIMARY 2023-10-23 20:02:14 size 1 NULLNumber of pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'readme_to_recover_sz\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
readme_to_recover_sz readme PRIMARY 2023-10-23 20:02:13 n_diff_pfx01 1 1 id
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'readme_to_recover_sz\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
readme_to_recover_sz readme PRIMARY 2023-10-23 20:02:13 n_leaf_pages 1 NULLNumber of leaf pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'readme_to_recover_sz\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
readme_to_recover_sz readme PRIMARY 2023-10-23 20:02:13 size 1 NULLNumber of pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test2\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
test2 readme PRIMARY 2023-10-23 20:02:16 n_diff_pfx01 1 1 id
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test2\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
test2 readme PRIMARY 2023-10-23 20:02:16 n_leaf_pages 1 NULLNumber of leaf pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test2\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
test2 readme PRIMARY 2023-10-23 20:02:16 size 1 NULLNumber of pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test3\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
test3 readme PRIMARY 2023-10-23 20:02:17 n_diff_pfx01 1 1 id
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test3\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
test3 readme PRIMARY 2023-10-23 20:02:17 n_leaf_pages 1 NULLNumber of leaf pages in the index
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'test3\' AND `innodb_index_stats`.`table_name` = \'readme\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
test3 readme PRIMARY 2023-10-23 20:02:17 size 1 NULLNumber of pages in the index
With selected: With selected:

|
|
Number of rows:
Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view