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