DirectAdmin backups failing mysql

U

urbee

Verified User
Joined
Mar 27, 2009
Messages
118
Hello,

we're having issues on two servers with DirectAdmin backups. This is generally a large job, working from about 00:00 untill 10:00 in the morning, backing up about 350 GB of files per night.

The problem is, the server (mySQL) crashes multiple times during the jobs. Errors like "connection to database failed" and similar are showing up. I dont understand how that can happen since mysql is not limited in resources in any way.

Yeah, load goes up but not that much, the machine is still responsive when the mysql errors happen. mysql error log doesnt show anything.

This is my.cnf:

local-infile=0
max_allowed_packet = 128M
max_connections = 400
wait_timeout = 20000
interactive_timeout = 20000
query_cache_size = 32M
join_buffer_size = 6M
tmp_table_size = 512M
max_heap_table_size = 512M
thread_cache_size = 4
table_cache = 512
innodb_buffer_pool_size = 2G

Thanks
 
Might be refer to RAM and it isn't enough.

The information you gave not clear to found.
Code: 
local-infile=0
max_allowed_packet = 128M
max_connections = 400
wait_timeout = 20000
interactive_timeout = 20000
query_cache_size = 32M
join_buffer_size = 6M
tmp_table_size = 512M
max_heap_table_size = 512M
thread_cache_size = 4
table_cache = 512
innodb_buffer_pool_size = 2G
Run the top command to check it.
 
RAM ? You mean the physical RAM in the machine?

The machine has plenty of ram (24 GB) and goes to SWAP sometimes, but not much (currently like 170 MB of swap used). I dont see how this could cause the errors. Swap is basicly virtual RAM.

total used free shared buffers cached
Mem: 24156 23713 443 0 3277 16280
-/+ buffers/cache: 4154 20002
Swap: 5721 170 5551
 
You must log in or register to reply here.
Back
Top