I installed Percona mySQL on my fresh CPanel server (no databases yet) according to: http://www.ecommy.com/linux/install-...el-environment
Everything seemed to be OK and the server also starts fine, except some commands return this error:
root@server [/var/lib/mysql]# mysql -A -sN information_schema -e "select * from user_statistics;" mysql: unknown variable 'innodb_file_per_table=1' root@server [/var/lib/mysql]# mysql -A mysql: unknown variable 'innodb_file_per_table=1'
In my /etc/my.cnf I have:
[mysql] innodb_file_per_table=1 userstat_running=1
I am planning on using InnoDB for the databases.
Anyone know what the problem is? Or even better, how to fix it?
I have installed Percona 5.5 with yum on CentOS.