In one of our MySQL db (which contains forum data), I would "lose my connection." For example, when I go to phpBB to repair a table, I will suddenly the standard IE error page that the browser cannot display the webpage. Also whenever I am in the middle of the upgrade script of our SMF forum. I would need to wait a couple of minutes before I can access anything from the web again.
By the way, this also happens when I will try to repair a table via Navicat (a MySQL client). It will suddenly "hang."
This only happens in that particular db.
Any advice on how I can optimize or tweak this?
By the way, this also happens when I will try to repair a table via Navicat (a MySQL client). It will suddenly "hang."
This only happens in that particular db.
Any advice on how I can optimize or tweak this?