PDA

View Full Version : Managed to repair my databases in few minutes now.


SaN-DeeP
Fri 29th Dec '06, 3:41pm
I had huge troubles updating/repairing my databases since last few months, posted lots of threads on this forum for server optimizations etc. but was never ever successful.

2 days back was able to debug this problem,
mysql was configured to use /tmp on our server as temporary folder which was allocated only 100 MB. Checking mysql log files where I found some errors which were writing to error file every 10 mins about no more disk space.

Finally increase /tmp folder size to /plentyofspace and now database upgrades/repairs are done in matter of minutes.

:D :D :D

eva2000
Sun 31st Dec '06, 7:08am
Yup best to set mysql tmpdir in my.cnf to another location i.e.

[mysqld]
tmpdir = /more/freespace/location