I have recently installed 5.5.27-29.0 for my Ubunto development server which runs on VM.
When I start mysql using /etc/init.d/mysql start it takes few seconds and comes back with status failed however no indication in mysql-error.log and server runs absoultly fine.
i am able to login and even run replication from Mysql 5.1 server, could this be a possible bug?
which is the stable release which can be used in production ?
here are the commands output
/etc/init.d/mysql stop
- Stopping MySQL (Percona Server) mysqld [ OK ]
/etc/init.d/mysql start
- Starting MySQL (Percona Server) database server mysqld [fail]
tail -f mysql-error.log
121021 16:24:55 mysqld_safe Starting mysqld daemon with databases from /data/system/mysql5-5/
121021 16:24:55 [Note] Plugin ‘FEDERATED’ is disabled.
121021 16:24:55 InnoDB: The InnoDB memory heap is disabled
121021 16:24:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121021 16:24:55 InnoDB: Compressed tables use zlib 1.2.3
121021 16:24:55 InnoDB: Using Linux native AIO
121021 16:24:55 InnoDB: Initializing buffer pool, size = 6.0G
121021 16:24:56 InnoDB: Completed initialization of buffer pool
121021 16:24:56 InnoDB: highest supported file format is Barracuda.
121021 16:24:58 InnoDB: Waiting for the background threads to start
121021 16:24:59 Percona XtraDB ( http://www.percona.com ) 1.1.8-rel29.0 started; log sequence number 3334042464
121021 16:24:59 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306
121021 16:24:59 [Note] - ‘0.0.0.0’ resolves to ‘0.0.0.0’;
121021 16:24:59 [Note] Server socket created on IP: ‘0.0.0.0’.
121021 16:24:59 [Note] Event Scheduler: Loaded 0 events
121021 16:24:59 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.5.27-29.0-log’ socket: ‘/data/system/mysql5-5/mysql.sock’ port: 3306 Percona Server (GPL), Release 29.0
mysql --version
mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
mysql> select @@version;
±----------------+
| @@version |
±----------------+
| 5.5.27-29.0-log |
±----------------+
1 row in set (0.00 sec)