Optimizing MySQL Database
Moderator: General Moderators
Optimizing MySQL Database
Hi Everyone
Last edited by Dark_Fox on Tue Aug 17, 2010 12:26 pm, edited 1 time in total.
Re: Optimizing MySQL Database
seems that your site use Wordpress.... maybe it can give you some help
http://codex.wordpress.org/WordPress_Optimization
http://codex.wordpress.org/WordPress_Optimization
Re: Optimizing MySQL Database
No.mikosiko wrote:seems that your site use Wordpress.... maybe it can give you some help
http://codex.wordpress.org/WordPress_Optimization
Last edited by Dark_Fox on Tue Aug 17, 2010 12:28 pm, edited 1 time in total.
Re: Optimizing MySQL Database
I give up. people wanna charge, gee so much for "forum help"
Last edited by Dark_Fox on Tue Aug 17, 2010 12:29 pm, edited 1 time in total.
Re: Optimizing MySQL Database
I thought this was an experts forum, no one can advise. ?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Optimizing MySQL Database
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
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. ?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Optimizing MySQL Database
Like I said, those variables likely have nothing to do with the said performance.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. ?
Re: Optimizing MySQL Database
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
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 usually charge $200/hour. interested?
Re: Optimizing MySQL Database
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.
Last edited by Dark_Fox on Mon Aug 23, 2010 2:57 am, edited 1 time in total.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Optimizing MySQL Database
Oh boy.
Re: Optimizing MySQL Database
You are an idiot.John Cartwright wrote:Oh boy.
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
apparently you're not even able to distinguish between mysql optimization and VPN server configuration.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.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Optimizing MySQL Database
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.
//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.