Home | Community | Message Board

Original Seeds Store
This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post Pages: 1
InvisibleDiploidM
Cuban


Folding@home Statistics
Registered: 01/09/03
Posts: 19,274
Loc: Rabbit Hole
MySQL 5 Slow?
    #7822574 - 01/02/08 04:12 AM (16 years, 30 days ago)

"Generated in 17.395 seconds in which 17.385 seconds were spent on a total of 12 queries."

"Generated in 43.783 seconds in which 43.722 seconds were spent on a total of 36 queries."

"Generated in 12.9 seconds in which 12.865 seconds were spent on a total of 11 queries."

Before the upgrade to version 5, I rarely saw queries take longer than a few milliseconds each.

Is this normal? Should database queries be taking over a second each? This slowness seems to happen at all hours (though it's a little worse around 6am eastern), so it doesn't seem to be related to the time of day.


--------------------
Republican Values:

1) You can't get married to your spouse who is the same sex as you.
2) You can't have an abortion no matter how much you don't want a child.
3) You can't have a certain plant in your possession or you'll get locked up with a rapist and a murderer.

4) We need a smaller, less-intrusive government.


Extras: Filter Print Post Top
OfflineSeussA
Error: divide byzero


Folding@home Statistics
Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 2 months, 20 days
Re: MySQL 5 Slow? [Re: Diploid]
    #7822674 - 01/02/08 05:30 AM (16 years, 30 days ago)

> though it's a little worse around 6am eastern

One of the backup scripts run at 6am eastern... it takes about ten minutes to complete, and the database is mostly locked during that time.


--------------------
Just another spore in the wind.


Extras: Filter Print Post Top
Jump to top Pages: 1


Similar ThreadsPosterViewsRepliesLast post
* BB upgrade problems, questions? Post here.
( 1 2 3 4 all )
ThorA 11,358 69 01/22/03 12:34 PM
by goldtop
* mysql upgrade
( 1 2 all )
LinkA 3,205 22 10/07/07 02:27 PM
by ShroomieGirl
* Lost connection to MySQL server during query when using... daussaulit 1,143 3 01/16/04 04:42 PM
by 3DSHROOM
* Holy crap! Fuck MySQL!! Yarry 1,662 11 01/20/04 05:22 PM
by TinMan
* Shroomery Server Upgrades - Report Bugs Here! **Updated 9/8**
( 1 2 all )
YthanA 8,313 39 09/10/05 11:28 PM
by Vampire999
* slow tonite demiu5 790 16 04/11/07 09:05 PM
by demiu5
* MySql error: Colonel Kurtz Ph.D 572 0 03/13/07 09:25 AM
by Colonel Kurtz Ph.D
* Bulletin Board upgrade
( 1 2 3 all )
3DSHROOM 6,987 51 12/10/03 05:20 AM
by Asante

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Ythan, Thor, Seuss, geokills
543 topic views. 0 members, 7 guests and 0 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.026 seconds spending 0.008 seconds on 14 queries.