Friday, October 19, 2012

Fixing MySQL Management Timeout In DirectAdmin

This is due to DirectAdmin calculating the size of the assigned databases on the fly to inform the user. Users with large databases are negatively affected by this and as such this "feature" should be limited or removed via the following.

Edit:
/usr/local/directadmin/conf/directadmin.conf
Show_db_usage = 0
You can also set this value to the maximum number of tables it will read before giving up.