MySQL advice? "Losing connection"

Discussion in 'Linux VPS/Dedicated - General' started by chette, Jan 5, 2007.

  1. chette

    chette New Member

    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?
     

Share This Page