-- mysql 查看 通过查询table_rows属性获得哪些表数据量比较大。
select table_name, table_rows from information_schema.tables order by table_rows desc limit 100;-- 查看 innodb_lock_wait_timeout值
show variables like 'innodb_lock_wait_timeout';
Last active
December 15, 2017 05:24
-
-
Save xwsg/de6caa65129fa0ff6bd82a2bc43b5d22 to your computer and use it in GitHub Desktop.
Mysql.md
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment