Re: How to improve mysql when the table is larger than 4G

[Rick James]

Can you change the schema and/or the SELECTs? If so, we can discuss further; 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 ]

If not, can you switch to RAID with striping and write cache enabled?

160.5 million messages -- that's getting interesting and challenging. But I need to be able to do major changes to the schema/SELECTs.