mysql内存满了

2017/01/25 mysql

general_log = 1 general_log_file = /home/mysql_log/3306_general_log.log show global variables like “%genera%”; set global general_log=on; set global general_log_file=’/home/mysql_log/3306_general_log.log’;

/home/mysql_log/3306_general_log.log

mysql> show warnings; +——-+——+—————————————————————————————————————————————————————————————-+ | Level | Code | Message | +——-+——+—————————————————————————————————————————————————————————————-+ | Error | 13 | Can’t get stat of ‘./mysql/general_log.CSV’ (Errcode: 2) | | Error | 1041 | Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ‘ulimit’ to allow mysqld to use more memory or you can add more swap space |

开始清理内存 echo 1 > /proc/sys/vm/drop_caches


Search

    Table of Contents