You are here

How can I find MySQL system information?

How can I find MySQL system information like Operating System version, MySQL release, MySQL table version?

Taxonomy upgrade extras: 

Hi oli,

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

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

MySQL libraries
# ldconfig -p | grep -i mysql

MySQL client
# mysql --version

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

# mysqladmin version -p

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

Shinguzcomment