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.
Subject
Views
Written By
Posted
4244
March 24, 2011 07:00AM
2095
March 25, 2011 09:14AM
1901
March 25, 2011 03:03PM
Re: Partitioning table by timestamp column type
1654
March 25, 2011 07:02PM
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.