Page 1 of 2
Optimizing MySQL Database
Posted: Thu Aug 12, 2010 1:27 pm
by Dark_Fox
Hi Everyone
Re: Optimizing MySQL Database
Posted: Thu Aug 12, 2010 1:38 pm
by mikosiko
seems that your site use Wordpress.... maybe it can give you some help
http://codex.wordpress.org/WordPress_Optimization
Re: Optimizing MySQL Database
Posted: Thu Aug 12, 2010 1:41 pm
by Dark_Fox
Re: Optimizing MySQL Database
Posted: Thu Aug 12, 2010 2:00 pm
by Dark_Fox
I give up. people wanna charge, gee so much for "forum help"
Re: Optimizing MySQL Database
Posted: Sat Aug 14, 2010 7:19 pm
by Dark_Fox
I thought this was an experts forum, no one can advise. ?
Re: Optimizing MySQL Database
Posted: Sat Aug 14, 2010 7:26 pm
by John Cartwright
Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
What you are asking involves careful scrutiny of both your schema and the specific queries you are using.
The quick answer would be to perform an "EXPLAIN query_goes_here" on all your queries to determine whether are using the proper indexes. Secondly, you might consider using enabling the slow query log (google has lots of info on it) to determine whether any of your queries are taking a long time to execute.
Unless you are serving a relatively high volume of connections, then you probably won't need to mess with the actual mysql settings.
Re: Optimizing MySQL Database
Posted: Sun Aug 15, 2010 2:53 am
by Dark_Fox
John Cartwright wrote:Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
What you are asking involves careful scrutiny of both your schema and the specific queries you are using.
The quick answer would be to perform an "EXPLAIN query_goes_here" on all your queries to determine whether are using the proper indexes. Secondly, you might consider using enabling the slow query log (google has lots of info on it) to determine whether any of your queries are taking a long time to execute.
Unless you are serving a relatively high volume of connections, then you probably won't need to mess with the actual mysql settings.
Its really the first post where you can see the stats and i wanted to optimize the variables to elimate those issues, can you help. ?
Re: Optimizing MySQL Database
Posted: Sun Aug 15, 2010 12:28 pm
by John Cartwright
Dark_Fox wrote:John Cartwright wrote:Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
What you are asking involves careful scrutiny of both your schema and the specific queries you are using.
The quick answer would be to perform an "EXPLAIN query_goes_here" on all your queries to determine whether are using the proper indexes. Secondly, you might consider using enabling the slow query log (google has lots of info on it) to determine whether any of your queries are taking a long time to execute.
Unless you are serving a relatively high volume of connections, then you probably won't need to mess with the actual mysql settings.
Its really the first post where you can see the stats and i wanted to optimize the variables to elimate those issues, can you help. ?
Like I said, those variables likely have nothing to do with the said performance.
Re: Optimizing MySQL Database
Posted: Sun Aug 15, 2010 1:36 pm
by Dark_Fox
I have been thinking of installing MemCached, perhaps this would help elimate the minor issues that i see, i should mention i don't see any real performance issues when viewing the site, i just want to try and optimize everything, indeed i'm going over the site and looking at cutting down on some scripts and combining some elements.
Re: Optimizing MySQL Database
Posted: Sun Aug 15, 2010 4:11 pm
by Gargoyle
as John tried to indicate, you will have to ask specific questions if you want someone to help you with this. performance optimization is something you can spend a lot of money on (for good reasons).
I usually charge $200/hour. interested?

Re: Optimizing MySQL Database
Posted: Tue Aug 17, 2010 12:32 pm
by Dark_Fox
Gargoyle wrote:as John tried to indicate, you will have to ask specific questions if you want someone to help you with this. performance optimization is something you can spend a lot of money on (for good reasons).
I usually charge $200/hour. interested?

I can see i am wasting my time here, its a bloody useless forum full of people who wanna charge you for help or don't have a clue, i'm thinking i probably know as much as some of you here but i was thinking i had come across an experts forum, obviously not as an expert could help without all this fuss.
By the way Gargoyle if you are only on the forum to drum up business then you are no help whatsoever, if i wanted to be "charged" i'd have gone to specialists and not come to a free forum.
Have fun folks but what a complete waste of time it has been in coming here, my mistake and i have learned from it, please delete this account moderators.
Re: Optimizing MySQL Database
Posted: Wed Aug 18, 2010 2:55 am
by John Cartwright
Oh boy.
Re: Optimizing MySQL Database
Posted: Mon Aug 23, 2010 2:56 am
by Dark_Fox
John Cartwright wrote:Oh boy.
You are an idiot.
See here.
http://www.webhostingtalk.com/showthread.php?t=468168
THATS THE INFORMATION I WAS LOOKING FOR WITH REGARDS OPTIMIZATION WHICH YOU FAILED/COULDN'T PROVIDE BECAUSE YOU DIDN'T HAVE A CLUE.
Goodbye, your forum is useless.
Re: Optimizing MySQL Database
Posted: Mon Aug 23, 2010 9:50 pm
by Gargoyle
apparently you're not even able to distinguish between mysql optimization and VPN server configuration.
Re: Optimizing MySQL Database
Posted: Tue Aug 24, 2010 3:57 pm
by John Cartwright
Oh boy, oh boy.
//troutslaps Dark_Fox
If you want to use our forums in the future, you will treat all members, including myself, with respect. But since you have claimed you will not be back, I will bid you farewall. The only reason I'm continuing this thread is hopefully someone will come along and realize the exact message we've tried to tell you (and failed to get across). I will try to explain things more carefully in the future when dealing with immature members that cannot get what they want.
However, You do realize database optimizations have entire books and school programs dedicated to the subject. Asking me to optimize your database with NO RELEVANT INFORMATION is insane, preposterous, and shows your ignorance.
But who cares what industry professionals think. Lets rely on google.
