Current location - Health Preservation Learning Network - Healthy weight loss - Sql slimming
Sql slimming
The files backed up by 1.SQL can be deleted regularly, which will not affect the use.

2. It is normal that the memory utilization rate is 1700M m.

3. Important note: SQL logs should be shortened regularly, otherwise the logs will become larger, resulting in too large backup files. Many times, the log file is too large, and the data itself is not large. After slimming, the files backed up every day are greatly reduced.

Method: Open the query analyzer.

Dump transaction "database name" with no_log

Backup log "database name" with no_log