Optimize table removes the data directory in partitions

It becomes:

Partition p1 moves from /tmp into main mysql db directory (in datadir)

Percona: 5.6.21-69.0

Is this a known bug? Or is it something Im doing wrong?

Hi Chavy,

Thanks for reporting this. This is indeed bug and not well known so I have already reported it. Please subscribe it for further update.

http://bugs.mysql.com/bug.php?id=75112 – upstream
https://bugs.launchpad.net/percona-server/+bug/1399562

If your goal was to get a performance boost by carefully placing MySQL files on different physical drives… In general, you get a better perf boost by using RAID striping.