Is it possible to partition MySQL table across multiple disks on Windows?
I’m running MySQL 5.1 and Windows 2008. No problem creating partitions on a single disk…but seems impossible to partition across multiple disks on Windows using MySQL InnoDB setup. Tried manually creating symlinks. Can’t find anything on web. Is it not possible to partition a MySQL table across multiple disks on Windows?
No, MySQL creates a new file for every database and not for every table.
You can create a new table on a new partition and use a view or enum to merge the two tables into a Pseudo Table, but performance is not great on large tables.