1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Problems with MySQL

Discussion in 'Plesk for Windows - 8.x and Older' started by pg116, Oct 4, 2004.

  1. pg116

    pg116 Guest

    Several times during the day I'm seeing MySQL crash and stop accepting connections. It lasts about 2-5 minutes and then is fine.

    How can I fix this?

    Anyone else seeing it?
  2. jaytee

    jaytee Guest

    Is it crashing or just stopping accepting connections? You might be reaching the default max number of connections - try to set that number higher than default in my.ini.

    Also, if your server is very active, you might even experience the lack of free ports to connect (Windows has only 4000 ports configured by default, and it often takes a few minutes before the port could be reused). In this case you can try the solution from http://support.microsoft.com/default.aspx?scid=kb;en-us;196271

    Check the output of "netstat -np tcp" - if you see thousands of connections to port 3306 in TIME_WAIT status, then the latter is probably your problem.
  3. pg116

    pg116 Guest

    It appears that it stops accepting connections. I'll try upping the max clients.
  4. pg116

    pg116 Guest

    Ok, I've changed my.ini and rebooted. But I'm looking at phpmyadmin and the max connections is still at the old value???