How can I find MySQL system information?

Hi oli,

it depends a bit which MySQL versions you want to get. Start with the following ones:

# uname -a
# cat /etc/SuSE-release
# cat /proc/version
# lsb_release -a

# ldconfig -p | grep -i mysql

# mysql --version

mysql> STATUS;
mysql> SELECT VERSION();
mysql> SHOW VARIABLES LIKE 'version%';

# mysqladmin version -p

SELECT table_schema, table_name, engine, version, row_format
 FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
ORDER BY table_schema, table_name
;