Warning: count(): Parameter must be an array or an object that implements Countable in D:\www\www540\mysqldumper\inc\functions_sql.php on line 21
SQL-Browser
Warning: count(): Parameter must be an array or an object that implements Countable in D:\www\www540\mysqldumper\inc\functions_sql.php on line 66

[Tools]  Database: `grete_word`  Table: `INNODB_SYS_FIELDS`

   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:
Table 'grete_word.innodb_sys_fields' doesn't exist

Error in Query:
TRUNCATE `INNODB_SYS_FIELDS`

Table `INNODB_SYS_FIELDS` was deleted.

Table View

Edit Tables

59 Tables

View: compact   The Query contains 18 Columns
 # Name 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 CHARACTER_SETS
0.00 B
384.00 B
250.78 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=699050
10
MEMORY
  edit  empty  empty and reset indexes  delete  2. 
Show data COLLATIONS
0.00 B
231.00 B
254.90 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=1162058
10
MEMORY
  edit  empty  empty and reset indexes  delete  3. 
Show data COLLATION_CHARACTER_SET_APPLICABILITY
0.00 B
195.00 B
249.60 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=1376592
10
MEMORY
  edit  empty  empty and reset indexes  delete  4. 
Show data COLUMNS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=44716
10
MyISAM
  edit  empty  empty and reset indexes  delete  5. 
Show data COLUMN_PRIVILEGES
0.00 B
2.50 KB
255.70 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=104653
10
MEMORY
  edit  empty  empty and reset indexes  delete  6. 
Show data ENGINES
0.00 B
490.00 B
252.90 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=547827
10
MEMORY
  edit  empty  empty and reset indexes  delete  7. 
Show data EVENTS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=9910
10
MyISAM
  edit  empty  empty and reset indexes  delete  8. 
Show data FILES
0.00 B
2.60 KB
255.52 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=100953
10
MEMORY
  edit  empty  empty and reset indexes  delete  9. 
Show data GLOBAL_STATUS
0.00 B
3.19 KB
255.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=82140
10
MEMORY
  edit  empty  empty and reset indexes  delete  10. 
Show data GLOBAL_VARIABLES
0.00 B
3.19 KB
255.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=82140
10
MEMORY
  edit  empty  empty and reset indexes  delete  11. 
Show data KEY_COLUMN_USAGE
0.00 B
4.53 KB
255.83 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=57889
10
MEMORY
  edit  empty  empty and reset indexes  delete  12. 
Show data OPTIMIZER_TRACE
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=9256395
10
MyISAM
  edit  empty  empty and reset indexes  delete  13. 
Show data PARAMETERS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=96351
10
MyISAM
  edit  empty  empty and reset indexes  delete  14. 
Show data PARTITIONS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=89538
10
MyISAM
  edit  empty  empty and reset indexes  delete  15. 
Show data PLUGINS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=181252
10
MyISAM
  edit  empty  empty and reset indexes  delete  16. 
Show data PROCESSLIST
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=382386
10
MyISAM
  edit  empty  empty and reset indexes  delete  17. 
Show data PROFILING
0.00 B
308.00 B
252.72 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=871543
10
MEMORY
  edit  empty  empty and reset indexes  delete  18. 
Show data REFERENTIAL_CONSTRAINTS
0.00 B
4.70 KB
255.89 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=55761
10
MEMORY
  edit  empty  empty and reset indexes  delete  19. 
Show data ROUTINES
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=9335
10
MyISAM
  edit  empty  empty and reset indexes  delete  20. 
Show data SCHEMATA
0.00 B
3.38 KB
255.41 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=77492
10
MEMORY
  edit  empty  empty and reset indexes  delete  21. 
Show data SCHEMA_PRIVILEGES
0.00 B
2.13 KB
255.41 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=123192
10
MEMORY
  edit  empty  empty and reset indexes  delete  22. 
Show data SESSION_STATUS
0.00 B
3.19 KB
255.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=82140
10
MEMORY
  edit  empty  empty and reset indexes  delete  23. 
Show data SESSION_VARIABLES
0.00 B
3.19 KB
255.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=82140
10
MEMORY
  edit  empty  empty and reset indexes  delete  24. 
Show data STATISTICS
0.00 B
5.62 KB
255.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=46660
10
MEMORY
  edit  empty  empty and reset indexes  delete  25. 
Show data TABLES
0.00 B
9.22 KB
255.80 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=28432
10
MEMORY
  edit  empty  empty and reset indexes  delete  26. 
Show data TABLESPACES
0.00 B
6.79 KB
255.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=38618
10
MEMORY
  edit  empty  empty and reset indexes  delete  27. 
Show data TABLE_CONSTRAINTS
0.00 B
2.45 KB
255.18 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=107202
10
MEMORY
  edit  empty  empty and reset indexes  delete  28. 
Show data TABLE_PRIVILEGES
0.00 B
2.32 KB
255.57 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=113168
10
MEMORY
  edit  empty  empty and reset indexes  delete  29. 
Show data TRIGGERS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=9112
10
MyISAM
  edit  empty  empty and reset indexes  delete  30. 
Show data USER_PRIVILEGES
0.00 B
1.94 KB
255.23 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=135163
10
MEMORY
  edit  empty  empty and reset indexes  delete  31. 
Show data VIEWS
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2020-12-31 20:33:52
2020-12-31 20:33:52
max_rows=110969
10
MyISAM
  edit  empty  empty and reset indexes  delete  32. 
Show data INNODB_LOCKS
0.00 B
30.51 KB
255.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=8591
10
MEMORY
  edit  empty  empty and reset indexes  delete  33. 
Show data INNODB_TRX
0.00 B
4.43 KB
255.55 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=59178
10
MEMORY
  edit  empty  empty and reset indexes  delete  34. 
Show data INNODB_SYS_DATAFILES
0.00 B
11.73 KB
255.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=22356
10
MEMORY
  edit  empty  empty and reset indexes  delete  35. 
Show data INNODB_LOCK_WAITS
0.00 B
599.00 B
255.57 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=448139
10
MEMORY
  edit  empty  empty and reset indexes  delete  36. 
Show data INNODB_SYS_TABLESTATS
0.00 B
1.19 KB
255.79 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=220934
10
MEMORY
  edit  empty  empty and reset indexes  delete  37. 
Show data INNODB_CMP
0.00 B
25.00 B
200.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=10737418
10
MEMORY
  edit  empty  empty and reset indexes  delete  38. 
Show data INNODB_METRICS
0.00 B
2.92 KB
255.49 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=89657
10
MEMORY
  edit  empty  empty and reset indexes  delete  39. 
Show data INNODB_CMP_RESET
0.00 B
25.00 B
200.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=10737418
10
MEMORY
  edit  empty  empty and reset indexes  delete  40. 
Show data INNODB_CMP_PER_INDEX
0.00 B
1.71 KB
255.27 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=152954
10
MEMORY
  edit  empty  empty and reset indexes  delete  41. 
Show data INNODB_CMPMEM_RESET
0.00 B
29.00 B
232.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=9256395
10
MEMORY
  edit  empty  empty and reset indexes  delete  42. 
Show data INNODB_FT_DELETED
0.00 B
9.00 B
144.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=29826161
10
MEMORY
  edit  empty  empty and reset indexes  delete  43. 
Show data INNODB_BUFFER_PAGE_LRU
0.00 B
6.51 KB
255.88 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=40251
10
MEMORY
  edit  empty  empty and reset indexes  delete  44. 
Show data INNODB_SYS_FOREIGN
0.00 B
1.71 KB
254.84 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=153216
10
MEMORY
  edit  empty  empty and reset indexes  delete  45. 
Show data INNODB_SYS_COLUMNS
0.00 B
610.00 B
253.51 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=440058
10
MEMORY
  edit  empty  empty and reset indexes  delete  46. 
Show data INNODB_SYS_INDEXES
0.00 B
614.00 B
255.17 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=437191
10
MEMORY
  edit  empty  empty and reset indexes  delete  47. 
Show data INNODB_FT_DEFAULT_STOPWORD
0.00 B
56.00 B
224.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=4793490
10
MEMORY
  edit  empty  empty and reset indexes  delete  48. 
Show data INNODB_SYS_FIELDS
0.00 B
594.00 B
253.44 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=451911
10
MEMORY
  edit  empty  empty and reset indexes  delete  49. 
Show data INNODB_CMP_PER_INDEX_RESET
0.00 B
1.71 KB
255.27 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=152954
10
MEMORY
  edit  empty  empty and reset indexes  delete  50. 
Show data INNODB_BUFFER_PAGE
0.00 B
6.69 KB
255.85 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=39176
10
MEMORY
  edit  empty  empty and reset indexes  delete  51. 
Show data INNODB_CMPMEM
0.00 B
29.00 B
232.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=9256395
10
MEMORY
  edit  empty  empty and reset indexes  delete  52. 
Show data INNODB_FT_INDEX_TABLE
0.00 B
808.00 B
253.49 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=332222
10
MEMORY
  edit  empty  empty and reset indexes  delete  53. 
Show data INNODB_FT_BEING_DELETED
0.00 B
9.00 B
144.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=29826161
10
MEMORY
  edit  empty  empty and reset indexes  delete  54. 
Show data INNODB_SYS_TABLESPACES
0.00 B
2.03 KB
255.26 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=128931
10
MEMORY
  edit  empty  empty and reset indexes  delete  55. 
Show data INNODB_FT_INDEX_CACHE
0.00 B
808.00 B
253.49 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=332222
10
MEMORY
  edit  empty  empty and reset indexes  delete  56. 
Show data INNODB_SYS_FOREIGN_COLS
0.00 B
1.71 KB
255.41 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=153567
10
MEMORY
  edit  empty  empty and reset indexes  delete  57. 
Show data INNODB_SYS_TABLES
0.00 B
2.01 KB
255.50 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=130308
10
MEMORY
  edit  empty  empty and reset indexes  delete  58. 
Show data INNODB_BUFFER_POOL_STATS
0.00 B
257.00 B
249.21 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=1044495
10
MEMORY
  edit  empty  empty and reset indexes  delete  59. 
Show data INNODB_FT_CONFIG
0.00 B
1.14 KB
254.90 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2020-12-31 20:33:52
max_rows=230812
10
MEMORY