Optimizing MySQL Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Optimizing MySQL Database

Post by Dark_Fox »

Hi Everyone
Last edited by Dark_Fox on Tue Aug 17, 2010 12:26 pm, edited 1 time in total.
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: Optimizing MySQL Database

Post by mikosiko »

seems that your site use Wordpress.... maybe it can give you some help

http://codex.wordpress.org/WordPress_Optimization
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post by Dark_Fox »

mikosiko wrote:seems that your site use Wordpress.... maybe it can give you some help

http://codex.wordpress.org/WordPress_Optimization
No.
Last edited by Dark_Fox on Tue Aug 17, 2010 12:28 pm, edited 1 time in total.
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post by Dark_Fox »

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.
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post by Dark_Fox »

I thought this was an experts forum, no one can advise. ?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Optimizing MySQL Database

Post by John Cartwright »

Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
:roll:

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.
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post by Dark_Fox »

John Cartwright wrote:
Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
:roll:

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. ?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Optimizing MySQL Database

Post by John Cartwright »

Dark_Fox wrote:
John Cartwright wrote:
Dark_Fox wrote:I thought this was an experts forum, no one can advise. ?
:roll:

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.
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post 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.
Gargoyle
Forum Contributor
Posts: 130
Joined: Wed Jul 14, 2010 12:25 am

Re: Optimizing MySQL Database

Post 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? :)
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post 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.
Last edited by Dark_Fox on Mon Aug 23, 2010 2:57 am, edited 1 time in total.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Optimizing MySQL Database

Post by John Cartwright »

Oh boy.
Dark_Fox
Forum Newbie
Posts: 8
Joined: Thu Aug 12, 2010 1:18 pm

Re: Optimizing MySQL Database

Post 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.
Gargoyle
Forum Contributor
Posts: 130
Joined: Wed Jul 14, 2010 12:25 am

Re: Optimizing MySQL Database

Post by Gargoyle »

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.
apparently you're not even able to distinguish between mysql optimization and VPN server configuration.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Optimizing MySQL Database

Post 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. :banghead:
Post Reply