Common Operations in Linux (related to MySQL)

MySQL on the test machine fails today and cannot be started.

I found the Linux expert TJ to help find the cause: the log file is too large, resulting in/data no space.

By default, log files are stored in/data/MySQL/data (MySQL is mounted on/data disk ). Mysql-bin.0000xx log file.

Kill all log files and start MySQL.

Done.

Some Common commands are attached:

Restart:/etc/init. d/MySQL restart

Disk usage: DF-H

Check which process ports are enabled: netstat-NPL

View process: PS-ef

Force kill process: killall-9 mysqld, kill-9 5452 process name, or process ID

Logs can be disabled on the test machine. Go to the Internet and find the following settings:

Mysql> set SQL _log_update = 0