I am in need of a highly recommended mysql guru, if you know anyone hook a brotha up!
thanks,
J
thanks,
J
-
I do stuff - aIm CS_Jay_D -
bump-skisI do stuff - aIm CS_Jay_D -
-
What do you need help with? configuration, or usage?- Free Premium Domain Lists and Tools at Clickmojo.com
- For Sale: Obscenity.com
Comment
-
-
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.Originally posted by Brujah
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.Code:last pid: 43788; load averages: 22.36, 25.12, 28.76 up 0+04:11:13 21:52:15 235 processes: 26 running, 208 sleeping, 1 zombie CPU states: 0.0% user, 61.7% nice, 37.1% system, 1.2% interrupt, 0.0% idle Mem: 93M Active, 37M Inact, 128M Wired, 112M Buf, 3379M Free Swap: 4069M Total, 4069M Free
I do stuff - aIm CS_Jay_DComment
-
How do you know the load is from MySQL?I like pie.Comment
-
mysql is the only thing running on this box.I do stuff - aIm CS_Jay_DComment
-
Ahh, that's a pretty good clue.Originally posted by CS-Jay
I like pie.Comment
-
Originally posted by BabaganooshAhh, that's a pretty good clue.
ohh man, that was a good one. I wish it was something else 
I do stuff - aIm CS_Jay_DComment
-
Are the connection coming internally frm this box, or from a seperate box?
AlexComment
-
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.I like pie.Comment
-
from an outside webserver.Originally posted by RawAlexI do stuff - aIm CS_Jay_DComment
-
I am actually running mytop and I see some that are taking awhile. Put I'd really like to kill those sleeping processes.Originally posted by BabaganooshI do stuff - aIm CS_Jay_DComment
-
maybe lower the connection time to wait, damn.. what's that setting..- Free Premium Domain Lists and Tools at Clickmojo.com
- For Sale: Obscenity.com
Comment
-
and as I'm looking at mytop, I'm seeing the sleep threads ares sitting around for a long time.I do stuff - aIm CS_Jay_DComment
-
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.- Free Premium Domain Lists and Tools at Clickmojo.com
- For Sale: Obscenity.com
Comment
-
shit, running 4.2! I don't have some of those in my.cnfOriginally posted by BrujahI do stuff - aIm CS_Jay_DComment
-
nevermind, I believe this will work on 4.1xI do stuff - aIm CS_Jay_DComment
-
Same theory, just need to find the 4.x settings that apply.. you may need to ADD them, to change the default settings.Originally posted by CS-Jay
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.- Free Premium Domain Lists and Tools at Clickmojo.com
- For Sale: Obscenity.com
Comment
-
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.I do stuff - aIm CS_Jay_DComment
Comment