MySQL Forums
Forum List  »  Performance

Re: Help with peculiar DB setup
Posted by: Rick James
Date: January 19, 2009 10:28AM

Don't bother splitting; it adds complexity usually without any performance benefit.

Multi-cores: Mysql doesn't benefit beyond about 4 cores. An individual SELECT will not take advantage of multiple cores.

Build summary tables, even for one-of queries (sometimes). Pick a time interval (say, hour). Pick some other interesting dimensions, such as site / response code, url requested. Design a table(s) with key of 'hour' and one or more other dimensions, plus columns for count(*) AS ct, sum(response_time) AS sum_resp, etc. Your reports can get daily/weekly/etc stats like SUM(sum_resp)/SUM(ct) AS avg_response_time WHERE hour BETWEEN ? AND ?. Properly done, summary tables can cover most ad hoc queries and run easily 10x faster.

RAID with striping may help -- but not a whole lot if you are doing one query at a time.

Flash memory should help -- but watch out; it is possibly too much slower than DRAM to be of enough use.

You can get machines with 16GB of RAM -- nearly enough for your data and indexes.

Options: ReplyQuote


Subject
Views
Written By
Posted
3163
January 19, 2009 08:08AM
Re: Help with peculiar DB setup
1555
January 19, 2009 10:28AM
1641
January 19, 2009 12:42PM
1543
January 21, 2009 01:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.