MySQL Forums
Forum List  »  Partitioning

Re: Is partitioning helpful in this case?
Posted by: Rick James
Date: May 25, 2011 08:07PM

There are many possible tips to help you, but first please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

It sounds like the indexes are killing you. We can discuss how to get rid of them, and still get what you need. Please provide the queries you use for accessing the table.

Timestamps to datetimes are virtually compatible in SELECTs, etc. But, I may argue against partitioning on timestamp, or even against partitioning at all. Again, I need more info.

Options: ReplyQuote

Written By
Re: Is partitioning helpful in this case?
May 25, 2011 08:07PM

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.