MySQL-ERROR |
MySQL meldet: Table 'fhem.proc' doesn't exist |
Fehler bei der Anfrage: TRUNCATE `proc`; |
MySQL-ERROR |
MySQL meldet: Table 'fhem.proc' doesn't exist |
Fehler bei der Anfrage: ALTER TABLE `proc` AUTO_INCREMENT = 1; |
Tabelle `proc` wurde geleert, und die Indizes wurden zurückgesetzt.
Tabellen-Ansicht
31 Tabellen
Ansicht: kompakt Die Abfrage enthält 20 Spalten | |||||||||||||||||||||
# | Max_index_length | Name | Temporary | Rows | Data_length | Auto_increment | Avg_row_length | Max_data_length | Comment | Row_format | Index_length | Data_free | Collation | Create_time | Update_time | Check_time | Create_options | Version | Engine | Checksum | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1. | 0 | 0.00 B | 0.00 B | 256.00 TB | Statistics on Columns | Dynamic | 4.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 22:59:09 | 2024-05-19 22:59:09 | 10 | MyISAM | |||||||
2. | 0 | 0.00 B | 0.00 B | 249.25 PB | Column privileges | Fixed | 1.00 KB | 0.00 B | utf8_bin | 2023-12-08 15:21:01 | 2024-05-19 22:38:06 | 2024-05-19 22:38:06 | 10 | MyISAM | |||||||
3. | 0 | 0.00 B | 0.00 B | 158.25 PB | Database privileges | Fixed | 4.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 20:02:22 | 2024-05-19 20:02:22 | 10 | MyISAM | |||||||
4. | 0 | 0.00 B | 0.00 B | 24.25 PB | Events | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-12-04 23:07:33 | 2024-05-19 19:10:44 | 2024-05-19 19:10:44 | 10 | MyISAM | |||||||
5. | 0 | 0.00 B | 0.00 B | 96.25 PB | User defined functions | Fixed | 1.00 KB | 0.00 B | utf8_bin | 2023-12-04 20:48:42 | 2024-05-19 23:21:12 | 2024-05-19 23:21:12 | 10 | MyISAM | |||||||
6. | 0 | 0.00 B | 0.00 B | 0.00 B | General log | Dynamic | 0.00 B | 0.00 B | utf8_general_ci | 10 | CSV | ||||||||||
7. | 0 | 16.00 KB | 0.00 B | 0.00 B | Replication slave GTID position | Dynamic | 0.00 B | 0.00 B | latin1_swedish_ci | 2023-12-07 23:27:22 | 10 | InnoDB | |||||||||
8. | 0 | 9.24 KB | 193.00 B | 48.25 PB | help categories | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-12-04 19:12:18 | 2024-05-19 22:18:16 | 2024-05-19 22:18:16 | 10 | MyISAM | |||||||
9. | 0 | 20.20 KB | 197.00 B | 49.25 PB | help keywords | Fixed | 4.00 KB | 0.00 B | utf8_general_ci | 2023-11-24 10:15:35 | 2024-05-19 20:45:04 | 2024-05-19 20:45:04 | 10 | MyISAM | |||||||
10. | 0 | 1.72 KB | 9.00 B | 2.25 PB | keyword-topic relation | Fixed | 5.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 22:00:02 | 2024-05-19 22:00:02 | 10 | MyISAM | |||||||
11. | 0 | 1.79 MB | 2.28 KB | 256.00 TB | help topics | Dynamic | 1.00 KB | 0.00 B | utf8_general_ci | 2023-12-04 18:34:59 | 2024-05-19 23:28:29 | 2024-05-19 23:28:29 | 10 | MyISAM | |||||||
12. | 0 | 0.00 B | 0.00 B | 97.75 PB | Host privileges; Merged with database privileges | Fixed | 2.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 23:28:28 | 2024-05-19 23:28:28 | 10 | MyISAM | |||||||
13. | 0 | 0.00 B | 0.00 B | 256.00 TB | Statistics on Indexes | Dynamic | 4.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 19:31:38 | 2024-05-19 19:31:38 | 10 | MyISAM | |||||||
14. | 0 | 16.00 KB | 481.00 B | 0.00 B | Dynamic | 0.00 B | 0.00 B | utf8_bin | 2023-12-08 18:52:47 | stats_persistent=0 | 10 | InnoDB | |||||||||
15. | 0 | 16.00 KB | 2.29 KB | 0.00 B | Dynamic | 0.00 B | 0.00 B | utf8_bin | 2023-12-09 00:33:37 | stats_persistent=0 | 10 | InnoDB | |||||||||
16. | 0 | 0.00 B | 0.00 B | 256.00 TB | MySQL plugins | Dynamic | 1.00 KB | 0.00 B | utf8_general_ci | 2023-12-04 14:51:40 | 2024-05-19 21:31:55 | 2024-05-19 21:31:55 | 10 | MyISAM | |||||||
17. | 0 | 364.00 B | 182.00 B | 256.00 TB | Stored Procedures | Dynamic | 4.00 KB | 0.00 B | utf8_general_ci | 2023-12-23 19:46:10 | 2024-05-19 23:28:28 | 2024-05-19 23:28:28 | 10 | MyISAM | |||||||
18. | 0 | 0.00 B | 0.00 B | 201.50 PB | Procedure privileges | Fixed | 2.00 KB | 0.00 B | utf8_bin | 2023-12-08 22:39:22 | 2024-05-19 20:25:10 | 2024-05-19 20:25:10 | 10 | MyISAM | |||||||
19. | 0 | 1.24 KB | 1.24 KB | 317.00 PB | User proxy privileges | Fixed | 7.00 KB | 0.00 B | utf8_bin | 2023-12-08 18:20:47 | 2024-05-19 22:38:06 | 2024-05-19 22:38:06 | 10 | MyISAM | |||||||
20. | 0 | 0.00 B | 0.00 B | 45.25 PB | Granted roles | Fixed | 1.00 KB | 0.00 B | utf8_bin | 2023-12-02 02:24:01 | 2024-05-19 20:25:10 | 2024-05-19 20:25:10 | 10 | MyISAM | |||||||
21. | 0 | 0.00 B | 0.00 B | 256.00 TB | MySQL Foreign Servers table | Dynamic | 1.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 19:10:43 | 2024-05-19 19:10:43 | 10 | MyISAM | |||||||
22. | 0 | 0.00 B | 0.00 B | 0.00 B | Slow log | Dynamic | 0.00 B | 0.00 B | utf8_general_ci | 10 | CSV | ||||||||||
23. | 0 | 0.00 B | 0.00 B | 256.00 TB | Statistics on Tables | Dynamic | 1.00 KB | 0.00 B | utf8_bin | 2023-12-08 16:49:54 | 2024-05-19 20:53:54 | 2024-05-19 20:53:54 | 10 | MyISAM | |||||||
24. | 0 | 0.00 B | 0.00 B | 308.75 PB | Table privileges | Fixed | 4.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 23:28:28 | 2024-05-19 23:28:28 | 10 | MyISAM | |||||||
25. | 0 | 0.00 B | 1 | 0.00 B | 1.75 PB | Time zones | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-11-20 19:01:31 | 2024-05-19 23:28:28 | 2024-05-19 23:28:28 | 10 | MyISAM | ||||||
26. | 0 | 0.00 B | 0.00 B | 3.25 PB | Leap seconds information for time zones | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 23:21:12 | 2024-05-19 23:21:12 | 10 | MyISAM | |||||||
27. | 0 | 0.00 B | 0.00 B | 49.25 PB | Time zone names | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 19:10:44 | 2024-05-19 19:10:44 | 10 | MyISAM | |||||||
28. | 0 | 0.00 B | 0.00 B | 4.25 PB | Time zone transitions | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 19:10:44 | 2024-05-19 19:10:44 | 10 | MyISAM | |||||||
29. | 0 | 0.00 B | 0.00 B | 9.50 PB | Time zone transition types | Fixed | 1.00 KB | 0.00 B | utf8_general_ci | 2023-10-03 19:18:50 | 2024-05-19 19:31:38 | 2024-05-19 19:31:38 | 10 | MyISAM | |||||||
30. | 0 | 16.00 KB | 0.00 B | 0.00 B | Dynamic | 48.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | stats_persistent=0 | 10 | InnoDB | |||||||||
31. | 0 | 284.00 B | 94.00 B | 256.00 TB | Users and global privileges | Dynamic | 4.00 KB | 0.00 B | utf8_bin | 2023-10-03 19:18:50 | 2024-05-19 19:31:38 | 2024-05-19 19:31:38 | 10 | MyISAM |