MySQL - 系统表 - mysql

columns_priv

列的权限信息

GRANT SELECT (col1), INSERT (col1,col2),UPDATE(col1, col2, col3), DELETE(col1,col2) ON mytest.test01 TO 'mytest'@'%';

 

component

服务器组件的注册表。 此表中列出的任何组件都由加载程序服务在服务器启动过程中安装。

 

db

系统DB信息（information_schema, sys）

 

default_roles

连接之后的默认role

 

engine_cost

contains estimates for operations specific to particular storage engines.

+-------------+-------------+------------------------+------------+---------------------+---------+---------------+

| engine_name | device_type | cost_name | cost_value | last_update | comment | default_value |

+-------------+-------------+------------------------+------------+---------------------+---------+---------------+

| default | 0 | io_block_read_cost | NULL | 2018-02-26 03:49:00 | NULL | 1 |

| default | 0 | memory_block_read_cost | NULL | 2018-02-26 03:49:00 | NULL | 0.25 |

+-------------+-------------+------------------------+------------+---------------------+---------+---------------+

2 rows in set (0.00 sec)

 

func

有关用户定义函数（UDF）的信息。

 

general_log

The general query log table.

 

global_grants

为用户分配动态全局特权

 

gtid_executed

storing GTID values

 

help_category

Information about help categories.

 

help_keyword

Keywords associated with help topics.

 

help_relation

Mappings between help keywords and topics.

 

help_topic

Help topic contents.

 

innodb_ddl_log

Stores DDL logs for crash-safe DDL operations.

 

innodb_dynamic_metadata

由InnoDB存储引擎用于存储快速更改的表元数据，例如自动递增计数器值和索引树损坏标志。 替换驻留在InnoDB系统表空间中的数据字典缓冲区表。

 

innodb_index_stats

innodb优化器统计信息。

 

innodb_table_stats

innodb优化器统计信息。

 

password_history

Information about password changes.

 

plugin

Information about server-side plugins

 

procs_priv

 Stored procedure and function privileges.

 

proxies_priv

Proxy-user privileges.

 

role_edges

角色子图

 

server_cost

+------------------------------+------------+---------------------+---------+---------------+

| cost_name | cost_value | last_update | comment | default_value |

+------------------------------+------------+---------------------+---------+---------------+

| disk_temptable_create_cost | NULL | 2018-02-26 03:49:00 | NULL | 20 |

| disk_temptable_row_cost | NULL | 2018-02-26 03:49:00 | NULL | 0.5 |

| key_compare_cost | NULL | 2018-02-26 03:49:00 | NULL | 0.05 |

| memory_temptable_create_cost | NULL | 2018-02-26 03:49:00 | NULL | 1 |

| memory_temptable_row_cost | NULL | 2018-02-26 03:49:00 | NULL | 0.1 |

| row_evaluate_cost | NULL | 2018-02-26 03:49:00 | NULL | 0.1 |

+------------------------------+------------+---------------------+---------+---------------+

 

servers

Used by the FEDERATED storage engine.

 

slave_master_info

Used to store replication information on slave servers. 

 

slave_relay_log_info

Used to store replication information on slave servers. 

 

slave_worker_info

Used to store replication information on slave servers. 

 

slow_log

The slow query log table.

 

 

tables_priv

表的权限信息

GRANT SELECT,UPDATE,DELETE,INSERT ON mytest.test01 to 'mytest'@'%';

 

time_zone

时区ID以及它们是否使用闰秒。

 

time_zone_leap_second

When leap seconds occur.

 

time_zone_name

Mappings between time zone IDs and names.

 

time_zone_transition

Time zone descriptions.

 

time_zone_transition_type

Time zone descriptions.

 

user

User accounts, global privileges, and other nonprivilege columns.