系统

MySQL 系统

MySQL 版本

show variables like '%version%';

MySQL Plugin 外挂

SHOW PLUGINS;
SELECT PLUGIN_NAME as Name, PLUGIN_VERSION as Version, PLUGIN_STATUS as Status
FROM INFORMATION_SCHEMA.PLUGINS
WHERE PLUGIN_TYPE='STORAGE ENGINE';

资料库编码

use <DATABASE_NAME>
SELECT @@character_set_database, @@collation_database;
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '<DATABASE_NAME>';
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
SHOW TABLE STATUS FROM <DATABASE_NAME>;

Reference