用命令行的SHOW语句
用MySQL自带的mysqladmin查看 使用MySQL自带的mysqladmin 工具查看status,使用以下命令
显示的结果如下: Uptime: 502963 Threads: 2 Questions: 8561820 Slow queries: 734681 Opens: 553 45 Flush tables: 1 Open tables: 85 Queries per second avg: 17.023 另外可以添加 -i 5 参数,让其每五秒自动刷新一次。
*排查这样子的错误 : Mysql::Error: Deadlock found when trying to get lock; try restarting transaction: UPDATE lawyer t1 JOIN lawyer t2 ON t1.bar_number = t2.bar_number (ActiveRecord::StatementInvalid) |
|