Get the App
SLTechnology News&Howtos  ›  Database  › 

Mysql can't start dues to the disk space is full

Shulou Source: shulou.com Published: 2022-06-01 06:12:41 10月03日 Update

Use. / mysqld_safe-- user=mysql &

Start mysql.

The mysql can not start. There are much mysql restart info show on the screen always. And can not find the / var/lib/mysql/mysql.sock file.

The reason:

Then find the space is full. So the mysql can not start naturally. Delete some log info, then the mysql start correctly.

The big log files are two:

1. Our application log

2. The / var/log/audit.d

The files in the / var/log/audit.d directory are generated by the Linux audit subsystem (Linux Audit Subsystem, or LAuS).

For security purposes, after LAuS starts, the default configuration is to record some specific system activity. If a security audit is not required, you can

To shut down the LAuS service with the following command:

Service audit stop

Chkconfig audit off

After you stop the LAuS service, any save.* files under the / var/log/audit.d directory can be deleted. We recommend you to leave it intact.

Keep the bin.* file for future use. The LAuS feature is not enabled by default in Red Hat Enterprise Edition and above Linux3.

Because LAuS is used for security audits, its log files are not automatically deleted and will always be retained. If your system is heavily loaded

And in the execution of the LAuS monitoring system, the log files of LAuS will grow rapidly, which may take up the space of / var and cause the system to crash. Yes

Several ways can be used to prevent the above events from happening. The easiest way is to monitor the size of the / var/log/audit.d directory regularly and delete obsolete

The save.* file of. Another technique is not to save archived audit logs as save.* files. Modify / etc/audit/audit.conf

The notify line of the face, replace the original / usr/sbin/audbin with / bin/true:

/ etc/audit/audit.conf

Output {

Mode = bin

Num-files = 4

File-size = 20m

File-name = "/ var/log/audit.d/bin"

Notify = "/ bin/true"

The third way is to write a script to delete the save.* file regularly.

[@ more@]

Tags: File system audit security log directory method service monitoring obsolete intact event enterprise function can be passed command size subsystem fast technology Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft Shulou Tech Info Shulou Information Linux Xiaomi