Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

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

[mysqld]
innodb_file_per_table
share|improve this answer
innodb_file_per_table

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

Your Answer

 
discard

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.