Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed Percona mySQL on my fresh CPanel server (no databases yet) according to:

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:


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.

share|improve this question

That setting goes in the [mysqld] section not the [mysql] section in the /etc/my.cnf. If you move it to the correct section that issue will go away

share|improve this answer
I tried that, but when I change mysql to mysqld, the server doesn't start. – user1227914 Jul 8 '12 at 21:29
He didn't say rename the section, he said move the variable to the correct section. – Ben Lessani - Sonassi Jul 9 '12 at 7:44

Use innodb_file_per_table in the following way under [mysqld] section in my.cnf

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.