This MySQL server has been running for 20 days, 11 hours, 36 minutes and 1 seconds. It started up on Jan 03, 2025 at 11:07 AM.
Traffic On a busy server, the byte counters may overrun, so those statistics as reported by the MySQL server may be incorrect. | ø per hour | |
---|---|---|
Received | 7.8 GiB | 16.3 MiB |
Sent | 104.7 GiB | |
Total | 112.6 GiB | 234.5 MiB |
Connections | ø per hour | % | |
---|---|---|---|
max. concurrent connections | 88 | --- | --- |
Failed attempts | 1 | <0.01 | <0.01% |
Aborted | 7 | 0.01 | <0.01% |
Total | 9,886 k | 20.11 k | 100.00% |
Processes | ID | User | Host | Database | Command | Time | Status | SQL query |
---|---|---|---|---|---|---|---|---|
Kill | 9788684 | root | localhost:51486 | zentaoep | Sleep | 6 | --- | --- |
Kill | 9885018 | root | localhost:53666 | zentaoep | Query | 0 | Opening tables | SHOW FULL COLUMNS FROM `zentaoep`.`ztv_productstories` |
Kill | 9885123 | root | localhost:53841 | information_schema | Query | 4 | --- | SELECT COUNT( * ) FROM `information_schema`.`TABLE_CONSTRAINTS` |
Kill | 9885131 | root | localhost:53857 | information_schema | Query | 5 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` |
Kill | 9885169 | root | localhost:53930 | information_schema | Query | 6 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` |
Kill | 9885170 | root | localhost:53932 | information_schema | Query | 4 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` |
Kill | 9885182 | root | localhost:53965 | information_schema | Query | 8 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885217 | root | localhost:54022 | information_schema | Query | 1 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`TABLE_CONSTRAINTS` |
Kill | 9885232 | root | localhost:54053 | information_schema | Query | 0 | --- | SELECT COUNT( * ) FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` |
Kill | 9885270 | root | localhost:54134 | zentaoep | Query | 0 | Opening tables | SHOW COLUMNS FROM `zentaoep`.`zt_searchindex` |
Kill | 9885281 | root | localhost:54153 | information_schema | Query | 6 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885317 | root | localhost:54215 | information_schema | Query | 8 | --- | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885320 | root | localhost:54219 | information_schema | Query | 6 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885377 | root | localhost:54338 | information_schema | Query | 5 | --- | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885395 | root | localhost:54367 | information_schema | Query | 6 | --- | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885452 | root | localhost:54465 | information_schema | Query | 1 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`PARTITIONS` |
Kill | 9885473 | root | localhost:54494 | zentaoep | Query | 0 | Opening tables | SHOW COLUMNS FROM `zentaoep`.`zt_group` |
Kill | 9885556 | root | localhost:54651 | information_schema | Query | 4 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885592 | root | localhost:54711 | information_schema | Query | 3 | --- | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885596 | root | localhost:54716 | information_schema | Query | 2 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885612 | root | localhost:54744 | mysql | Query | 0 | checking permissions | SHOW FULL COLUMNS FROM `mysql`.`help_category` |
Kill | 9885621 | root | localhost:54761 | information_schema | Query | 2 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885628 | root | localhost:54776 | zentaoep | Query | 4 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885631 | root | localhost:54780 | information_schema | Query | 2 | --- | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885659 | root | localhost:54837 | zentaoep | Query | 3 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885664 | root | localhost:54849 | None | Query | 3 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885665 | root | localhost:54851 | information_schema | Query | 2 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885670 | root | localhost:54860 | information_schema | Query | 1 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`KEY_COLUMN_USAGE` |
Kill | 9885704 | root | localhost:54910 | zentaoep | Query | 2 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885725 | root | localhost:54944 | None | Query | 1 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885727 | root | localhost:54947 | zentaoep | Query | 2 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885739 | root | localhost:54972 | mysql | Query | 1 | --- | SHOW TABLE STATUS FROM `mysql` |
Kill | 9885742 | root | localhost:54979 | information_schema | Query | 0 | Opening tables | SELECT COUNT( * ) FROM `information_schema`.`EVENTS` |
Kill | 9885754 | root | localhost:54997 | zentaoep | Query | 1 | Opening tables | SHOW TABLE STATUS FROM `zentaoep` |
Kill | 9885773 | root | localhost:55034 | mysql | Query | 0 | --- | SHOW TABLE STATUS FROM `mysql` |
Kill | 9885777 | root | localhost:55045 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885779 | root | localhost:55047 | performance_schema | Query | 0 | Opening tables | SHOW TABLE STATUS FROM `performance_schema` |
Kill | 9885780 | root | localhost:55049 | mysql | Query | 0 | Opening tables | SELECT * , IF( `Password` = _latin1 '', 'N', 'Y' ) AS 'Password' FROM `mysql`.`user` ORDER BY `U` |
Kill | 9885783 | root | localhost:55056 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885784 | root | localhost:55057 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885785 | root | localhost:55059 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885786 | root | localhost:55060 | information_schema | Query | 0 | removing tmp table | SHOW COLUMNS FROM `information_schema`.`EVENTS` |
Kill | 9885787 | root | localhost:55061 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885789 | root | localhost:55063 | mysql | Query | 0 | --- | SHOW PROCESSLIST |
Kill | 9885790 | root | localhost:55064 | None | Query | 0 | Opening tables | SELECT COUNT( * ) FROM mysql.user |
Kill | 9885791 | root | localhost:55065 | mysql | Sleep | 0 | --- | --- |