linux环境查看mysql基本配置信息

1、查看mysql版本SQL：

1、select @@version;

2、select version();

2、查看mysql服务名命令：ps -ef|grep mysql

3、查看数据库最大连接数SQL：show variables like '%max_connections%'; 

4、查看数据库各表数据条数及大小SQL：SELECT TABLE_NAME,DATA_LENGTH,INDEX_LENGTH,(DATA_LENGTH+INDEX_LENGTH) as length,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,3), 'MB') as total_size FROM information_schema.TABLES WHERE TABLE_SCHEMA='database_name' order by length desc;

5、查看数据库存储空间命令：df -h