Home » Performance » MySQL » MySQL Extremely Slow Starting Up
MySQL Extremely Slow Starting Up [message #1261] Tue, 15 May 2007 10:48
oneinc  is currently offline oneinc
Messages: 1
Registered: May 2007
Junior Member
Hello Everybody,

I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL over an hour to come back up. I was watching it on my task manager and it went up to approximately 50,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.

Is there any settings I can change that would help me here? Any help would be greatly appreciated.

One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. The Memory Usage is at 857MB in use at this time.

Thank you in Advance,

ONEinc
Previous Topic:Mysql not using index for ORDER BY ?
Next Topic:MyISAM/table per user or InnoDB/shared table set
Goto Forum:
  


Current Time: Thu Jul 9 21:13:06 EDT 2009

Total time taken to generate the page: 0.00527 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.