# MySQL don't start

**URL:** <https://forums.percona.com/t/mysql-dont-start/2442>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [June 14, 2012, 2:58am UTC](https://forums.percona.com/t/mysql-dont-start/2442 "2012-06-14T02:58:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcmyst](https://avatars.discourse-cdn.com/v4/letter/m/91b2a8/32.png) [@mcmyst](https://forums.percona.com/u/mcmyst)\
**Post date:** [June 14, 2012, 2:58am UTC](https://forums.percona.com/t/mysql-dont-start/2442/1 "2012-06-14T02:58:04Z")

</div>

Sorry for posting in this part, but I can’t post in the MySQL section (ERROR: Insufficient Privileges).

I have installed MySQL percona 5.5 from apt repository on a debian 6.0 server.

Without any my.cnf file, mysql starts normally. I have built a my.cnf file with the percona online tool.

[mysql]# CLIENT #socket = /var/lib/mysql/data/mysql.sockport = 3306bind-address = 127.0.0.1[mysqld]# GENERAL #user = mysqldefault\_storage\_engine = InnoDBsocket = /var/lib/mysql/data/mysql.sockpid\_file = /var/lib/mysql/data/mysql.pid# MyISAM #key\_buffer\_size = 32Mmyisam\_recover = FORCE,BACKUP# SAFETY #max\_allowed\_packet = 16Mmax\_connect\_errors = 1000000# DATA STORAGE #datadir = /var/lib/mysql/data/# BINARY LOGGING #log\_bin = /var/lib/mysql/data/mysql-binexpire\_logs\_days = 14sync\_binlog = 1# CACHES AND LIMITS #tmp\_table\_size = 32Mmax\_heap\_table\_size = 32Mquery\_cache\_type = 0query\_cache\_size = 0max\_connections = 500thread\_cache\_size = 50open\_files\_limit = 65535table\_definition\_cache = 4096table\_open\_cache = 4096# INNODB #innodb\_flush\_method = O\_DIRECTinnodb\_log\_files\_in\_group = 2innodb\_log\_file\_size = 128Minnodb\_flush\_log\_at\_trx\_commit = 1innodb\_file\_per\_table = 1innodb\_buffer\_pool\_size = 2G# LOGGING #log\_error = /var/lib/mysql/data/mysql-error.loglog\_queries\_not\_using\_indexes = 1slow\_query\_log = 1slow\_query\_log\_file = /var/lib/mysql/data/mysql-slow.log

With this file, mysql is not starting anymore:

root@:/etc/mysql# /etc/init.d/mysql startStarting MySQL (Percona Server) database server: mysqld . . . . . . . . . . . . . . failed!root@:/home/# ps aux | grep mysqlroot 7204 0.0 0.0 7548 840 pts/0 S+ 10:18 0:00 grep mysql

And I am seing this in the syslog file:

Jun 14 10:17:51 kernel: [4415.971084] mysqld: sending ioctl 4004fecd to a partition!Jun 14 10:17:51 kernel: [4415.971088] mysqld: sending ioctl 4004fecd to a partition!Jun 14 10:18:05 /etc/init.d/mysql[7196]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted inJun 14 10:18:05 /etc/init.d/mysql[7196]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failedJun 14 10:18:05 /etc/init.d/mysql[7196]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'Jun 14 10:18:05 /etc/init.d/mysql[7196]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!Jun 14 10:18:05 /etc/init.d/mysql[7196]:

I don’t know what is wrong ?

When I look in /etc/mysql/debian.cnf, there is an account ‘debian-sys-maint’ but it looks like this file is auto-generated…

I have free space on the partition /var /usr and /tmp:

461M 11M 427M 3% /tmp938M 534M 357M 60% /usr938M 485M 406M 55% /var

No firewall filtering.

Any ideas ?

Thank you

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [August 14, 2012, 4:28am UTC](https://forums.percona.com/t/mysql-dont-start/2442/2 "2012-08-14T04:28:59Z")

</div>

Hello,

Do you have something in /var/lib/mysql/data/mysql-error.log ?