Split Mysql Table internally 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.
There is few ways to do it as per below-

1) partitioning but you don't want it. Also need to remember that partitioning does not support with foreign keys.

2) You can normalize your table if there is duplicate values in table.

3) If this table contains transactional data or logs then you can move old data in historical tables year wise etc if possible in your environment.