Hi,
First of all i am sorry to post new post here again as i see this is right place to post for installation errors.
I am new to percona, till now I have worked on mysql. Just learned about percona two days back and so thought of giving a try to platform. So i tired in my one of the VPS which is on servermania on openVZ.
Details of Installation is as below:
OS: Centos 6.5 x64
RAM: 4GB
I have not installed any thing prior to percona installation. It is clean fresh OS install. Just did upate through yum update. And followed below installation instruction page for percona installation.
“http://www.percona.com/doc/percona-server/5.6/installation.html”
Repository get installed without any issue.
Start installation with command “yum install Percona-Server-client-56 Percona-Server-server-56” as per the instruction guide i get below output for installation process.
===========================================================
[root@domainmy ~]# yum install Percona-Server-client-56 Percona-Server-server-56
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
- base: mirror.kentdigital.net
- extras: mirror.solarvps.com
- updates: distro.ibiblio.org
Setting up Install Process
Resolving Dependencies
/…
…/
Dependencies Resolved
==================================================================================
Package Arch Version Repository Size
Installing:
Percona-Server-client-56 x86_64 5.6.20-rel68.0.el6 percona-release-x86_64 6.4 M
Percona-Server-server-56 x86_64 5.6.20-rel68.0.el6 percona-release-x86_64 19 M
Installing for dependencies:
Percona-Server-shared-56 x86_64 5.6.20-rel68.0.el6 percona-release-x86_64 720 k
libaio x86_64 0.3.107-10.el6 base 21 k
perl x86_64 4:5.10.1-136.el6 base 10 M
perl-Module-Pluggable x86_64 1:3.90-136.el6 base 40 k
perl-Pod-Escapes x86_64 1:1.04-136.el6 base 32 k
perl-Pod-Simple x86_64 1:3.13-136.el6 base 212 k
perl-libs x86_64 4:5.10.1-136.el6 base 578 k
perl-version x86_64 3:0.77-136.el6 base 51 k
Transaction Summary
Install 10 Package(s)
Total download size: 38 M
Installed size: 158 M
Is this ok [y/N]: y
Downloading Packages:
/…
…/
(8/10): perl-Pod-Simple-3.13-136.el6.x86_64.rpm | 212 kB 00:00
(9/10): perl-libs-5.10.1-136.el6.x86_64.rpm | 578 kB 00:00
(10/10): perl-version-0.77-136.el6.x86_64.rpm | 51 kB 00:00
Total 15 MB/s | 38 MB 00:02
warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Importing GPG key 0xCD2EFD2A:
/…
…/
Is this ok [y/N]: y
/…
…/
Running Transaction
Installing : Percona-Server-shared-56-5.6.20-rel68.0.el6.x86_64 1/10
Installing : 1: perl-Pod-Escapes-1.04-136.el6.x86_64 2/10
Installing : 4: perl-libs-5.10.1-136.el6.x86_64 3/10
Installing : 1: perl-Pod-Simple-3.13-136.el6.x86_64 4/10
Installing : 3: perl-version-0.77-136.el6.x86_64 5/10
Installing : 1: perl-Module-Pluggable-3.90-136.el6.x86_64 6/10
Installing : 4: perl-5.10.1-136.el6.x86_64 7/10
Installing : Percona-Server-client-56-5.6.20-rel68.0.el6.x86_64 8/10
Installing : libaio-0.3.107-10.el6.x86_64 9/10
Installing : Percona-Server-server-56-5.6.20-rel68.0.el6.x86_64 10/10
2014-09-29 01:47:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-29 01:47:27 804 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-29 01:47:27 804 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-29 01:47:27 804 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-09-29 01:47:27 804 [Note] InnoDB: Memory barrier is not used
2014-09-29 01:47:27 804 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-29 01:47:27 804 [Note] InnoDB: Using Linux native AIO
2014-09-29 01:47:27 804 [Note] InnoDB: Using CPU crc32 instructions
2014-09-29 01:47:27 7fe2e45137e0 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
2014-09-29 01:47:29 7fe2e45137e0 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
2014-09-29 01:47:29 804 [ERROR] InnoDB: Fatal : Cannot initialize AIO sub-system
2014-09-29 01:47:29 804 [ERROR] Plugin ‘InnoDB’ init function returned error.
2014-09-29 01:47:29 804 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2014-09-29 01:47:29 804 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-09-29 01:47:29 804 [ERROR] Aborting
2014-09-29 01:47:29 804 [Note] Binlog end
2014-09-29 01:47:29 804 [Note] /usr/sbin/mysqld: Shutdown complete
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e “CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME ‘libfnv1a_udf.so’”
mysql -e “CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME ‘libfnv_udf.so’”
mysql -e “CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME ‘libmurmur_udf.so’”
See [url]http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html[/url] for more details
Verifying : 1: perl-Module-Pluggable-3.90-136.el6.x86_64 1/10
Verifying : 1: perl-Pod-Escapes-1.04-136.el6.x86_64 2/10
Verifying : Percona-Server-server-56-5.6.20-rel68.0.el6.x86_64 3/10
Verifying : 4: perl-5.10.1-136.el6.x86_64 4/10
Verifying : 4: perl-libs-5.10.1-136.el6.x86_64 5/10
Verifying : 1: perl-Pod-Simple-3.13-136.el6.x86_64 6/10
Verifying : Percona-Server-shared-56-5.6.20-rel68.0.el6.x86_64 7/10
Verifying : Percona-Server-client-56-5.6.20-rel68.0.el6.x86_64 8/10
Verifying : 3: perl-version-0.77-136.el6.x86_64 9/10
Verifying : libaio-0.3.107-10.el6.x86_64 10/10
Installed:
Percona-Server-client-56.x86_64 0:5.6.20-rel68.0.el6 Percona-Server-server-56.x86_64 0:5.6.20-rel68.0.el6
Dependency Installed:
Percona-Server-shared-56.x86_64 0:5.6.20-rel68.0.el6 libaio.x86_64 0:0.3.107-10.el6
perl.x86_64 4:5.10.1-136.el6 perl-Module-Pluggable.x86_64 1:3.90-136.el6
perl-Pod-Escapes.x86_64 1:1.04-136.el6 perl-Pod-Simple.x86_64 1:3.13-136.el6
perl-libs.x86_64 4:5.10.1-136.el6 perl-version.x86_64 3:0.77-136.el6
Complete!
As installation shows “Complete” but can see some InnoDB and Timestamp errors. Also as installation shows complete so i thought to give try to start server but it gives below error
“ERROR! MySQL (Percona Server) PID file could not be found!
Starting MySQL (Percona Server)… ERROR! The server quit without updating PID file (/var/lib/mysql/domainmy.com.pid).”
Request support team here to please help in finding solution of the above problem.