Shulou(Shulou.com)06/01 Report--

Title index

System structure table

INNODB table

System structure table

Informaiton_schema is the database of mariadb. Through this table, you can get a general idea of the structure and understanding of mariadb database.

1.CHARACTER_SETS: the database table contains a list of supported character sets, their default collation and maximum length.

2.CLIENT_STATISTICS: the CLIENT_STATISTICS table in the database contains statistics about client connections, which are part of the user statistics feature and are not enabled by default.

3.COLLATION_CHARACTER_SET_APPLICABILITY: the database COLLATION_CHARACTER_SET_ application table shows which character sets are associated with which collections.

4.COLLATIONS: the COLLATIONS table contains supported sorted lists (usually when designing tables).

5.COLUNMN_PRIVILEGES: the table contains information about granting column PRIVILEGES privileges from mysql.columns_priv.

6.COLUMNS: provides information about the columns in each table on the server.

7.ENGINES: all the engines supported by the database.

8.EVENTS: an event is a procedural database object that MySQL calls at the appropriate time. An event can be called once or started periodically, and it is managed by a specific thread, which is called the event Scheduler.

9.FILES:

10.GLOBAL_STATUS and SESSION_STATUS: the database GLOBAL_STATUS and SESSION_STATUS tables store records of all state variables and their global and session values, respectively.

11.GLOBAL_VARIABLES and SESSION_STATUS: the database GLOBAL_STATUS and SESSION_STATUS tables store records of all state variables and their global and session values, respectively.

12.KEY_CACHES: the KEY_ caches table in the database displays statistics about the segmented key cache introduced in MariaDB 5.2.0.

13.KEY_COLUMU_USAGE: the table can view the constraints on the index column.

14.PARAMETERS: tables store information about stored procedures and stored functional parameters.

15.PAEATITIONS: contains information about table partitions, with each record corresponding to a single partition or subpartition of a partitioned table. Each non-partitioned table also has a record in the PARTITIONS table, but most of the values are NULL.

16.PLUGINS: the table contains information about server plug-ins.

17.PROCESSLIST: the table contains information about running threads.

18.REFERENTIAL_CONSTRAINTS: the table contains information about foreign keys, and individual columns are listed in the KEY_COLUMN_ USAGE table.

19.ROUTINES: tables store information about stored procedures and storage capabilities.

20.SCHEMA_PRIVILEGES: the permission to store the database.

21.SCHEMATA: stores database information on the server.

22.STATISTICS: provides index information for the table.

23.TABLE_CONSTRAINTS: tables contain information about tables with constraints.

24.TABLE_STATISTICS: the table displays statistics on table usage, which is part of the user statistics feature.

25.TABLES: the table displays information about the various non-TEMPORARY tables and views on the server.

26.TABLESPACES: the table contains information about the active tablespace.

27.TRIGGERS: the table contains information about triggers.

28.USER_PRIVILEGES: the table contains global user privilege information derived from the mysql.user authorization table.

29.USER_STATISTICS: the information mode USER_STATISTICS table contains statistics about user activity, which is part of the user statistics feature and is not enabled by default. You can use this table to find out which users are causing the most load, which users are abusing, and so on, or you can use this table to measure how close the capacity of the server is.

30.VIEWS: the table contains information about the view and requires SHOW VIEW permission to view the table.

INNODB table

1.INNODB_BUFFER_PAGE: the table contains information about the pages in the buffer pool. PROCESS permission is required to view the form.

2.INNODB_BUFFER_PAGES: the table contains information about the pages in the buffer pool and how to sort them for eviction purposes.

3.INNODB_BUFFER_POOL_PAGES: tables are Percona enhancements that apply only to XtraDB, not InnoDB, and contain records for each page in the buffer pool.

4.INNODB_BUFFER_POOL_PAGES_BLOB: tables are Percona enhancements that apply only to XtraDB, not InnoDB, and contain information about buffer pool blob pages.

5.INNODB_BUFFER_POOL_PAGES_INDEX: the information mode INNODB_BUFFER_POOL_ pages table is an Percona enhancement that applies only to XtraDB, not to InnoDB. It contains information about the buffer pool index page.

6.INNODB_BUFFER_POOL_STATS: the table contains information about the pages in the buffer pool, similar to the information returned using the SHOW ENGINE INNODB STATUS statement.

7.INNODB_CHANGED_PAGES: the table contains data about the modified pages in the bitmap file, and the log trace thread updates the log resolution at the checkpoint, so it does not contain real-time data. The limit of the value of the logged innodb_max_changed_pages system variable.

8.INNODB_CMP/INNODB_CMP_RESET: the table contains status information about the compression operation of the compressed XtraDB / InnoDB table.

9.INNODB_CMPMEM/INNODB_CMPMEM_RESET: the table contains status information for compressed pages in the buffer pool.

10.INNODB_LOCK_WAITS: the table contains information about blocked InnoDB transactions and requires PROCESS permission to view the table.

11.INNODB_LOCKS: the table stores information about locks requested by InnoDB transactions that have not yet been acquired, or information that blocks other transactions.

12.INNODB_RSEG: the table contains a list of useful InnoDB performance metrics. Each row in the table represents an instrument counter that can be stopped, started and reset, and can be grouped together by module.

13.INNODB_SYS_COLUMNS: the table contains information about the InnoDB field.

14.INNODB_SYS_DATAFILES: the table contains information about the path to the InnoDB data file and requires PROCESS permission to view the table.

15.INNODB_SYS_FIELDS: the table contains information about fields that are part of the InnoDB index.

16.INNODB_SYS_FOREIGN: the table contains information about InnoDB foreign keys.

17.INNODB_SYS_FOREIGN_COLS: the table contains information about the InnoDB foreign key column.

18.INNODB_SYS_INDEXES: the table contains information about the InnoDB index.

19.INNODB_SYS_SEMAPHORE_WAITS: the table contains information about the current semaphore wait.

20.INNODB_SYS_TABLES: the table contains information about the InnoDB table.

21.INNODB_SYS_TABLESPACES: tables contain information about InnoDB tablespaces.

22.INNODB TABLESPACES SCRUBBING: the table contains data cleanup information.

23.INNODB_TRX: the table stores information about all currently executing InnoDB transactions.

24.INNODB_UNDO_LOGS: the table is an Percona enhancement that applies only to XtraDB, not InnoDB. It contains information about InnoDB undo logs, and each record is an undo log segment.

25.TEMP_TABLES_INFO: the table contains information about the active InnoDB temporary table, and when querying this table, all user and system-created temporary tables are reported, but with the exception of optimized internal temporary tables, the data is stored in memory.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.