SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
bd_dinda | tb_cadastro | 36226417920 | 35 | 363492624 | 5 | 35862925296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 187625856 | 7 | 60875644896 | |
sakila | language | 28518278448 | 152 | 28518278448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 16751818512 | 0 | 0 | 0 | 5 | 8954692560 | |
bd_dinda | tb_mes | 1813145136 | 289 | 1706967504 | 12 | 106177632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 135983232 | 7 | 85699719072 | |
sakila | country | 1301286096 | 280 | 1301286096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 984269616 | 0 | 0 | 0 | 5 | 32759232 | |
sakila | staff | 1128252048 | 11 | 1128252048 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1840026144 | 0 | 0 | 0 | 5 | 36638448 | |
bd_dinda | tb_pagou | 1102077504 | 89 | 1059148992 | 2 | 42928512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 175188816 | 7 | 94069095648 | |
sakila | film | 941235504 | 181 | 941235504 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1799667408 | 0 | 0 | 0 | 5 | 33343728 | |
sakila | inventory | 672476640 | 226 | 672476640 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2367807024 | 0 | 0 | 0 | 5 | 35906112 | |
sakila | actor | 668451696 | 1 | 668451696 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1102330416 | 0 | 0 | 0 | 5 | 55451616 | |
sakila | city | 566080944 | 181 | 566080944 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1489614720 | 0 | 0 | 0 | 5 | 37841760 | |
sakila | rental | 483596784 | 3 | 483596784 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 8902302816 | 0 | 0 | 0 | 5 | 38293200 | |
sakila | customer | 440144496 | 226 | 440144496 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1527938016 | 0 | 0 | 0 | 5 | 30575952 | |
sakila | address | 388830816 | 53 | 388830816 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 63322466592 | 0 | 0 | 0 | 5 | 52632624 | |
orleanzonerp | usuarios | 347569728 | 8 | 347569728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 248785152 | 7 | 94661164752 | |
orleanzonerp | info | 342130800 | 19 | 342130800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 6084201024 | 6 | 52511717280 | |
bd_dinda | tb_pagamentos | 243740640 | 20 | 145817232 | 7 | 97923408 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 113021568 | 8 | 100413803424 | |
orleanzonerp | vehicles | 182328960 | 56 | 182328960 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 2232 | 58944864 | 206 | 8709 | 204063024 | 70 | 160426464 | |
sakila | category | 60262224 | 17 | 60262224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1490392992 | 0 | 0 | 0 | 5 | 43824528 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|