How to split the huge mysql table (size around 200GB) internally? Is there any mechanism other than partition? The table size is daily growing. Table created using innodb with indices. Thanks in advance.
Table have around 30 columns. Most of the time, i use select * as i need to show all the field. Then there is no problem in fetching data. Problem is size of table. ibd file size is now around 200gb. There are many tables like this. So i need to split the table internally as i don't have access to modify the code.