MySQL Forums
Forum List  »  Partitioning

Re: Regarding optimizing hugh data with mysql
Posted by: Rick James
Date: October 09, 2012 11:23PM

260M -- rows? bytes?

Please provide the following, so we can provide specific suggestions:
SHOW CREATE TABLE
SHOW TABLE STATUS
Some typical INSERTs, UPDATEs, and SELECTs.

The INDEXes are the most important thing.

PARTITIONing is rarely beneficial; do you have a particular reason for believing that it would help here? See the PARTITION section of
http://mysql.rjweb.org/doc.php/ricksrots

> Everyday there is insert, update, select happening on this table.
How many per day? (Or per second)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Regarding optimizing hugh data with mysql
1582
October 09, 2012 11:23PM


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.