开心了, 就笑;不开心了,就过会儿再笑。。。。
发布时间:2015-04-28 10:15:01
登上服务器,查出大于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 .........【阅读全文】
发布时间:2015-04-28 09:49:44
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数.........【阅读全文】