MySQL Forums
Forum List  »  Performance

Re: Table structure
Posted by: Rick James
Date: August 19, 2012 08:51PM

> The big problem is: the index size is nearly 60% of the total table size
That, by itself, is not a problem.
I see tables where the index size is twice the data size, yet they are ok.

Provide what Aftab asked for so we can discuss further.

A common mistake:
INDEX(a)
INDEX(a,b)
The first of those is (usually) unnecessary, and can be dropped.

> I'm using innoDB, so the partitioning is not a solution.
InnoDB tables can be PARTITIONed. But it is not necessarily beneficial.

Options: ReplyQuote


Subject
Views
Written By
Posted
1557
August 16, 2012 08:18PM
973
August 17, 2012 02:14AM
Re: Table structure
900
August 19, 2012 08:51PM


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.