linux 数据库空间满,Linux磁盘空间爆满,MySQL无法启动

在Linux系统中,默认会保留5%的空间[root@db01 log]# tune2fs -m 1 /dev/mapper/VolGroup-lv_roottune2fs 1.41.12 (17-May-2010)Setting reserved blocks percentage to 1% (131072 blocks)查看磁盘空间:[root@db01 log]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/mapper/VolGroup-lv_root50G   48G  783M  99% /tmpfs                 7.7G     0  7.7G   0% /dev/shm/dev/sda1             485M   32M  429M   7% /boot空间由原来的100%变成了99%,尝试启动mysql数据库[root@db01 ~]# service mysqld startStarting MySQL SUCCESS![root@db01 ~]# ps -ef | grep mysqlroot     31405     1  3 00:37 pts/2    00:00:00 /bin/sh /export/servers/mysql/bin/mysqld_safe --datadir=/export/servers/mysql/data --pid-file=/export/servers/mysql/tmp/mysql.pidmysql    32200 31405 63 00:37 pts/2    00:00:01 /export/servers/mysql/bin/mysqld --basedir=/export/servers/mysql --datadir=/export/servers/mysql/data --plugin-dir=/export/servers/mysql/lib/plugin --user=mysql --log-error=/export/servers/mysql/log/error.log --open-files-limit=65535 --pid-file=/export/servers/mysql/tmp/mysql.pid --socket=/export/servers/mysql/tmp/mysql.sock --port=3306root     32218 27979  0 00:37 pts/2    00:00:00 grep mysql[root@db01 bin]# /usr/local/mysql/bin/mysql -u root -pWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.14-log Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> reset master;reset master; (清除日志文件)

禁止方法: vi /etc/my.cnf把里面的#log-bin=mysql-bin#binlog_format=mixed注释掉,重启mysql服务即可.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值