Is it possible to partition MySQL table across multiple disks on Windows?

I’m regulating MySQL 5.1 as well as Windows 2008. No complaint formulating partitions upon the singular disk…but seems unfit to assign opposite mixed disks upon Windows regulating MySQL InnoDB setup. Tried manually formulating symlinks. Can’t find anything upon web. Is it not probable to assign the MySQL list opposite mixed disks upon Windows?

One thought on “Is it possible to partition MySQL table across multiple disks on Windows?

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>