| mysql tmp tables created of size 5GB [message #39230] |
Fri, 12 October 2007 10:54 |
neo83
Messages: 7
Registered: September 2007
Karma: 0
|
Junior Member |
|
|
Hello,
We got a problem with our mysql server performance. It's running on a dedicated powerful Dell server with 8GB of RAM and one of the forum running on the server consists of 450000 messages, with around 1000 users accessing it on average and somewhere around 2million hits per day.
mysql server seems to create temp table size of around 5GB on disk, which locks the tables until the query is done, and once the big query is completed, all the piled up waiting connections hit the database server in one go, resulting in almost maxing up the mysql connections.
We observed that the query causing this is almost similar or same as the query generated when "Unread Messages" link is clicked. With so many users accessing the forum,
is it a good idea to disable the "Unread messages" link (dont' know whether the users will be happy or not)?
OR
are we missing something? Is there any other way, we can optimise this particular query?
OR Is this problem caused by any other queries which we did not get hold off?
NOTE: Also, we have tried all the mysql performance techniques and tampered with various variables
Thanks,
Praveen
[Updated on: Fri, 12 October 2007 10:55] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]