SQL-Browser

[Tools]  Database: `information_schema`  Table: `INNODB_SYS_DATAFILES`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

MySQL-ERROR
MySQL says:
Incorrect table name ''

Error in Query:
DROP TABLE ``Name`="INNODB_SYS_DATAFILES" AND `Data_length`="0" AND `Avg_row_length`="12007" AND `Max_data_length`="33547558" AND `Comment`="" AND `Row_format`="Fixed" AND `Index_length`="0" AND `Data_free`="0" AND `Collation`="utf8_general_ci" AND `Create_time`="2024-07-15 00:22:05" AND `Create_options`="max_rows=2794" AND `Version`="11" AND `Engine`="MEMORY" AND `Max_index_length`="0" AND `Temporary`="Y"`

Record was deleted

Table View

Edit Tables

82 Tables

View: compact   The Query contains 20 Columns
 # 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
  edit  empty  empty and reset indexes  delete  1. 
Show data ALL_PLUGINS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=10380835156842741 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  2. 
Show data APPLICABLE_ROLES
0.00 B
980.00 B
31.87 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=34239
11
MEMORY
  edit  empty  empty and reset indexes  delete  3. 
Show data CHARACTER_SETS
0.00 B
384.00 B
31.35 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=87381
11
MEMORY
  edit  empty  empty and reset indexes  delete  4. 
Show data CHECK_CONSTRAINTS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=8587869680497929 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  5. 
Show data COLLATIONS
0.00 B
231.00 B
31.86 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=145257
11
MEMORY
  edit  empty  empty and reset indexes  delete  6. 
Show data COLLATION_CHARACTER_SET_APPLICABILITY
0.00 B
195.00 B
31.20 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=172074
11
MEMORY
  edit  empty  empty and reset indexes  delete  7. 
Show data COLUMNS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=2982497020809951 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  8. 
Show data COLUMN_PRIVILEGES
0.00 B
2.83 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=11598
11
MEMORY
  edit  empty  empty and reset indexes  delete  9. 
Show data ENABLED_ROLES
0.00 B
388.00 B
31.67 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=86480
11
MEMORY
  edit  empty  empty and reset indexes  delete  10. 
Show data ENGINES
0.00 B
732.00 B
31.83 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=45839
11
MEMORY
  edit  empty  empty and reset indexes  delete  11. 
Show data EVENTS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=672649652629432 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  12. 
Show data FILES
0.00 B
3.91 KB
31.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=8380
11
MEMORY
  edit  empty  empty and reset indexes  delete  13. 
Show data GLOBAL_STATUS
0.00 B
6.19 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5292
11
MEMORY
  edit  empty  empty and reset indexes  delete  14. 
Show data GLOBAL_VARIABLES
0.00 B
6.19 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5292
11
MEMORY
  edit  empty  empty and reset indexes  delete  15. 
Show data KEYWORDS
0.00 B
195.00 B
31.20 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=172074
11
MEMORY
  edit  empty  empty and reset indexes  delete  16. 
Show data KEY_CACHES
0.00 B
660.00 B
31.81 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=50840
11
MEMORY
  edit  empty  empty and reset indexes  delete  17. 
Show data KEY_COLUMN_USAGE
0.00 B
4.53 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=7234
11
MEMORY
  edit  empty  empty and reset indexes  delete  18. 
Show data OPTIMIZER_TRACE
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=636094623231363848 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  19. 
Show data PARAMETERS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=6630749127861089 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  20. 
Show data PARTITIONS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=6153016702371431 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  21. 
Show data PLUGINS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=10380835156842741 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  22. 
Show data PROCESSLIST
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=16739332190299048 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  23. 
Show data PROFILING
0.00 B
309.00 B
31.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=108590
11
MEMORY
  edit  empty  empty and reset indexes  delete  24. 
Show data REFERENTIAL_CONSTRAINTS
0.00 B
4.70 KB
31.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=6968
11
MEMORY
  edit  empty  empty and reset indexes  delete  25. 
Show data ROUTINES
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=633908731055311 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  26. 
Show data SCHEMATA
0.00 B
6.39 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5131
11
MEMORY
  edit  empty  empty and reset indexes  delete  27. 
Show data SCHEMA_PRIVILEGES
0.00 B
2.45 KB
31.93 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=13384
11
MEMORY
  edit  empty  empty and reset indexes  delete  28. 
Show data SESSION_STATUS
0.00 B
6.19 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5292
11
MEMORY
  edit  empty  empty and reset indexes  delete  29. 
Show data SESSION_VARIABLES
0.00 B
6.19 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5292
11
MEMORY
  edit  empty  empty and reset indexes  delete  30. 
Show data STATISTICS
0.00 B
5.62 KB
31.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5831
11
MEMORY
  edit  empty  empty and reset indexes  delete  31. 
Show data SQL_FUNCTIONS
0.00 B
195.00 B
31.20 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=172074
11
MEMORY
  edit  empty  empty and reset indexes  delete  32. 
Show data SYSTEM_VARIABLES
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=578068505333883 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  33. 
Show data TABLES
0.00 B
14.49 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=2262
11
MEMORY
  edit  empty  empty and reset indexes  delete  34. 
Show data TABLESPACES
0.00 B
6.79 KB
31.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=4826
11
MEMORY
  edit  empty  empty and reset indexes  delete  35. 
Show data TABLE_CONSTRAINTS
0.00 B
2.45 KB
31.90 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=13400
11
MEMORY
  edit  empty  empty and reset indexes  delete  36. 
Show data TABLE_PRIVILEGES
0.00 B
2.64 KB
31.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=12427
11
MEMORY
  edit  empty  empty and reset indexes  delete  37. 
Show data TRIGGERS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=619080581055460 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  38. 
Show data USER_PRIVILEGES
0.00 B
2.26 KB
31.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=14500
11
MEMORY
  edit  empty  empty and reset indexes  delete  39. 
Show data VIEWS
8.00 KB
0.00 B
4.00 PB
Page
8.00 KB
0.00 B
utf8_general_ci
2024-09-21 01:19:06
2024-09-21 01:19:06
max_rows=6618853273666864 transactional=0
11
Aria
  edit  empty  empty and reset indexes  delete  40. 
Show data CLIENT_STATISTICS
0.00 B
386.00 B
31.51 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=86928
11
MEMORY
  edit  empty  empty and reset indexes  delete  41. 
Show data INDEX_STATISTICS
0.00 B
1.70 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=19250
11
MEMORY
  edit  empty  empty and reset indexes  delete  42. 
Show data INNODB_SYS_DATAFILES
0.00 B
11.73 KB
31.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=2794
11
MEMORY
  edit  empty  empty and reset indexes  delete  43. 
Show data GEOMETRY_COLUMNS
0.00 B
4.14 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=7906
11
MEMORY
  edit  empty  empty and reset indexes  delete  44. 
Show data INNODB_SYS_TABLESTATS
0.00 B
250.00 B
31.25 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=134217
11
MEMORY
  edit  empty  empty and reset indexes  delete  45. 
Show data SPATIAL_REF_SYS
0.00 B
7.51 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=4362
11
MEMORY
  edit  empty  empty and reset indexes  delete  46. 
Show data INNODB_BUFFER_PAGE
0.00 B
3.47 KB
31.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=9436
11
MEMORY
  edit  empty  empty and reset indexes  delete  47. 
Show data INNODB_TRX
0.00 B
4.33 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=7574
11
MEMORY
  edit  empty  empty and reset indexes  delete  48. 
Show data INNODB_CMP_PER_INDEX
0.00 B
600.00 B
31.58 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=55924
11
MEMORY
  edit  empty  empty and reset indexes  delete  49. 
Show data INNODB_METRICS
0.00 B
1.79 KB
31.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=18335
11
MEMORY
  edit  empty  empty and reset indexes  delete  50. 
Show data INNODB_LOCK_WAITS
0.00 B
505.00 B
31.56 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=66444
11
MEMORY
  edit  empty  empty and reset indexes  delete  51. 
Show data INNODB_CMP
0.00 B
25.00 B
25.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1342177
11
MEMORY
  edit  empty  empty and reset indexes  delete  52. 
Show data THREAD_POOL_WAITS
0.00 B
58.00 B
29.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=578524
11
MEMORY
  edit  empty  empty and reset indexes  delete  53. 
Show data INNODB_CMP_RESET
0.00 B
25.00 B
25.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1342177
11
MEMORY
  edit  empty  empty and reset indexes  delete  54. 
Show data THREAD_POOL_QUEUES
0.00 B
30.00 B
30.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1118481
11
MEMORY
  edit  empty  empty and reset indexes  delete  55. 
Show data TABLE_STATISTICS
0.00 B
1.15 KB
31.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=28411
11
MEMORY
  edit  empty  empty and reset indexes  delete  56. 
Show data INNODB_SYS_FIELDS
0.00 B
206.00 B
31.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=162885
11
MEMORY
  edit  empty  empty and reset indexes  delete  57. 
Show data INNODB_BUFFER_PAGE_LRU
0.00 B
3.48 KB
31.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=9428
11
MEMORY
  edit  empty  empty and reset indexes  delete  58. 
Show data INNODB_LOCKS
0.00 B
30.27 KB
31.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1082
11
MEMORY
  edit  empty  empty and reset indexes  delete  59. 
Show data INNODB_FT_INDEX_TABLE
0.00 B
1.03 KB
31.94 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=31835
11
MEMORY
  edit  empty  empty and reset indexes  delete  60. 
Show data INNODB_CMPMEM
0.00 B
29.00 B
29.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1157049
11
MEMORY
  edit  empty  empty and reset indexes  delete  61. 
Show data THREAD_POOL_GROUPS
0.00 B
27.00 B
27.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1242756
11
MEMORY
  edit  empty  empty and reset indexes  delete  62. 
Show data INNODB_CMP_PER_INDEX_RESET
0.00 B
600.00 B
31.58 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=55924
11
MEMORY
  edit  empty  empty and reset indexes  delete  63. 
Show data INNODB_SYS_FOREIGN_COLS
0.00 B
972.00 B
31.87 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=34521
11
MEMORY
  edit  empty  empty and reset indexes  delete  64. 
Show data INNODB_FT_INDEX_CACHE
0.00 B
1.03 KB
31.94 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=31835
11
MEMORY
  edit  empty  empty and reset indexes  delete  65. 
Show data INNODB_BUFFER_POOL_STATS
0.00 B
225.00 B
31.03 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=149130
11
MEMORY
  edit  empty  empty and reset indexes  delete  66. 
Show data INNODB_FT_BEING_DELETED
0.00 B
9.00 B
18.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=3728270
11
MEMORY
  edit  empty  empty and reset indexes  delete  67. 
Show data INNODB_SYS_FOREIGN
0.00 B
1.71 KB
31.85 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=19152
11
MEMORY
  edit  empty  empty and reset indexes  delete  68. 
Show data INNODB_CMPMEM_RESET
0.00 B
29.00 B
29.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1157049
11
MEMORY
  edit  empty  empty and reset indexes  delete  69. 
Show data INNODB_FT_DEFAULT_STOPWORD
0.00 B
56.00 B
28.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=599186
11
MEMORY
  edit  empty  empty and reset indexes  delete  70. 
Show data INNODB_SYS_TABLES
0.00 B
1.95 KB
31.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=16819
11
MEMORY
  edit  empty  empty and reset indexes  delete  71. 
Show data INNODB_SYS_COLUMNS
0.00 B
222.00 B
31.71 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=151146
11
MEMORY
  edit  empty  empty and reset indexes  delete  72. 
Show data INNODB_FT_CONFIG
0.00 B
1.14 KB
31.86 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=28851
11
MEMORY
  edit  empty  empty and reset indexes  delete  73. 
Show data USER_STATISTICS
0.00 B
567.00 B
31.94 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=59178
11
MEMORY
  edit  empty  empty and reset indexes  delete  74. 
Show data INNODB_SYS_TABLESPACES
0.00 B
2.02 KB
31.88 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=16194
11
MEMORY
  edit  empty  empty and reset indexes  delete  75. 
Show data INNODB_SYS_VIRTUAL
0.00 B
17.00 B
22.67 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1973790
11
MEMORY
  edit  empty  empty and reset indexes  delete  76. 
Show data INNODB_SYS_INDEXES
0.00 B
230.00 B
31.72 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=145888
11
MEMORY
  edit  empty  empty and reset indexes  delete  77. 
Show data INNODB_SYS_SEMAPHORE_WAITS
0.00 B
58.78 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=557
11
MEMORY
  edit  empty  empty and reset indexes  delete  78. 
Show data INNODB_MUTEXES
0.00 B
23.45 KB
31.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=1397
11
MEMORY
  edit  empty  empty and reset indexes  delete  79. 
Show data user_variables
0.00 B
6.48 KB
31.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=5060
11
MEMORY
  edit  empty  empty and reset indexes  delete  80. 
Show data INNODB_TABLESPACES_ENCRYPTION
0.00 B
1.97 KB
31.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=16668
11
MEMORY
  edit  empty  empty and reset indexes  delete  81. 
Show data INNODB_FT_DELETED
0.00 B
9.00 B
18.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=3728270
11
MEMORY
  edit  empty  empty and reset indexes  delete  82. 
Show data THREAD_POOL_STATS
0.00 B
85.00 B
30.91 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2024-09-21 01:19:06
max_rows=394758
11
MEMORY