mysql partition enabled or not? When I run show variables like 'have_partitioning'; it return empty record. When I run show plugins I got this result  partition | ACTIVE | STORAGE ENGINE|NULL    | GPL| My MySQL version is 5.6.29 and I'm running it in CentOS. What I have to do to get Yes when I run 'show variables like 'have_partitinoing
have_partitioning variable is removed from MySQL version is 5.6.29. That's why it is not showing.Instead of it you can use show plugins for knowing partition is enabled or not.If status value is Active then it is enabled.You can also disable partition by adding skip-partition=True while starting mysql server.