MySQL Forums
Forum List  »  Partitioning

Re: Partitioning table by timestamp column type
Posted by: Rick James
Date: March 25, 2011 07:02PM

It's a rare MySQL box that cannot sustain 100 queries per second, once certain naughties are taken care of. (100/sec = 8 million/day)

30K transactions per day -- yawn.
30K transactions per minute -- interesting.

You don't need to pursue PARTITIONing for speed. Anyway, PARTITION does not necessarily provide any speed improvement.

If you have individual queries that are running "too slow", let's optimize them. I made a 1-line change in a SELECT last week; it decreased the CPU on the box from 25% to 2%. Sometimes adding the 'right' index can speed up a query by 100x.

Options: ReplyQuote

Written By
Re: Partitioning table by timestamp column type
March 25, 2011 07:02PM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.