qq_33654391的博客

1

-- 查看表数据量SELECT TABLE_NAME,TABLE_ROWS,now() FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ods_ys' ORDER BY TABLE_ROWS desc;

修改前：[mysqld]datadir=/home/mysqlsocket=/home/mysql/mysql.sockuser=mysqlport=3306lower_case_table_names=1character-set-server=utf8symbolic-links=0skip-name-resolvenet_write_timeout=600wait_timeout=31536000interactive_timeout=31536000collation-s