# tools.percona.com my.cnf fails

**URL:** <https://forums.percona.com/t/tools-percona-com-my-cnf-fails/2644>\
**Category:** Other MySQL® Questions\
**Created:** [April 23, 2013, 10:29pm UTC](https://forums.percona.com/t/tools-percona-com-my-cnf-fails/2644 "2013-04-23T22:29:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![larishosting](https://avatars.discourse-cdn.com/v4/letter/l/71e660/32.png) [@larishosting](https://forums.percona.com/u/larishosting)\
**Post date:** [April 23, 2013, 10:29pm UTC](https://forums.percona.com/t/tools-percona-com-my-cnf-fails/2644/1 "2013-04-23T22:29:01Z")

</div>

**Figured it out in case someone else has this issues**

innodb\_log\_file\_size = 256M is causing the error because the sites is smaller than the current log file.

[URL=“[http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html"]http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html[/URL="http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html](http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html%22%5Dhttp://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html%5B/URL=%22http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html)”]

I keep trying to build new my.cnf from Percona tools and every time myql fails to restart.

Starting MySQL (Percona Server).The server quit without updating PID file (/mysql//server.domain.com.pid). [FAILED]

Config from the tool

# Generated by Percona Configuration Wizard ([URL=“[http://tools.percona.com/"]http://tools.percona.com/[/URL="http://tools.percona.com/](http://tools.percona.com/%22%5Dhttp://tools.percona.com/%5B/URL=%22http://tools.percona.com/)”]) version REL5-20120208

# Configuration name server generated for at 2013-04-24 03:55:30

[mysql]

# CLIENT

port = 3306

socket = /mysql/mysql.sock

[mysqld]

# GENERAL

user = mysql

default\_storage\_engine = InnoDB

socket = /mysql/mysql.sock

pid\_file = /mysql/mysql.pid

# MyISAM

key\_buffer\_size = 32M

myisam\_recover = FORCE,BACKUP

# SAFETY

max\_allowed\_packet = 16M

max\_connect\_errors = 1000000

skip\_name\_resolve

sql\_mode = STRICT\_TRANS\_TABLES,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_ AUTO\_CREATE\_USER,NO\_AUTO\_VALUE\_ON\_ZERO,NO\_ENGINE\_S UBSTITUTION,NO\_ZERO\_DATE,NO\_ZERO\_IN\_DATE,ONLY\_FULL \_GROUP\_BY

sysdate\_is\_now = 1

innodb = FORCE

innodb\_strict\_mode = 1

# DATA STORAGE

datadir = /mysql/

# BINARY LOGGING

log\_bin = /mysql/mysql-bin

expire\_logs\_days = 14

sync\_binlog = 1

# CACHES AND LIMITS

tmp\_table\_size = 32M

max\_heap\_table\_size = 32M

query\_cache\_type = 0

query\_cache\_size = 0

max\_connections = 500

thread\_cache\_size = 50

open\_files\_limit = 65535

table\_definition\_cache = 4096

table\_open\_cache = 10240

# INNODB

innodb\_flush\_method = O\_DIRECT

innodb\_log\_files\_in\_group = 2

innodb\_log\_file\_size = 256M

innodb\_flush\_log\_at\_trx\_commit = 2

innodb\_file\_per\_table = 1

innodb\_buffer\_pool\_size = 6G

# LOGGING

log\_error = /mysql/mysql-error.log

log\_queries\_not\_using\_indexes = 1

slow\_query\_log = 1

slow\_query\_log\_file = /mysql/mysql-slow.log