Partition p1 moves from /tmp into main mysql db directory (in datadir)
Is this a known bug? Or is it something Im doing wrong?
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
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.