# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysql/dbprod/reference-p0.sock' (2)
[root@mirror ~]# service mysql restart
MySQL (Percona Server) PID file could not be found! [FAILED]
Starting MySQL (Percona Server)........... [ OK ]
The problem is valid for 5.5 and needs to be fixed.
# rpm -qa | grep Percona Server- shared- compat- 5.5.35- rel33.0. 611.rhel6. x86_64 Server- client- 55-5.5. 39-rel36. 0.el6.x86_ 64 Server- server- 55-5.5. 39-rel36. 0.el6.x86_ 64 Server- shared- 55-5.5. 39-rel36. 0.el6.x86_ 64 Server- devel-55- 5.5.39- rel36.0. el6.x86_ 64
Percona-
Percona-
Percona-
Percona-
Percona-
Here is an excerpt from the yum update output
Downloading Packages: Server- client- 55-5.5. 40-rel36. 1.el6.x86_ 6 | 5.9 MB 00:00 Server- devel-55- 5.5.40- rel36.1. el6.x86_ 64 | 946 kB 00:00 Server- server- 55-5.5. 40-rel36. 1.el6.x86_ 6 | 15 MB 00:00 Server- shared- 55-5.5. 40-rel36. 1.el6.x86_ 6 | 648 kB 00:00 ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --- Server- shared- 55-5.5. 40-rel36. 1.el6.x86_ 64 1/8 Server- client- 55-5.5. 40-rel36. 1.el6.x86_ 64 2/8 Server- server- 55-5.5. 40-rel36. 1.el6.x86_ 64 3/8 dbdata1/ reference- p0/*.err: No such file or directory dbdata1/ reference- p0/*.err: No such file or directory www.percona. com/doc/ percona- server/ 5.5/management/ udf_percona_ toolkit. html for more details Server- devel-55- 5.5.40- rel36.1. el6.x86_ 64 4/8 Server- devel-55- 5.5.39- rel36.0. el6.x86_ 64 5/8 Server- server- 55-5.5. 39-rel36. 0.el6.x86_ 64 6/8 Server- client- 55-5.5. 39-rel36. 0.el6.x86_ 64 7/8 Server- shared- 55-5.5. 39-rel36. 0.el6.x86_ 64 8/8 Server- devel-55- 5.5.40- rel36.1. el6.x86_ 64 1/8 Server- server- 55-5.5. 40-rel36. 1.el6.x86_ 64 2/8 Server- shared- 55-5.5. 40-rel36. 1.el6.x86_ 64 3/8 Server- client- 55-5.5. 40-rel36. 1.el6.x86_ 64 4/8 Server- client- 55-5.5. 39-rel36. 0.el6.x86_ 64 5/8 Server- devel-55- 5.5.39- rel36.0. el6.x86_ 64 6/8 Server- shared- 55-5.5. 39-rel36. 0.el6.x86_ 64 7/8 Server- server- 55-5.5. 39-rel36. 0.el6.x86_ 64 8/8
(1/4): Percona-
(2/4): Percona-
(3/4): Percona-
(4/4): Percona-
-------
Total 46 MB/s | 23 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : Percona-
Updating : Percona-
Updating : Percona-
ls: cannot access /opt/mysql/
ls: cannot access /opt/mysql/
Giving mysqld 5 seconds to exit nicely
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 http://
Updating : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Updated: Server- client- 55.x86_ 64 0:5.5.40- rel36.1. el6 Server- devel-55. x86_64 0:5.5.40- rel36.1. el6 Server- server- 55.x86_ 64 0:5.5.40- rel36.1. el6 Server- shared- 55.x86_ 64 0:5.5.40- rel36.1. el6
Percona-
Percona-
Percona-
Percona-
Complete!
# mysql dbprod/ reference- p0.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysql/
[root@mirror ~]# service mysql restart
MySQL (Percona Server) PID file could not be found! [FAILED]
Starting MySQL (Percona Server)........... [ OK ]