PDA

View Full Version : the mysql server is so so so so slow


forgemind
4-16-03, 12:00 PM
It's Wed morning,the server was normal last night but becoming very slow again now.

forgemind
4-16-03, 12:03 PM
it seems that the mysql01.powweb.com is down.

maro
4-16-03, 12:05 PM
Figures...I was just about to launch my site to the world today....and my site is barely running now??????. I just read all the "slow threads" from last night. My site is at a crawl... http://www.thelightroom.org

please fix

-maro

forgemind
4-17-03, 12:17 AM
the server is crawling again!

i found that it slows down a lot at night,gosh!

Starr
4-17-03, 01:54 AM
mysql01# mysqladmin -p status
Enter password:
Uptime: 2772 Threads: 1 Questions: 146676 Slow queries: 0 Opens: 4952 Flush tables: 1 Open tables: 1024 Queries per second avg: 52.913

"Slow queries: 0"

netaustin
4-17-03, 03:28 AM
forgemind, are we sure it's the mysql servers and not something else that's creating the problem?

HalfaBee
4-17-03, 05:09 AM
Of course its the mysql server being slow.

Starr's figures were after it had been rebooted.

Uptime 2772 secs = 2772\60 minutes
Which equals 45 minutes.

Are we really surprised that it had no slow queries in that time?

Probably should be rebooted every night :(

HalfaBee

forgemind
4-18-03, 01:58 PM
i am sorry that my phpBB forum is dead again.
is that because of the server?
it's noon here in philadelphia.