# CentOS 5 and Percona Startup (and my.cnf feedback request) **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [August 16, 2011, 12:22am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648 "2011-08-16T00:22:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![mikerarity](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mikerarity/32/853_2.png) [@mikerarity](https://forums.percona.com/u/mikerarity)\ **Post date:** [August 16, 2011, 12:22am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/1 "2011-08-16T00:22:48Z")
We’ve just received two new Cisco C210 servers and so I decided to install CentOS 5 - clean install. When I install MySQL 5.1 (or 5.5) and try to start it, it won’t work unless I use the sudo command. Any idea why? [root@tigdb2 mysql]# /etc/init.d/mysql start Starting MySQL (Percona Server). ERROR! Manager of pid-file quit without updating file. [root@tigdb2 mysql]# sudo /bin/sh /etc/init.d/mysql start Starting MySQL (Percona Server)… SUCCESS! [root@tigdb2 mysql]# Also, I’d appreciate any feedback on this my.cnf - we have 64 GB of RAM: [mysqld] datadir = /var/lib/mysql port = 3306 socket = /home/mysql/mysql.sock pid-file = /home/mysql/mysql.pid sync\_binlog = 1 skip-external-locking skip\_name\_resolve key\_buffer = 400M max\_allowed\_packet = 8M table\_cache = 2500 sort\_buffer\_size = 3M read\_buffer\_size = 2M read\_rnd\_buffer\_size = 6M myisam\_sort\_buffer\_size = 50M thread\_cache = 40 query\_cache\_size = 512M ft\_min\_word\_len = 3 tmp\_table\_size = 512M max\_heap\_table\_size = 128M query\_cache\_limit = 2M query\_prealloc\_size = 24576 max\_binlog\_size = 128000000 max\_connect\_errors = 10000 wait\_timeout = 1200 expire\_logs\_days = 10 slow-query-log = 1 log-warnings = 0 log-slave-updates long\_query\_time = 10 #log-queries-not-using-indexes innodb\_file\_per\_table myisam\_recover=BACKUP,FORCE character-set-server=utf8 thread\_concurrency = 4 max\_connections = 500 server\_id = 5 log-bin = tigdb3-bin relay-log = tigdb3-relay-bin auto\_increment\_increment = 2 auto\_increment\_offset = 1 slave-skip-errors=1062 innodb\_buffer\_pool\_size = 16384M innodb\_additional\_mem\_pool\_size = 20M innodb\_flush\_method=O\_DIRECT innodb\_log\_file\_size = 1024M innodb\_log\_buffer\_size = 8M innodb\_flush\_log\_at\_trx\_commit = 0 [mysqldump] quick max\_allowed\_packet = 16M ---
**Author:** ![mikerarity](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mikerarity/32/853_2.png) [@mikerarity](https://forums.percona.com/u/mikerarity)\ **Post date:** [August 22, 2011, 9:37pm UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/2 "2011-08-22T21:37:35Z")
Oops, I actually meant to reference CentOS 6, not 5. Any ideas on this issue? ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [August 23, 2011, 5:16am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/3 "2011-08-23T05:16:33Z")
check the permissions of /home/mysql/mysql.pid and /home/mysql and make sure the mysql user can write to mysql.pid. ---
**Author:** ![mikerarity](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mikerarity/32/853_2.png) [@mikerarity](https://forums.percona.com/u/mikerarity)\ **Post date:** [August 23, 2011, 1:00pm UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/4 "2011-08-23T13:00:21Z")
Yes, both are owned by the mysql user/group. (and writable by both) ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [August 24, 2011, 4:36am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/5 "2011-08-24T04:36:27Z")
Maybe there’s more info in the MySQL log files, but please also check your system log files (selinux perhaps?) ---
**Author:** ![mikerarity](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mikerarity/32/853_2.png) [@mikerarity](https://forums.percona.com/u/mikerarity)\ **Post date:** [August 29, 2011, 1:45am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/6 "2011-08-29T01:45:17Z")
MySQL logs don’t show anything ☹ I checked the two selinux options related to MySQL and have disabled both. Any specific selinux instructions for a setting change to allow MySQL to start? I’m not too familiar with SELinux. Thank you! ---
**Author:** ![morgo](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/morgo/32/752_2.png) [@morgo](https://forums.percona.com/u/morgo)\ **Post date:** [September 1, 2011, 10:07am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/7 "2011-09-01T10:07:44Z")
I’ve noticed similar before on my servers. Your first start that ‘failed’, may not have actually failed. There is a timeout that might have happened first (wait a bit and then try and connect to MySQL / ps aux for it). ---
**Author:** ![melco](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@melco](https://forums.percona.com/u/melco)\ **Post date:** [September 3, 2011, 2:07pm UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/8 "2011-09-03T14:07:42Z")
Please, run “ausearch -c mysqld -sv no” and post output here ---
**Author:** ![melco](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@melco](https://forums.percona.com/u/melco)\ **Post date:** [September 8, 2011, 6:21am UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/9 "2011-09-08T06:21:03Z")
Attach your init script here. I’ll compare with my ---
**Author:** ![mikerarity](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mikerarity/32/853_2.png) [@mikerarity](https://forums.percona.com/u/mikerarity)\ **Post date:** [September 8, 2011, 11:09pm UTC](https://forums.percona.com/t/centos-5-and-percona-startup-and-my-cnf-feedback-request/1648/10 "2011-09-08T23:09:13Z")
Here it is. Thank you!