SQL-Browser

[Tools]  Database: `information_schema`

   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.

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
15.67 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=43690
10
MEMORY
  edit  empty  empty and reset indexes  delete  2. 
Show data COLLATIONS
0.00 B
231.00 B
15.93 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=72628
10
MEMORY
  edit  empty  empty and reset indexes  delete  3. 
Show data COLLATION_CHARACTER_SET_APPLICABILITY
0.00 B
195.00 B
15.60 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=86037
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=22358
10
MyISAM
  edit  empty  empty and reset indexes  delete  5. 
Show data COLUMN_PRIVILEGES
0.00 B
2.50 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=6540
10
MEMORY
  edit  empty  empty and reset indexes  delete  6. 
Show data ENGINES
0.00 B
490.00 B
15.81 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=34239
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=4955
10
MyISAM
  edit  empty  empty and reset indexes  delete  8. 
Show data FILES
0.00 B
2.60 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=6309
10
MEMORY
  edit  empty  empty and reset indexes  delete  9. 
Show data GLOBAL_STATUS
0.00 B
3.19 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=5133
10
MEMORY
  edit  empty  empty and reset indexes  delete  10. 
Show data GLOBAL_VARIABLES
0.00 B
3.19 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=5133
10
MEMORY
  edit  empty  empty and reset indexes  delete  11. 
Show data KEY_COLUMN_USAGE
0.00 B
4.53 KB
15.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=3618
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=4628197
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=48175
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=44769
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=90626
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=191193
10
MyISAM
  edit  empty  empty and reset indexes  delete  17. 
Show data PROFILING
0.00 B
308.00 B
15.79 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=54471
10
MEMORY
  edit  empty  empty and reset indexes  delete  18. 
Show data REFERENTIAL_CONSTRAINTS
0.00 B
4.70 KB
15.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=3485
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=4667
10
MyISAM
  edit  empty  empty and reset indexes  delete  20. 
Show data SCHEMATA
0.00 B
3.38 KB
15.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=4843
10
MEMORY
  edit  empty  empty and reset indexes  delete  21. 
Show data SCHEMA_PRIVILEGES
0.00 B
2.13 KB
15.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=7699
10
MEMORY
  edit  empty  empty and reset indexes  delete  22. 
Show data SESSION_STATUS
0.00 B
3.19 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=5133
10
MEMORY
  edit  empty  empty and reset indexes  delete  23. 
Show data SESSION_VARIABLES
0.00 B
3.19 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=5133
10
MEMORY
  edit  empty  empty and reset indexes  delete  24. 
Show data STATISTICS
0.00 B
5.62 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=2916
10
MEMORY
  edit  empty  empty and reset indexes  delete  25. 
Show data TABLES
0.00 B
9.22 KB
15.98 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=1777
10
MEMORY
  edit  empty  empty and reset indexes  delete  26. 
Show data TABLESPACES
0.00 B
6.79 KB
16.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=2413
10
MEMORY
  edit  empty  empty and reset indexes  delete  27. 
Show data TABLE_CONSTRAINTS
0.00 B
2.45 KB
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=6700
10
MEMORY
  edit  empty  empty and reset indexes  delete  28. 
Show data TABLE_PRIVILEGES
0.00 B
2.32 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=7073
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=4556
10
MyISAM
  edit  empty  empty and reset indexes  delete  30. 
Show data USER_PRIVILEGES
0.00 B
1.94 KB
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=8447
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
2025-02-05 14:59:53
2025-02-05 14:59:53
max_rows=55484
10
MyISAM
  edit  empty  empty and reset indexes  delete  32. 
Show data INNODB_LOCKS
0.00 B
30.51 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=536
10
MEMORY
  edit  empty  empty and reset indexes  delete  33. 
Show data INNODB_TRX
0.00 B
4.43 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=3698
10
MEMORY
  edit  empty  empty and reset indexes  delete  34. 
Show data INNODB_SYS_DATAFILES
0.00 B
11.73 KB
16.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=1397
10
MEMORY
  edit  empty  empty and reset indexes  delete  35. 
Show data INNODB_LOCK_WAITS
0.00 B
599.00 B
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=28008
10
MEMORY
  edit  empty  empty and reset indexes  delete  36. 
Show data INNODB_SYS_TABLESTATS
0.00 B
1.19 KB
15.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=13808
10
MEMORY
  edit  empty  empty and reset indexes  delete  37. 
Show data INNODB_CMP
0.00 B
25.00 B
12.50 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=671088
10
MEMORY
  edit  empty  empty and reset indexes  delete  38. 
Show data INNODB_METRICS
0.00 B
2.92 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=5603
10
MEMORY
  edit  empty  empty and reset indexes  delete  39. 
Show data INNODB_CMP_RESET
0.00 B
25.00 B
12.50 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=671088
10
MEMORY
  edit  empty  empty and reset indexes  delete  40. 
Show data INNODB_CMP_PER_INDEX
0.00 B
1.71 KB
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=9559
10
MEMORY
  edit  empty  empty and reset indexes  delete  41. 
Show data INNODB_CMPMEM_RESET
0.00 B
29.00 B
14.50 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=578524
10
MEMORY
  edit  empty  empty and reset indexes  delete  42. 
Show data INNODB_FT_DELETED
0.00 B
9.00 B
9.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=1864135
10
MEMORY
  edit  empty  empty and reset indexes  delete  43. 
Show data INNODB_BUFFER_PAGE_LRU
0.00 B
6.51 KB
15.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=2515
10
MEMORY
  edit  empty  empty and reset indexes  delete  44. 
Show data INNODB_SYS_FOREIGN
0.00 B
1.71 KB
15.93 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=9576
10
MEMORY
  edit  empty  empty and reset indexes  delete  45. 
Show data INNODB_SYS_COLUMNS
0.00 B
610.00 B
15.84 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=27503
10
MEMORY
  edit  empty  empty and reset indexes  delete  46. 
Show data INNODB_SYS_INDEXES
0.00 B
614.00 B
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=27324
10
MEMORY
  edit  empty  empty and reset indexes  delete  47. 
Show data INNODB_FT_DEFAULT_STOPWORD
0.00 B
56.00 B
14.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=299593
10
MEMORY
  edit  empty  empty and reset indexes  delete  48. 
Show data INNODB_SYS_FIELDS
0.00 B
594.00 B
15.84 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=28244
10
MEMORY
  edit  empty  empty and reset indexes  delete  49. 
Show data INNODB_CMP_PER_INDEX_RESET
0.00 B
1.71 KB
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=9559
10
MEMORY
  edit  empty  empty and reset indexes  delete  50. 
Show data INNODB_BUFFER_PAGE
0.00 B
6.69 KB
15.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=2448
10
MEMORY
  edit  empty  empty and reset indexes  delete  51. 
Show data INNODB_CMPMEM
0.00 B
29.00 B
14.50 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=578524
10
MEMORY
  edit  empty  empty and reset indexes  delete  52. 
Show data INNODB_FT_INDEX_TABLE
0.00 B
1.03 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=15917
10
MEMORY
  edit  empty  empty and reset indexes  delete  53. 
Show data INNODB_FT_BEING_DELETED
0.00 B
9.00 B
9.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=1864135
10
MEMORY
  edit  empty  empty and reset indexes  delete  54. 
Show data INNODB_SYS_TABLESPACES
0.00 B
2.03 KB
15.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=8058
10
MEMORY
  edit  empty  empty and reset indexes  delete  55. 
Show data INNODB_FT_INDEX_CACHE
0.00 B
1.03 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=15917
10
MEMORY
  edit  empty  empty and reset indexes  delete  56. 
Show data INNODB_SYS_FOREIGN_COLS
0.00 B
1.71 KB
15.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=9597
10
MEMORY
  edit  empty  empty and reset indexes  delete  57. 
Show data INNODB_SYS_TABLES
0.00 B
2.01 KB
15.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=8144
10
MEMORY
  edit  empty  empty and reset indexes  delete  58. 
Show data INNODB_BUFFER_POOL_STATS
0.00 B
257.00 B
15.58 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=65280
10
MEMORY
  edit  empty  empty and reset indexes  delete  59. 
Show data INNODB_FT_CONFIG
0.00 B
1.14 KB
15.93 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2025-02-05 14:59:53
max_rows=14425
10
MEMORY