MySQL Forums
Forum List  »  Partitioning

Re: Partition on non key varchar column
Posted by: Rick James
Date: September 12, 2009 09:45AM

You may be using some "f" words before this discussion is over.

Partitioning, I think, must have a number, not a VARCHAR. If you could have a TINYINT that is the ASC(LEFT(firstword, 1)), that might do the job. But you say you cannot change the code and schema to achieve that?

Even if you could do that, why do you think the performance would be any better?

As an alternative, let's look at the actual slow queries, and see if there are other reasons for sluggishness; 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 ]

Options: ReplyQuote


Subject
Views
Written By
Posted
5133
September 11, 2009 07:52AM
Re: Partition on non key varchar column
2570
September 12, 2009 09:45AM
3161
September 12, 2009 07:24PM


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.