MySQL Forums
Forum List  »  Quality Assurance

MySQL Timeout errors
Posted by: Calvin Uijlen
Date: March 07, 2012 12:58PM

Hello all,

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
16GB RAM
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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Timeout errors
2746
March 07, 2012 12:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.