Folgende Datenbank(en) befinden sich auf dem MySql-Server:
# | Datenbanken | Tabellen |
---|---|---|
1. | configDB | 4 Tabellen |
2. | fhem | 2 Tabellen |
3. | information_schema | 78 Tabellen |
4. | mysql | 31 Tabellen |
5. | performance_schema | 52 Tabellen |
|
Detail-Information von Datenbank "information_schema"
78 Tabellen# | Tabelle | Datensätze | Größe | letztes Update | Typ | optimiert | Status | Key Status |
---|---|---|---|---|---|---|---|---|
1. | ALL_PLUGINS | 74 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
2. | APPLICABLE_ROLES | 0 | 0.00 B | MEMORY | ||||
3. | CHARACTER_SETS | 40 | 0.00 B | MEMORY | ||||
4. | CHECK_CONSTRAINTS | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
5. | COLLATIONS | 322 | 0.00 B | MEMORY | ||||
6. | COLLATION_CHARACTER_SET_APPLICABILITY | 322 | 0.00 B | MEMORY | ||||
7. | COLUMNS | 1814 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
8. | COLUMN_PRIVILEGES | 0 | 0.00 B | MEMORY | ||||
9. | ENABLED_ROLES | 1 | 0.00 B | MEMORY | ||||
10. | ENGINES | 8 | 0.00 B | MEMORY | ||||
11. | EVENTS | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
12. | FILES | 0 | 0.00 B | MEMORY | ||||
13. | GLOBAL_STATUS | 533 | 0.00 B | MEMORY | ||||
14. | GLOBAL_VARIABLES | 624 | 0.00 B | MEMORY | ||||
15. | KEYWORDS | 677 | 0.00 B | MEMORY | ||||
16. | KEY_CACHES | 1 | 0.00 B | MEMORY | ||||
17. | KEY_COLUMN_USAGE | 45 | 0.00 B | MEMORY | ||||
18. | PARAMETERS | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
19. | PARTITIONS | 167 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
20. | PLUGINS | 54 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
21. | PROCESSLIST | 8 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
22. | PROFILING | 0 | 0.00 B | MEMORY | ||||
23. | REFERENTIAL_CONSTRAINTS | 0 | 0.00 B | MEMORY | ||||
24. | ROUTINES | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
25. | SCHEMATA | 5 | 0.00 B | MEMORY | ||||
26. | SCHEMA_PRIVILEGES | 0 | 0.00 B | MEMORY | ||||
27. | SESSION_STATUS | 533 | 0.00 B | MEMORY | ||||
28. | SESSION_VARIABLES | 642 | 0.00 B | MEMORY | ||||
29. | STATISTICS | 53 | 0.00 B | MEMORY | ||||
30. | SQL_FUNCTIONS | 387 | 0.00 B | MEMORY | ||||
31. | SYSTEM_VARIABLES | 642 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
32. | TABLES | 167 | 0.00 B | MEMORY | ||||
33. | TABLESPACES | 0 | 0.00 B | MEMORY | ||||
34. | TABLE_CONSTRAINTS | 23 | 0.00 B | MEMORY | ||||
35. | TABLE_PRIVILEGES | 0 | 0.00 B | MEMORY | ||||
36. | TRIGGERS | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
37. | USER_PRIVILEGES | 81 | 0.00 B | MEMORY | ||||
38. | VIEWS | 0 | 16.00 KB | 2024-05-07 22:10:00 | Aria | |||
39. | GEOMETRY_COLUMNS | 0 | 0.00 B | MEMORY | ||||
40. | SPATIAL_REF_SYS | 2 | 0.00 B | MEMORY | ||||
41. | CLIENT_STATISTICS | 0 | 0.00 B | MEMORY | ||||
42. | INDEX_STATISTICS | 0 | 0.00 B | MEMORY | ||||
43. | INNODB_SYS_DATAFILES | 10 | 0.00 B | MEMORY | ||||
44. | USER_STATISTICS | 0 | 0.00 B | MEMORY | ||||
45. | INNODB_SYS_TABLESTATS | 15 | 0.00 B | MEMORY | ||||
46. | INNODB_LOCKS | 0 | 0.00 B | MEMORY | ||||
47. | INNODB_MUTEXES | 27 | 0.00 B | MEMORY | ||||
48. | INNODB_CMPMEM | 5 | 0.00 B | MEMORY | ||||
49. | INNODB_CMP_PER_INDEX | 0 | 0.00 B | MEMORY | ||||
50. | INNODB_CMP | 5 | 0.00 B | MEMORY | ||||
51. | INNODB_FT_DELETED | 0 | 0.00 B | MEMORY | ||||
52. | INNODB_CMP_RESET | 5 | 0.00 B | MEMORY | ||||
53. | INNODB_LOCK_WAITS | 0 | 0.00 B | MEMORY | ||||
54. | TABLE_STATISTICS | 0 | 0.00 B | MEMORY | ||||
55. | INNODB_TABLESPACES_ENCRYPTION | 0 | 0.00 B | MEMORY | ||||
56. | INNODB_BUFFER_PAGE_LRU | 6889 | 0.00 B | MEMORY | ||||
57. | INNODB_SYS_FIELDS | 23 | 0.00 B | MEMORY | ||||
58. | INNODB_CMPMEM_RESET | 5 | 0.00 B | MEMORY | ||||
59. | INNODB_SYS_COLUMNS | 56 | 0.00 B | MEMORY | ||||
60. | INNODB_FT_INDEX_TABLE | 0 | 0.00 B | MEMORY | ||||
61. | INNODB_CMP_PER_INDEX_RESET | 0 | 0.00 B | MEMORY | ||||
62. | user_variables | 0 | 0.00 B | MEMORY | ||||
63. | INNODB_FT_INDEX_CACHE | 0 | 0.00 B | MEMORY | ||||
64. | INNODB_SYS_FOREIGN_COLS | 0 | 0.00 B | MEMORY | ||||
65. | INNODB_FT_BEING_DELETED | 0 | 0.00 B | MEMORY | ||||
66. | INNODB_BUFFER_POOL_STATS | 1 | 0.00 B | MEMORY | ||||
67. | INNODB_TRX | 0 | 0.00 B | MEMORY | ||||
68. | INNODB_SYS_FOREIGN | 0 | 0.00 B | MEMORY | ||||
69. | INNODB_SYS_TABLES | 15 | 0.00 B | MEMORY | ||||
70. | INNODB_FT_DEFAULT_STOPWORD | 36 | 0.00 B | MEMORY | ||||
71. | INNODB_FT_CONFIG | 0 | 0.00 B | MEMORY | ||||
72. | INNODB_BUFFER_PAGE | 8191 | 0.00 B | MEMORY | ||||
73. | INNODB_SYS_TABLESPACES | 11 | 0.00 B | MEMORY | ||||
74. | INNODB_METRICS | 250 | 0.00 B | MEMORY | ||||
75. | INNODB_SYS_INDEXES | 21 | 0.00 B | MEMORY | ||||
76. | INNODB_SYS_VIRTUAL | 0 | 0.00 B | MEMORY | ||||
77. | INNODB_TABLESPACES_SCRUBBING | 11 | 0.00 B | MEMORY | ||||
78. | INNODB_SYS_SEMAPHORE_WAITS | 0 | 0.00 B | MEMORY | ||||
insgesamt | 22.801 | 192.00 KB | 2024-05-07 22:10:00 |