Anyone recommend a Mysql guru?
 

I am in need of a highly recommended mysql guru, if you know anyone hook a brotha up!

thanks,
J

bump-skis

dang, im an e guru. sorry

bump for ya

What do you need help with? configuration, or usage?

:smilie_we :smilie_we :smilie_we

www.bluewirestudio.com :thumbsup

I have all persistent connections off, I mean, at the php file level the php.ini level and yet I am getting like 120-200 sleeping processes.

And my over head is just huge, here's a sample:
I am just not sure where it the super huge load is coming from. I don't have slow logs on yet. But the error logs says nothing. And I have caching on.

How do you know the load is from MySQL?

mysql is the only thing running on this box.

Ahh, that's a pretty good clue. :1orglaugh

:1orglaugh ohh man, that was a good one. I wish it was something else :Oh crap

Are the connection coming internally frm this box, or from a seperate box?

Alex

You can try

SHOW PROCESSLIST;

to see if there are any queries taking an unreasonably long time to execute. That's a decent place to start.

from an outside webserver.

I am actually running mytop and I see some that are taking awhile. Put I'd really like to kill those sleeping processes.

maybe lower the connection time to wait, damn.. what's that setting..

and as I'm looking at mytop, I'm seeing the sleep threads ares sitting around for a long time.

Here's a link.. this is what I'm talking about.
http://mysqldatabaseadministration.b...ing-guide.html

Decrease the value of connect_timeout: By default, the wait_timeout value is 28800. Unless you want MySQL to keep waiting for 28800 seconds (480 minutes or 8 hours), please decrease its value according to your application needs.

shit, running 4.2! I don't have some of those in my.cnf

nevermind, I believe this will work on 4.1x

Same theory, just need to find the 4.x settings that apply.. you may need to ADD them, to change the default settings.

Like.. find your my.cnf file and add these in the [mysqld] section.

set-variable = wait_timeout=60
set-variable = connect_timeout=10

Then restart mysql and see.

Brujah, you da man! I dropped the wait timeout to 15, wait_timeout=15 and I dropped from 3xx processors to 80! And the load is dropping too.