I have a friend who is having problems with MySQL, she has a dedicated server with a large website (400+ users online at the same time in a C# game).
It runs fine for some time (a few hours) but when it reaches 350-425 online users, not always, but then the C# application starts to give MySQL Timeout errors. The C# application used between 5 and 30 connections, I have now increased it, I will post the results as soon as I know them.
MySQL uses 700MB RAM when it boots, but if I look at Windows Task Manager after a few hours, it uses only 2MB RAM?
The database is at least 700 Megabytes and only 2MB RAM.. EDIT: Resource monitor says something else: http://img268.imageshack.us/img268/9625/mysqlj.png
CPU usage is 100% when timeout errors appear and when it uses 2MB RAM, it uses between 10%-30% CPU.
I don't think that is healty for a dedicated server with 16GB RAM.
The server has a uplink of 100 Mbit/s, so no problem there either and ping won't be the problem too.
We use this MySQL config file: http://pastebin.com/keH2L5UX
Dedicated Server specs:
Intel i5 2.44GHz
Seagate Barracuda XT 64MB cache, SATA interface–SATA 6Gb/s.
100 Mbit/s uplink
Windows Server 2008 R2 (used through VMWare ESXi)
Average harddisk performance is 90 MB/s, so that shouldn't be the issue.
If I need to post any logs, please tell me.