发现mysql的error.log里面有报错:InnoDB: Error: Table “mysql”.“innodb_table_stats” not found. InnoDB:Error: Fetch of persistent statistics requested for table“hj_web”.“wechat_res” but the required system tablesmysql.innodb_table_stats and mysql.innodb_index_stats are not presentor have ...【阅读全文】
有时候修改my.cnf配置文件但是无法生效,可能原因是修改的并不是服务器读取的文件,如果bushido当前使用的配置文件路径,可以在终端输入如下命令:liushiyi@liushiyiPC ~ $ which mysqld/usr/sbin/mysqldliushiyi@liushiyiPC ~ $ mysqld --verbose --help|grep -A 1 'Default options'mysqld: One can only use the --...【阅读全文】
postgres=# drop database devdb;ERROR: database "devdb" is being accessed by other usersDETAIL: There is 1 other session using the database.解决办法,执行如下语句即可:SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='devdb' AND pid<>pg_backend_pid();...【阅读全文】