SELECT * FROM `events_statements_summary_by_digest`
|
SCHEMA_NAME | DIGEST | DIGEST_TEXT | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT | SUM_LOCK_TIME | SUM_ERRORS | SUM_WARNINGS | SUM_ROWS_AFFECTED | SUM_ROWS_SENT | SUM_ROWS_EXAMINED | SUM_CREATED_TMP_DISK_TABLES | SUM_CREATED_TMP_TABLES | SUM_SELECT_FULL_JOIN | SUM_SELECT_FULL_RANGE_JOIN | SUM_SELECT_RANGE | SUM_SELECT_RANGE_CHECK | SUM_SELECT_SCAN | SUM_SORT_MERGE_PASSES | SUM_SORT_RANGE | SUM_SORT_ROWS | SUM_SORT_SCAN | SUM_NO_INDEX_USED | SUM_NO_GOOD_INDEX_USED | FIRST_SEEN | LAST_SEEN | QUANTILE_95 | QUANTILE_99 | QUANTILE_999 | QUERY_SAMPLE_TEXT | QUERY_SAMPLE_SEEN | QUERY_SAMPLE_TIMER_WAIT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NULL | a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... | SELECT @@`version` , @@`version_comment` | 8162 | 644664729000 | 24098000 | 78983000 | 2185864000 | 0 | 0 | 0 | 0 | 8162 | 8162 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.289825 | 2024-07-28 03:14:52.073502 | 125892541 | 229086765 | 549540873 | SELECT @@version, @@version_comment | 2024-07-28 03:14:27.314887 | 338657000 | |
NULL | 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... | SET NAMES ? COLLATE ? | 8162 | 352473560000 | 13784000 | 43184000 | 1208787000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.290013 | 2024-07-28 03:14:52.073731 | 72443596 | 144543977 | 251188643 | SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' | 2024-07-28 03:14:49.918754 | 217400000 | |
NULL | 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... | SET `lc_messages` = ? | 8048 | 328682628000 | 11807000 | 40840000 | 3003898000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.290124 | 2024-07-28 03:14:52.073834 | 66069344 | 144543977 | 2187761623 | SET lc_messages = 'en_US' | 2024-07-28 03:14:27.316580 | 188678000 | |
NULL | f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... | SHOW TABLES FROM `phpmyadmin` | 8162 | 1251493893000 | 66555000 | 153331000 | 1863602000 | 516570000000 | 8162 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.290769 | 2024-07-28 03:14:52.074152 | 218776162 | 436515832 | 870963589 | SHOW TABLES FROM `phpmyadmin` | 2024-07-28 03:14:13.425358 | 824325000 | |
NULL | d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... | SET `collation_connection` = ? | 8162 | 394733247000 | 15378000 | 48362000 | 1663590000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.291982 | 2024-07-28 03:14:52.075074 | 87096358 | 144543977 | 275422870 | SET collation_connection = 'utf8mb4_unicode_ci' | 2024-07-28 03:13:57.297125 | 246185000 | |
NULL | caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... | SELECT ? FROM `mysql` . `user` LIMIT ? | 7510 | 1088698987000 | 47295000 | 144966000 | 3809959000 | 535312000000 | 0 | 0 | 0 | 7510 | 7510 | 0 | 0 | 0 | 0 | 0 | 0 | 7510 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.299864 | 2024-07-28 03:14:52.073544 | 208929613 | 251188643 | 870963589 | SELECT 1 FROM mysql.user LIMIT 1 | 2024-07-28 03:14:49.945134 | 689573000 | |
NULL | 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... | SELECT CURRENT_USER ( ) | 892 | 52070800000 | 23407000 | 58375000 | 332425000 | 0 | 0 | 0 | 0 | 892 | 892 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.300288 | 2024-07-28 03:14:52.026824 | 104712854 | 151356124 | 346736850 | SELECT CURRENT_USER() | 2024-07-28 03:14:45.398875 | 100565000 | |
NULL | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | 815 | 481002403000 | 356593000 | 590186000 | 3691290000 | 157902000000 | 0 | 0 | 0 | 815 | 3190 | 0 | 5705 | 0 | 0 | 0 | 0 | 5705 | 0 | 0 | 0 | 0 | 815 | 0 | 2024-07-28 03:01:04.302416 | 2024-07-28 03:14:51.831995 | 831763771 | 1659586907 | 3801893963 | SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... | 2024-07-28 03:14:42.072303 | 805410000 | |
NULL | ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... | SELECT SCHEMA ( ) | 6556 | 369753399000 | 16516000 | 56399000 | 2292679000 | 0 | 0 | 0 | 0 | 6556 | 6556 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.338052 | 2024-07-28 03:14:52.074185 | 100000000 | 125892541 | 229086765 | SELECT DATABASE() | 2024-07-28 03:14:36.861362 | 123616000 | |
mysql | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | SHOW SESSION VARIABLES LIKE ? | 3642 | 3320490463000 | 609295000 | 911721000 | 8082834000 | 346949000000 | 0 | 0 | 0 | 3642 | 2090508 | 0 | 3642 | 0 | 0 | 0 | 0 | 7284 | 0 | 0 | 0 | 0 | 3642 | 0 | 2024-07-28 03:01:04.341753 | 2024-07-28 03:14:51.341016 | 1318256738 | 1995262314 | 3981071705 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | 2024-07-28 03:14:49.485917 | 2329252000 | |
mysql | ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... | SELECT * FROM `user` LIMIT ?, ... | 1769 | 373730808000 | 106061000 | 211266000 | 1980941000 | 131136000000 | 0 | 0 | 0 | 15643 | 15643 | 0 | 0 | 0 | 0 | 0 | 0 | 1769 | 0 | 0 | 0 | 0 | 1769 | 0 | 2024-07-28 03:01:04.342244 | 2024-07-28 03:14:51.194488 | 288403150 | 380189396 | 1995262314 | SELECT * FROM `user` LIMIT 0, 25 | 2024-07-28 03:14:18.477304 | 850178000 | |
mysql | 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... | SHOW WARNINGS | 1776 | 59537447000 | 13918000 | 33523000 | 1047540000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.342509 | 2024-07-28 03:14:51.194832 | 52480746 | 75857757 | 478630092 | SHOW WARNINGS | 2024-07-28 03:14:49.487377 | 477035000 | |
mysql | 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... | SELECT @@`lower_case_table_names` | 2128 | 112812819000 | 25771000 | 53013000 | 455581000 | 0 | 0 | 0 | 0 | 2128 | 2128 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.343042 | 2024-07-28 03:14:51.985062 | 95499258 | 131825673 | 190546071 | SELECT @@lower_case_table_names | 2024-07-28 03:14:43.424182 | 184760000 | |
mysql | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 10203 | 3737273245000 | 72900000 | 366291000 | 3240885000 | 1963657000000 | 1738 | 0 | 0 | 0 | 25395 | 0 | 0 | 0 | 0 | 0 | 0 | 8465 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.345768 | 2024-07-28 03:14:51.986283 | 602559586 | 912010839 | 2511886431 | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | 2024-07-28 03:14:49.488672 | 1055623000 | |
mysql | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 4254 | 4846795167000 | 231163000 | 1139350000 | 10749099000 | 1641771000000 | 339 | 0 | 0 | 197278 | 1006385 | 0 | 3903 | 0 | 0 | 0 | 0 | 3915 | 0 | 0 | 197245 | 3903 | 0 | 0 | 2024-07-28 03:01:04.347673 | 2024-07-28 03:14:51.943893 | 1819700858 | 2884031503 | 6309573444 | SHOW FULL COLUMNS FROM `mysql`.`user` | 2024-07-28 03:14:50.939429 | 1502059000 | |
performance_schema | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | SHOW SESSION VARIABLES LIKE ? | 9047 | 8131733112000 | 585829000 | 898832000 | 5286146000 | 846404000000 | 0 | 0 | 0 | 9047 | 5192978 | 0 | 9047 | 0 | 0 | 0 | 0 | 18094 | 0 | 0 | 0 | 0 | 9047 | 0 | 2024-07-28 03:01:04.359826 | 2024-07-28 03:14:52.075987 | 1258925411 | 1819700858 | 3630780547 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | 2024-07-28 03:14:45.949509 | 2815458000 | |
performance_schema | 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... | SELECT * FROM `table_lock_waits_summary_by_table` ... | 4118 | 1280028215000 | 166122000 | 310837000 | 4713099000 | 313413000000 | 0 | 0 | 0 | 102950 | 102950 | 0 | 0 | 0 | 0 | 0 | 0 | 4118 | 0 | 0 | 0 | 0 | 4118 | 0 | 2024-07-28 03:01:04.364797 | 2024-07-28 03:14:52.049858 | 457088189 | 630957344 | 2630267991 | SELECT * FROM `table_lock_waits_summary_by_table` ... | 2024-07-28 03:14:43.012153 | 553587000 | |
performance_schema | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 14233 | 4524534821000 | 71817000 | 317890000 | 6982509000 | 2091210000000 | 5329 | 0 | 0 | 0 | 26709 | 0 | 0 | 0 | 0 | 0 | 0 | 8903 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.365990 | 2024-07-28 03:14:52.080527 | 549540873 | 758577575 | 2290867652 | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | 2024-07-28 03:14:29.847315 | 1261744000 | |
performance_schema | 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... | SELECT @@`lower_case_table_names` | 4527 | 217559431000 | 22000000 | 48058000 | 1415432000 | 0 | 0 | 0 | 0 | 4527 | 4527 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.366294 | 2024-07-28 03:14:52.053724 | 72443596 | 104712854 | 316227766 | SELECT @@lower_case_table_names | 2024-07-28 03:14:45.777089 | 84535000 | |
mysql | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 2213 | 2091091582000 | 153789000 | 944912000 | 189170775000 | 758104000000 | 280 | 0 | 0 | 3873 | 127173 | 0 | 1933 | 0 | 0 | 0 | 0 | 1933 | 0 | 0 | 3873 | 1933 | 0 | 0 | 2024-07-28 03:01:04.387822 | 2024-07-28 03:14:51.197516 | 1047128548 | 1905460717 | 91201083935 | SHOW INDEXES FROM `mysql`.`user` | 2024-07-28 03:13:57.934037 | 425571000 | |
performance_schema | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 6404 | 6273098860000 | 182240000 | 979559000 | 22067540000 | 2066642000000 | 2260 | 0 | 0 | 4144 | 1739762 | 0 | 4144 | 4144 | 0 | 0 | 0 | 4144 | 0 | 0 | 4144 | 4144 | 4144 | 0 | 2024-07-28 03:01:04.388526 | 2024-07-28 03:14:52.078552 | 1737800828 | 2187761623 | 3981071705 | SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAM... | 2024-07-28 03:14:42.877644 | 1499107000 | |
performance_schema | 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... | SELECT COUNT ( * ) FROM `performance_schema` . `ta... | 4118 | 1636928825000 | 207228000 | 397505000 | 5364849000 | 180167000000 | 0 | 0 | 0 | 4118 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4118 | 0 | 0 | 0 | 0 | 4118 | 0 | 2024-07-28 03:01:04.389647 | 2024-07-28 03:14:52.054988 | 575439937 | 1047128548 | 2187761623 | SELECT COUNT(*) FROM `performance_schema`.`table_l... | 2024-07-28 03:14:08.814561 | 1042664000 | |
mysql | 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... | SELECT @@`have_profiling` | 959 | 48617164000 | 30402000 | 50695000 | 337613000 | 0 | 0 | 959 | 0 | 959 | 959 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.389718 | 2024-07-28 03:14:50.405661 | 75857757 | 104712854 | 346736850 | SELECT @@have_profiling | 2024-07-28 03:14:50.405661 | 83224000 | |
performance_schema | 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... | SHOW WARNINGS | 4524 | 130474048000 | 12005000 | 28840000 | 470311000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.389806 | 2024-07-28 03:14:52.055334 | 45708818 | 66069344 | 165958690 | SHOW WARNINGS | 2024-07-28 03:14:25.630797 | 205208000 | |
mysql | 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... | SHOW CREATE TABLE `mysql` . `user` | 2091 | 416810166000 | 106327000 | 199335000 | 2188638000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-07-28 03:01:04.390682 | 2024-07-28 03:14:51.944640 | 288403150 | 416869383 | 1905460717 | SHOW CREATE TABLE `mysql`.`user` | 2024-07-28 03:14:46.015361 | 515208000 |
|
Warning in ./src/Table/Table.php#291
Backtrace
Warning in ./src/Table/Table.php#291
Backtrace