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.

[url]MySQL Bugs: #75112: Optimize table removes the data directory in partitions – upstream
[url]https://bugs.launchpad.net/percona-server/+bug/1399562[/url]

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.