登上服务器,查出大于1G的表:select TABLE_NAME,DATA_LENGTH, concat(round(((DATA_LENGTH+index_LENGTH)/1024/1024/1024), 2), 'G') as data from information_schema.TABLES where TABLE_SCHEMA='dbname' and DATA_LENGTH > 1000000000;+-------------------------+-------------+-------+| TABLE_NAME ...【阅读全文】
MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决方法环境:linux,mysql5.5.34错误:Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'原因: 同一个ip在短时间内产生太多(超过mysql数...【阅读全文】