|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
05-01-2006, 03:35 PM
|
#1 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
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
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
05-01-2006, 06:27 PM
|
#2 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
bump-skis
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
05-01-2006, 06:40 PM
|
#4 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
What do you need help with? configuration, or usage?
__________________
|
|
|
|
|
05-01-2006, 06:45 PM
|
#5 |
|
Confirmed User
Join Date: Nov 2004
Posts: 4,628
|
|
|
|
|
|
05-01-2006, 06:53 PM
|
#6 | |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
Quote:
And my over head is just huge, here's a sample: 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_D |
|
|
|
|
|
05-01-2006, 07:03 PM
|
#7 |
|
♥♥♥ Likes Hugs ♥♥♥
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
|
How do you know the load is from MySQL?
__________________
I like pie. |
|
|
|
|
05-01-2006, 07:06 PM
|
#8 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
mysql is the only thing running on this box.
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
05-01-2006, 07:12 PM
|
#9 | |
|
♥♥♥ Likes Hugs ♥♥♥
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
|
Quote:
__________________
I like pie. |
|
|
|
|
|
05-01-2006, 07:17 PM
|
#10 | |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
Quote:
ohh man, that was a good one. I wish it was something else 
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
|
05-01-2006, 07:29 PM
|
#11 |
|
So Fucking Banned
Join Date: Oct 2003
Location: In a house.
Posts: 9,465
|
Are the connection coming internally frm this box, or from a seperate box?
Alex |
|
|
|
|
05-01-2006, 07:34 PM
|
#12 |
|
♥♥♥ Likes Hugs ♥♥♥
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
|
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. |
|
|
|
|
05-01-2006, 07:35 PM
|
#13 | |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
Quote:
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
|
05-01-2006, 07:36 PM
|
#14 | |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
Quote:
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
|
05-01-2006, 07:37 PM
|
#15 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
maybe lower the connection time to wait, damn.. what's that setting..
__________________
|
|
|
|
|
05-01-2006, 07:38 PM
|
#16 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
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_D |
|
|
|
|
05-01-2006, 07:39 PM
|
#17 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
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.
__________________
|
|
|
|
|
05-01-2006, 07:45 PM
|
#18 | |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
Quote:
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
|
05-01-2006, 07:48 PM
|
#19 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
nevermind, I believe this will work on 4.1x
__________________
I do stuff - aIm CS_Jay_D |
|
|
|
|
05-01-2006, 07:49 PM
|
#20 | |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
Quote:
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.
__________________
|
|
|
|
|
|
05-01-2006, 08:01 PM
|
#21 |
|
Confirmed User
Join Date: Oct 2003
Location: Command Central, West Palm Beach, Fl
Posts: 1,794
|
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_D |
|
|
|
