Re: Regarding optimizing hugh data with mysql

[Rick James]

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)