MySQL Performance: MySQL => Slow-queries - Problems with mysql configuration

Members

Help

Home

Home » Performance » MySQL » Slow-queries - Problems with mysql configuration

Show: Today's Messages :: Show Polls :: Message Navigator

Slow-queries - Problems with mysql configuration [message #3751]

Sun, 30 November 2008 12:52

Breaks
Messages: 2
Registered: November 2008

Junior Member

Hello
I have portal on server:
Intel Bi Xeon Quad
8x 2.66+ GHz
12 MB L2 - FSB 1333 MHz
64 bits
RAM: 12 GB FBDIMM DDR2
Hard drives: 2x 147 GB SAS 15 000 tr/min - RAID 1 HARD

But sometimes i have problem with mysql. When it is working sometimes there are errors in slow-queris. I see there are lags for about 30 seconds and i can't find what is wrong. Look at STATUS in phpmyadmin.

http://hosting04.imagecross.com/image-hosting-11/2502info.pn g
I think this problem can be connected with these errors and my question is how can i fix them and where can be problem with slow-queries.

Here is my.cnf
http://phpfi.com/383720

Thanks for reply

P.S
sry for my english. I am begginer Wink

[Updated on: Sun, 30 November 2008 12:55]

Report message to a moderator

Re: Slow-queries - Problems with mysql configuration [message #3755 is a reply to message #3751 ]

Tue, 02 December 2008 22:58

wildastar
Messages: 1
Registered: December 2008

Junior Member

check ur slow-query's execute plan.

Report message to a moderator

Re: Slow-queries - Problems with mysql configuration [message #3780 is a reply to message #3751 ]

Tue, 09 December 2008 20:23

januzi
Messages: 25
Registered: December 2008

Junior Member

Last time I heard about 30 seconds lags it was because problems with RAID. Check cpu and hdd performance, if there are 100% then You should check Your hardware.

There could be also problems with Your tables, queries and indexes. Did You check select queries with explain ?

[Updated on: Tue, 09 December 2008 20:24]

Report message to a moderator

Re: Slow-queries - Problems with mysql configuration [message #3782 is a reply to message #3751 ]

Wed, 10 December 2008 00:56

Breaks
Messages: 2
Registered: November 2008

Junior Member

Status: DEGRADED
phy0 : SEAGATE ST3146854SS
Size: 136 GB
Status: FAILED
phy1 : SEAGATE ST3146854SS
Size: 136 GB
Status: ONLINE

Problem has been solved.

Thanks for all. Smile

Report message to a moderator

Re: Slow-queries - Problems with mysql configuration [message #3824 is a reply to message #3782 ]

Fri, 19 December 2008 02:58

debug
Messages: 128
Registered: March 2008

Senior Member

Use Nagios or other monitoring tool to know about RAID failures as soon as they happen Smile

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Previous Topic:	i had problem with mysql in linux
Next Topic:	can any one help me

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 7 17:53:23 EST 2009

Total time taken to generate the page: 0.07486 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.