I think I caused this error. I spilled my coffee on my keyboard while typing a post on DP. Sorry guys
Well maybe there are to many of us online at the same time. I vote everyone else should leave DP for a day
Yeah Dp is very slow and I always get the stupid Database Error, pretty annoying... hope it gets fixed soon
ok i am getting DB errors for DP mcdar.net msxml3.dll error '80072efd' A connection with the server could not be established /Q-Check/includes/testfunction2a.asp, line 42 and my own sites DB keeps crashing today. anyone else getting issues? i have also not been getting email from my host today,
It seems to be a combination of a couple things... ulimit has a default setting of 1024 files open per user. Normally MySQL lets you override this for the MySQL user by using the open-files-limit directive in /etc/my.cnf, but apparently you can't override the open file limit when using MySQL Instance Manager (no idea why they made it that way). Instance manager is used because multiple mysqld processes run on each physical DB server. Google API slowness the last few days was causing a bunch of open DB connections while the "check all" processes were being run, which left less available slots for open files for forums. So the DB server's operating system was not letting DB servers open any more files (MySQL opens files for each query). The end result is the DB server cluster was being limited to about 2,500 concurrent DB connections (and normally wouldn't be an issue, except the Google API/keyword tracker was using more slots than it normally does). The fix was to up the default operating system ulimit restrictions instead of using MySQL's override (which doesn't work in my case). Hopefully it should be good to go now (and back to normal with being able to handle ~15,000 concurrent DB connections).