System

MySQL System
Categories:
Tags:

MySQL Version

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';

MySQL Database Encoding

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