FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » mysql tmp tables created of size 5GB (tmp table size of 5GB are created when Unread Messages link is clicked)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
mysql tmp tables created of size 5GB [message #39230] Fri, 12 October 2007 06:54
neo83 is currently offline  neo83   United Kingdom
Messages: 7
Registered: September 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 06:55]

Report message to a moderator

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: phpsyslogng error
Next Topic: Performance Problems MySql
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 22:29:30 EDT 2017

Total time taken to generate the page: 0.00639 seconds