MySQL Forums
Forum List  »  Partitioning

Re: Suggestion for optimization - reg
Posted by: suvendu mohapatra
Date: January 24, 2012 06:50AM

Hi,
-->5M rows? 1 Terabyte?
Yes

-->Normalization
I will do the required normalization.

-->Biometrics in another table
It is not possible. Because it is in production and the structure cannot be changed.

Many fields are there, which are not used at all. Means all rows for those columns contain "NULL" value. So kindly suggest, should I keep Default NULL or change to Default '0'.

-->Switching engine
I tried to switch to Innodb, but it gives "Storage engine error-139". Probably the table conatains more than the maximum column numbers allowed in Innodb engine.

--> Latina1 characterset
I do not have much knowledge about characterset. Kindly suggest a better character set.

Thanks & Regards,
Suvendu

Options: ReplyQuote


Subject
Views
Written By
Posted
1559
January 24, 2012 02:18AM
Re: Suggestion for optimization - reg
1511
January 24, 2012 06:50AM
1398
January 25, 2012 09:09PM
1317
January 26, 2012 02:48PM
1495
January 27, 2012 08:41PM


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.