Is it possible to cut a MySQL table in half?
 

Any experts?

from top to bottom or left to right ?

delete half of the records!

yes its possible with the MySQL table saw

Or you can use the MSQL Jigsaw. Hand held of course.

print it out and use scissors

Count the number of rows. If there is 1000. Put 500 in one table and the other 500 in another.

its better to find out what your root problem is rather than start creating multiple tables but incase you're wondering you can have multiple tables which are the same and MERGE. If you're not sure what i mean by "MERGE" then you got some homework to start doing

If your database design is correct, cutting your table in half will make it wrong. If your design is incorrect cutting it in half wont make it right

determine what your real problem is first.

email me if I can help

No (root) problems here. And yes, I know what merge means ;-)

Of course you can just select, load into a new table and delete the old records (which is what I've done), I was just wondering if there's a set of queries to do this more easily.

Thanks for the comments!