search
HomeDatabaseMysql TutorialMySQLStudy之--PerconaServer版本_MySQL

MySQL Study之--Percona Server版本 1、简介
Percona 为 MySQL 数据库服务器进行了改进,在功能和性能上较 MySQL 有着很显著的提升。该版本提升了在高负载情况下的 InnoDB 的性能、为 DBA 提供一些非常有用的性能诊断工具;另外有更多的参数和命令来控制服务器行为。
2、特点 Percona Server 只包含 MySQL 的服务器版,并没有提供相应对 MySQL 的 Connector 和 GUI 工具进行改进。
Percona Server 使用了一些 google-mysql-tools, Proven Scaling, Open Query 对 MySQL 进行改造
3、版本发布 2012年08月15日,Percona Server 5.6 Alpha 发布。
2012年08月23日,Percona Server 5.5.27-28.0 发布。
2013年04月11日,Percona Server for MySQL 5.5.30-30.2 发布

案例分析:Percona-Server 安装
下载:https://www.percona.com/downloads/Percona-Server-5.6/
一、安装Percona-Server [root@mysql2 soft]# ls -l
total 101016
-rwxr--r-- 1 oracle oinstall 1593932 Aug 11 11:19 openssl-1.0.1e-42.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 969444 Aug 11 10:51 openssl-libs-1.0.1e-42.el7.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 70389368 Aug 11 10:30 Percona-Server-56-debuginfo-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 6727084 Aug 10 17:18 Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 1031588 Aug 10 17:12 Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 20463420 Aug 10 17:20 Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 742496 Aug 11 10:08 Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr--r-- 1 oracle oinstall 1508480 Aug 11 10:08 Percona-Server-tokudb-56-5.6.25-rel73.1.el6.x86_64.rpm

安装顺序: 1、 Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm 2、Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm 3、Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
1、安装Percona-Server-shared [root@mysql2 soft]# rpm -vih Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
warning: Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-Server-shared-5########################################### [100%]

2、安装Percona-Server-client
[root@mysql2 soft]# rpm -vih Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
warning: Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
MySQL conflicts with mysql-5.1.66-2.el6_3.x86_64
---和原来系统安装的mysql-server冲突
卸载mysql-server: [root@mysql2 soft]# rpm -qa |grep mysql
mysql-devel-5.1.66-2.el6_3.x86_64
mysql-libs-5.1.66-2.el6_3.x86_64
mysql-5.1.66-2.el6_3.x86_64
qt-mysql-4.6.2-25.el6.x86_64
mysql-server-5.1.66-2.el6_3.x86_64

[root@mysql2 soft]# rpm -e mysql-devel-5.1.66-2.el6_3.x86_64

[root@mysql2 soft]# rpm -e mysql-server-5.1.66-2.el6_3.x86_64 --nodeps
[root@mysql2 soft]# rpm -e mysql-5.1.66-2.el6_3.x86_64

[root@mysql2 soft]# rpm -vih Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm --force
warning: Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-Server-client-5########################################### [100%]

3、安装Percona-Server-server
[root@mysql2 soft]# rpm -vih Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
warning: Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-Server-server-5########################################### [100%]
/usr/bin/my_print_defaults: /usr/lib/libcrypto.so.10: no version information available (required by /usr/bin/my_print_defaults)
/usr/bin/my_print_defaults: /usr/lib/libcrypto.so.10: no version information available (required by /usr/bin/my_print_defaults)
/usr/sbin/mysqld: /usr/lib/libssl.so.10: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/lib/libcrypto.so.10: no version information available (required by /usr/sbin/mysqld)
2015-08-11 11:24:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-11 11:24:39 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 7142 ...
2015-08-11 11:24:39 7142 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-11 11:24:39 7142 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-11 11:24:39 7142 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-11 11:24:39 7142 [Note] InnoDB: Memory barrier is not used
2015-08-11 11:24:39 7142 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-11 11:24:39 7142 [Note] InnoDB: Using Linux native AIO
2015-08-11 11:24:39 7142 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-11 11:24:39 7142 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-11 11:24:39 7142 [Note] InnoDB: Completed initialization of buffer pool
2015-08-11 11:24:40 7142 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2015-08-11 11:24:40 7142 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2015-08-11 11:24:40 7142 [Note] InnoDB: Database physically writes the file full: wait...
2015-08-11 11:24:40 7142 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-08-11 11:24:41 7142 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-08-11 11:24:41 7142 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-08-11 11:24:41 7142 [Warning] InnoDB: New log files created, LSN=45781
2015-08-11 11:24:41 7142 [Note] InnoDB: Doublewrite buffer not found: creating new
2015-08-11 11:24:41 7142 [Note] InnoDB: Doublewrite buffer created
2015-08-11 11:24:41 7142 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-11 11:24:41 7142 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-08-11 11:24:41 7142 [Note] InnoDB: Foreign key constraint system tables created
2015-08-11 11:24:41 7142 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-08-11 11:24:41 7142 [Note] InnoDB: Tablespace and datafile system tables created.
2015-08-11 11:24:41 7142 [Note] InnoDB: Waiting for purge to start
2015-08-11 11:24:41 7142 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 0
2015-08-11 11:24:41 7142 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-08-11 11:24:41 7142 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-08-11 11:24:43 7142 [Note] Binlog end
2015-08-11 11:24:43 7142 [Note] InnoDB: FTS optimize thread exiting.
2015-08-11 11:24:43 7142 [Note] InnoDB: Starting shutdown...
2015-08-11 11:24:45 7142 [Note] InnoDB: Shutdown completed; log sequence number 1625977
/usr/sbin/mysqld: /usr/lib/libssl.so.10: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/lib/libcrypto.so.10: no version information available (required by /usr/sbin/mysqld)
2015-08-11 11:24:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-11 11:24:45 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 7166 ...
2015-08-11 11:24:45 7166 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-11 11:24:45 7166 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-11 11:24:45 7166 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-11 11:24:45 7166 [Note] InnoDB: Memory barrier is not used
2015-08-11 11:24:45 7166 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-11 11:24:45 7166 [Note] InnoDB: Using Linux native AIO
2015-08-11 11:24:45 7166 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-11 11:24:45 7166 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-11 11:24:45 7166 [Note] InnoDB: Completed initialization of buffer pool
2015-08-11 11:24:45 7166 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-11 11:24:45 7166 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-11 11:24:45 7166 [Note] InnoDB: Waiting for purge to start
2015-08-11 11:24:45 7166 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 1625977
2015-08-11 11:24:45 7166 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-08-11 11:24:45 7166 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-08-11 11:24:45 7166 [Note] Binlog end
2015-08-11 11:24:45 7166 [Note] InnoDB: FTS optimize thread exiting.
2015-08-11 11:24:45 7166 [Note] InnoDB: Starting shutdown...
2015-08-11 11:24:47 7166 [Note] InnoDB: Shutdown completed; log sequence number 1625987
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mysql2 password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems at
https://bugs.launchpad.net/percona-server/+filebug
The latest information about Percona Server is available on the web at
http://www.percona.com/software/percona-server
Support Percona by buying support at
http://www.percona.com/products/mysql-support
WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
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://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details

查询安装信息:
[root@mysql2 soft]# rpm -qa |grep -i percona
Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64
Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64
Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64

[root@mysql2 soft]# rpm -ql Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64
/etc/init.d/mysql
/etc/logrotate.d/mysql
/etc/my.cnf
/usr/bin/innochecksum
/usr/bin/my_print_defaults
/usr/bin/myisam_ftdump
/usr/bin/myisamchk
/usr/bin/myisamlog
/usr/bin/myisampack
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_install_db
/usr/bin/mysql_plugin
/usr/bin/mysql_secure_installation
/usr/bin/mysql_setpermission
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_upgrade
/usr/bin/mysql_zap
/usr/bin/mysqlbug
/usr/bin/mysqld_multi
/usr/bin/mysqld_safe
/usr/bin/mysqldumpslow
/usr/bin/mysqlhotcopy
/usr/bin/mysqltest
/usr/bin/perror
/usr/bin/replace
/usr/bin/resolve_stack_dump
/usr/bin/resolveip
/usr/lib64/mysql/plugin/adt_null.so
/usr/lib64/mysql/plugin/audit_log.so
/usr/lib64/mysql/plugin/auth.so
/usr/lib64/mysql/plugin/auth_pam.so
/usr/lib64/mysql/plugin/auth_pam_compat.so
/usr/lib64/mysql/plugin/auth_socket.so
/usr/lib64/mysql/plugin/auth_test_plugin.so
/usr/lib64/mysql/plugin/daemon_example.ini
/usr/lib64/mysql/plugin/debug/adt_null.so
/usr/lib64/mysql/plugin/debug/audit_log.so
/usr/lib64/mysql/plugin/debug/auth.so
/usr/lib64/mysql/plugin/debug/auth_pam.so
/usr/lib64/mysql/plugin/debug/auth_pam_compat.so
/usr/lib64/mysql/plugin/debug/auth_socket.so
/usr/lib64/mysql/plugin/debug/auth_test_plugin.so
/usr/lib64/mysql/plugin/debug/dialog.so
/usr/lib64/mysql/plugin/debug/handlersocket.so
/usr/lib64/mysql/plugin/debug/innodb_engine.so
/usr/lib64/mysql/plugin/debug/libdaemon_example.so
/usr/lib64/mysql/plugin/debug/libfnv1a_udf.so
/usr/lib64/mysql/plugin/debug/libfnv_udf.so
/usr/lib64/mysql/plugin/debug/libmemcached.so
/usr/lib64/mysql/plugin/debug/libmurmur_udf.so
/usr/lib64/mysql/plugin/debug/mypluglib.so
/usr/lib64/mysql/plugin/debug/mysql_no_login.so
/usr/lib64/mysql/plugin/debug/qa_auth_client.so
/usr/lib64/mysql/plugin/debug/qa_auth_interface.so
/usr/lib64/mysql/plugin/debug/qa_auth_server.so
/usr/lib64/mysql/plugin/debug/query_response_time.so
/usr/lib64/mysql/plugin/debug/scalability_metrics.so
/usr/lib64/mysql/plugin/debug/semisync_master.so
/usr/lib64/mysql/plugin/debug/semisync_slave.so
/usr/lib64/mysql/plugin/debug/validate_password.so
/usr/lib64/mysql/plugin/dialog.so
/usr/lib64/mysql/plugin/handlersocket.so
/usr/lib64/mysql/plugin/innodb_engine.so
/usr/lib64/mysql/plugin/libdaemon_example.so
/usr/lib64/mysql/plugin/libfnv1a_udf.so
/usr/lib64/mysql/plugin/libfnv_udf.so
/usr/lib64/mysql/plugin/libmemcached.so
/usr/lib64/mysql/plugin/libmurmur_udf.so
/usr/lib64/mysql/plugin/mypluglib.so
/usr/lib64/mysql/plugin/mysql_no_login.so
/usr/lib64/mysql/plugin/qa_auth_client.so
/usr/lib64/mysql/plugin/qa_auth_interface.so
/usr/lib64/mysql/plugin/qa_auth_server.so
/usr/lib64/mysql/plugin/query_response_time.so
/usr/lib64/mysql/plugin/scalability_metrics.so
/usr/lib64/mysql/plugin/semisync_master.so
/usr/lib64/mysql/plugin/semisync_slave.so
/usr/lib64/mysql/plugin/validate_password.so
/usr/sbin/mysqld
/usr/sbin/mysqld-debug
/usr/sbin/rcmysql
/usr/share/doc/Percona-Server-server-56-5.6.25
/usr/share/doc/Percona-Server-server-56-5.6.25/COPYING
/usr/share/doc/Percona-Server-server-56-5.6.25/INFO_BIN
/usr/share/doc/Percona-Server-server-56-5.6.25/INFO_SRC
/usr/share/doc/Percona-Server-server-56-5.6.25/README
/usr/share/doc/Percona-Server-server-56-5.6.25/my-default.cnf
/usr/share/info/mysql.info.gz
/usr/share/man/man1/innochecksum.1.gz
/usr/share/man/man1/my_print_defaults.1.gz
/usr/share/man/man1/myisam_ftdump.1.gz
/usr/share/man/man1/myisamchk.1.gz
/usr/share/man/man1/myisamlog.1.gz
/usr/share/man/man1/myisampack.1.gz
/usr/share/man/man1/mysql.server.1.gz
/usr/share/man/man1/mysql_convert_table_format.1.gz
/usr/share/man/man1/mysql_fix_extensions.1.gz
/usr/share/man/man1/mysql_install_db.1.gz
/usr/share/man/man1/mysql_plugin.1.gz
/usr/share/man/man1/mysql_secure_installation.1.gz
/usr/share/man/man1/mysql_setpermission.1.gz
/usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
/usr/share/man/man1/mysql_upgrade.1.gz
/usr/share/man/man1/mysql_zap.1.gz
/usr/share/man/man1/mysqlbug.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/mysqlhotcopy.1.gz
/usr/share/man/man1/mysqlman.1.gz
/usr/share/man/man1/mysqltest.1.gz
/usr/share/man/man1/perror.1.gz
/usr/share/man/man1/replace.1.gz
/usr/share/man/man1/resolve_stack_dump.1.gz
/usr/share/man/man1/resolveip.1.gz
/usr/share/man/man8/mysqld.8.gz
/usr/share/percona-server/SELinux
/usr/share/percona-server/SELinux/RHEL4
/usr/share/percona-server/SELinux/RHEL4/mysql.fc
/usr/share/percona-server/SELinux/RHEL4/mysql.te
/usr/share/percona-server/binary-configure
/usr/share/percona-server/bulgarian
/usr/share/percona-server/bulgarian/errmsg.sys
/usr/share/percona-server/charsets
/usr/share/percona-server/charsets/Index.xml
/usr/share/percona-server/charsets/README
/usr/share/percona-server/charsets/armscii8.xml
/usr/share/percona-server/charsets/ascii.xml
/usr/share/percona-server/charsets/cp1250.xml
/usr/share/percona-server/charsets/cp1251.xml
/usr/share/percona-server/charsets/cp1256.xml
/usr/share/percona-server/charsets/cp1257.xml
/usr/share/percona-server/charsets/cp850.xml
/usr/share/percona-server/charsets/cp852.xml
/usr/share/percona-server/charsets/cp866.xml
/usr/share/percona-server/charsets/dec8.xml
/usr/share/percona-server/charsets/geostd8.xml
/usr/share/percona-server/charsets/greek.xml
/usr/share/percona-server/charsets/hebrew.xml
/usr/share/percona-server/charsets/hp8.xml
/usr/share/percona-server/charsets/keybcs2.xml
/usr/share/percona-server/charsets/koi8r.xml
/usr/share/percona-server/charsets/koi8u.xml
/usr/share/percona-server/charsets/latin1.xml
/usr/share/percona-server/charsets/latin2.xml
/usr/share/percona-server/charsets/latin5.xml
/usr/share/percona-server/charsets/latin7.xml
/usr/share/percona-server/charsets/macce.xml
/usr/share/percona-server/charsets/macroman.xml
/usr/share/percona-server/charsets/swe7.xml
/usr/share/percona-server/czech
/usr/share/percona-server/czech/errmsg.sys
/usr/share/percona-server/danish
/usr/share/percona-server/danish/errmsg.sys
/usr/share/percona-server/dictionary.txt
/usr/share/percona-server/dutch
/usr/share/percona-server/dutch/errmsg.sys
/usr/share/percona-server/english
/usr/share/percona-server/english/errmsg.sys
/usr/share/percona-server/errmsg-utf8.txt
/usr/share/percona-server/estonian
/usr/share/percona-server/estonian/errmsg.sys
/usr/share/percona-server/fill_help_tables.sql
/usr/share/percona-server/french
/usr/share/percona-server/french/errmsg.sys
/usr/share/percona-server/german
/usr/share/percona-server/german/errmsg.sys
/usr/share/percona-server/greek
/usr/share/percona-server/greek/errmsg.sys
/usr/share/percona-server/hungarian
/usr/share/percona-server/hungarian/errmsg.sys
/usr/share/percona-server/innodb_memcached_config.sql
/usr/share/percona-server/italian
/usr/share/percona-server/italian/errmsg.sys
/usr/share/percona-server/japanese
/usr/share/percona-server/japanese/errmsg.sys
/usr/share/percona-server/korean
/usr/share/percona-server/korean/errmsg.sys
/usr/share/percona-server/magic
/usr/share/percona-server/my-default.cnf
/usr/share/percona-server/mysql-log-rotate
/usr/share/percona-server/mysql.server
/usr/share/percona-server/mysql_security_commands.sql
/usr/share/percona-server/mysql_system_tables.sql
/usr/share/percona-server/mysql_system_tables_data.sql
/usr/share/percona-server/mysql_test_data_timezone.sql
/usr/share/percona-server/mysqld_multi.server
/usr/share/percona-server/norwegian
/usr/share/percona-server/norwegian-ny
/usr/share/percona-server/norwegian-ny/errmsg.sys
/usr/share/percona-server/norwegian/errmsg.sys
/usr/share/percona-server/polish
/usr/share/percona-server/polish/errmsg.sys
/usr/share/percona-server/portuguese
/usr/share/percona-server/portuguese/errmsg.sys
/usr/share/percona-server/romanian
/usr/share/percona-server/romanian/errmsg.sys
/usr/share/percona-server/russian
/usr/share/percona-server/russian/errmsg.sys
/usr/share/percona-server/serbian
/usr/share/percona-server/serbian/errmsg.sys
/usr/share/percona-server/slovak
/usr/share/percona-server/slovak/errmsg.sys
/usr/share/percona-server/spanish
/usr/share/percona-server/spanish/errmsg.sys
/usr/share/percona-server/swedish
/usr/share/percona-server/swedish/errmsg.sys
/usr/share/percona-server/ukrainian
/usr/share/percona-server/ukrainian/errmsg.sys

二、配置Percona-Server
[root@mysql2 soft]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@mysql2 soft]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
explicit_defaults_for_timestamp=true
innodb_buffer_pool_size = 128M
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M

启动mysql服务:
[root@mysql2 soft]# service mysql start
/usr/bin/my_print_defaults: /usr/lib/libcrypto.so.10: no version information available (required by /usr/bin/my_print_defaults)
Starting MySQL (Percona Server).....[ OK ]
[root@mysql2 soft]# netstat -an |grep :3306
tcp 0 0 :::3306 :::* LISTEN
修改root密码:
[root@mysql2 soft]# mysqladmin -u root password "oracle"
mysqladmin: /usr/lib/libcrypto.so.10: no version information available (required by mysqladmin)
mysqladmin: /usr/lib/libssl.so.10: no version information available (required by mysqladmin)
Warning: Using a password on the command line interface can be insecure.
连接数据库:
[root@mysql2 soft]# mysql -u root -p
mysql: /usr/lib/libcrypto.so.10: no version information available (required by mysql)
mysql: /usr/lib/libssl.so.10: no version information available (required by mysql)
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>


安装遇到的问题:
1、libssl.so.10和libcrypto.so.10 错误 [root@rh6 oracle]#rpm -vih Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
warning: Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
Percona-Server-client-56 is needed by Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64
Percona-Server-shared-56 is needed by Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64
libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64
libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64

[root@rh6 oracle]#rpm -ivh Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
warning: Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
Percona-Server-shared-56 is needed by Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64
libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64
libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64
MySQL conflicts with mysql-5.1.66-2.el6_3.x86_64

卸载原有的mysql:
[root@rh6 oracle]#rpm -qa |grep mysql
mysql-devel-5.1.66-2.el6_3.x86_64
mysql-libs-5.1.66-2.el6_3.x86_64
mysql-5.1.66-2.el6_3.x86_64
qt-mysql-4.6.2-25.el6.x86_64
dovecot-mysql-2.0.9-5.el6.x86_64

[root@rh6 oracle]#rpm -e mysql-devel-5.1.66-2.el6_3.x86_64
[root@rh6 oracle]#rpm -e mysql-5.1.66-2.el6_3.x86_64


安装openssl:

下载openssl-1.0.1:
http://pkgs.org/centos-7/centos-x86_64/openssl-libs-1.0.1e-42.el7.x86_64.rpm/download/

[root@mysql2 soft]# rpm -ivh openssl-1.0.1e-42.el6.x86_64.rpm --force
warning: openssl-1.0.1e-42.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:openssl ########################################### [100%]
[root@mysql2 soft]# rpm -qa |grep openssl
openssl-1.0.1e-42.el6.x86_64
openssl-1.0.0-27.el6.x86_64
openssl098e-0.9.8e-17.el6_2.2.x86_64
openssl-devel-1.0.0-27.el6.x86_64

----RedHat EL6自带openssl-1.0.0版本,对于Percona-Server应该安装openssl-1.0.1的版本,安装新版本后,问题解决。


2、解决“/usr/lib/libcrypto.so.10: no version information available ” [root@mysql2 soft]# rpm -qa |grep openssl
openssl-1.0.1e-42.el6.x86_64
openssl-1.0.0-27.el6.x86_64
openssl098e-0.9.8e-17.el6_2.2.x86_64
openssl-devel-1.0.0-27.el6.x86_64

卸载openssl旧版本: [root@mysql2 soft]# rpm -e openssl-devel-1.0.0-27.el6.x86_64
[root@mysql2 soft]# rpm -e openssl-1.0.0-27.el6.x86_64 [root@mysql2 soft]# rpm -e openssl098e-0.9.8e-17.el6_2.2.x86_64
[root@mysql2 soft]# ls -l /usr/lib/libcrypto.so.10
-rwxr-xr-x 1 root root 1665328 Aug 11 10:40 /usr/lib/libcrypto.so.10
[root@mysql2 soft]# rpm -ql openssl

[root@mysql2 soft]#
/etc/pki/CA
/etc/pki/CA/certs
/etc/pki/CA/crl
/etc/pki/CA/newcerts
/etc/pki/CA/private
/etc/pki/tls
/etc/pki/tls/certs
/etc/pki/tls/certs/Makefile
/etc/pki/tls/certs/make-dummy-cert
/etc/pki/tls/certs/renew-dummy-cert
/etc/pki/tls/misc
/etc/pki/tls/misc/CA
/etc/pki/tls/misc/c_hash
/etc/pki/tls/misc/c_info
/etc/pki/tls/misc/c_issuer
/etc/pki/tls/misc/c_name
/etc/pki/tls/openssl.cnf
/etc/pki/tls/private
/usr/bin/openssl
/usr/lib64/.libcrypto.so.1.0.1e.hmac
/usr/lib64/.libcrypto.so.10.hmac
/usr/lib64/.libssl.so.1.0.1e.hmac
/usr/lib64/.libssl.so.10.hmac
/usr/lib64/libcrypto.so.1.0.1e
/usr/lib64/libcrypto.so.10
/usr/lib64/libssl.so.1.0.1e
/usr/lib64/libssl.so.10
/usr/lib64/openssl
/usr/lib64/openssl/engines
/usr/lib64/openssl/engines/lib4758cca.so
/usr/lib64/openssl/engines/libaep.so
/usr/lib64/openssl/engines/libatalla.so
/usr/lib64/openssl/engines/libcapi.so
/usr/lib64/openssl/engines/libchil.so
/usr/lib64/openssl/engines/libcswift.so
/usr/lib64/openssl/engines/libgmp.so
/usr/lib64/openssl/engines/libnuron.so
/usr/lib64/openssl/engines/libpadlock.so
/usr/lib64/openssl/engines/libsureware.so
/usr/lib64/openssl/engines/libubsec.so
/usr/share/doc/openssl-1.0.1e
/usr/share/doc/openssl-1.0.1e/CHANGES
/usr/share/doc/openssl-1.0.1e/FAQ
/usr/share/doc/openssl-1.0.1e/INSTALL
/usr/share/doc/openssl-1.0.1e/LICENSE
/usr/share/doc/openssl-1.0.1e/NEWS
/usr/share/doc/openssl-1.0.1e/README
/usr/share/doc/openssl-1.0.1e/README.FIPS
/usr/share/doc/openssl-1.0.1e/c-indentation.el
/usr/share/doc/openssl-1.0.1e/openssl.txt
/usr/share/doc/openssl-1.0.1e/openssl_button.gif
/usr/share/doc/openssl-1.0.1e/openssl_button.html
/usr/share/doc/openssl-1.0.1e/ssleay.txt
/usr/share/man/man1/asn1parse.1ssl.gz
/usr/share/man/man1/ca.1ssl.gz
/usr/share/man/man1/ciphers.1ssl.gz
/usr/share/man/man1/cms.1ssl.gz
/usr/share/man/man1/crl.1ssl.gz
/usr/share/man/man1/crl2pkcs7.1ssl.gz
/usr/share/man/man1/dgst.1ssl.gz
/usr/share/man/man1/dhparam.1ssl.gz
/usr/share/man/man1/dsa.1ssl.gz
/usr/share/man/man1/dsaparam.1ssl.gz
/usr/share/man/man1/ec.1ssl.gz
/usr/share/man/man1/ecparam.1ssl.gz
/usr/share/man/man1/enc.1ssl.gz
/usr/share/man/man1/errstr.1ssl.gz
/usr/share/man/man1/gendsa.1ssl.gz
/usr/share/man/man1/genpkey.1ssl.gz
/usr/share/man/man1/genrsa.1ssl.gz
/usr/share/man/man1/md2.1ssl.gz
/usr/share/man/man1/md4.1ssl.gz
/usr/share/man/man1/md5.1ssl.gz
/usr/share/man/man1/mdc2.1ssl.gz
/usr/share/man/man1/nseq.1ssl.gz
/usr/share/man/man1/ocsp.1ssl.gz
/usr/share/man/man1/openssl.1ssl.gz
/usr/share/man/man1/pkcs12.1ssl.gz
/usr/share/man/man1/pkcs7.1ssl.gz
/usr/share/man/man1/pkcs8.1ssl.gz
/usr/share/man/man1/pkey.1ssl.gz
/usr/share/man/man1/pkeyparam.1ssl.gz
/usr/share/man/man1/pkeyutl.1ssl.gz
/usr/share/man/man1/req.1ssl.gz
/usr/share/man/man1/ripemd160.1ssl.gz
/usr/share/man/man1/rsa.1ssl.gz
/usr/share/man/man1/rsautl.1ssl.gz
/usr/share/man/man1/s_client.1ssl.gz
/usr/share/man/man1/s_server.1ssl.gz
/usr/share/man/man1/s_time.1ssl.gz
/usr/share/man/man1/sess_id.1ssl.gz
/usr/share/man/man1/sha.1ssl.gz
/usr/share/man/man1/sha1.1ssl.gz
/usr/share/man/man1/smime.1ssl.gz
/usr/share/man/man1/speed.1ssl.gz
/usr/share/man/man1/spkac.1ssl.gz
/usr/share/man/man1/sslpasswd.1ssl.gz
/usr/share/man/man1/sslrand.1ssl.gz
/usr/share/man/man1/ts.1ssl.gz
/usr/share/man/man1/tsget.1ssl.gz
/usr/share/man/man1/verify.1ssl.gz
/usr/share/man/man1/version.1ssl.gz
/usr/share/man/man1/x509.1ssl.gz
/usr/share/man/man5/config.5ssl.gz
/usr/share/man/man5/openssl.cnf.5ssl.gz
/usr/share/man/man5/x509v3_config.5ssl.gz
/usr/share/man/man7/des_modes.7ssl.gz
[root@mysql2 soft]# ls -l /usr/lib64/libcrypt*
lrwxrwxrwx 1 root root 19 Aug 11 11:21 /usr/lib64/libcrypto.so.10 -> libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 1963296 Jul 24 03:09 /usr/lib64/libcrypto.so.1.0.1e
lrwxrwxrwx. 1 root root 25 Sep 29 2013 /usr/lib64/libcrypt.so -> ../../lib64/libcrypt.so.1
lrwxrwxrwx. 1 root root 19 Sep 29 2013 /usr/lib64/libcryptui.so.0 -> libcryptui.so.0.0.0
-rwxr-xr-x 1 root root 78280 Mar 15 2010 /usr/lib64/libcryptui.so.0.0.0
[root@mysql2 soft]# ln -s /usr/lib64/libcrypto.so.1.0.1e /usr/lib/libcrypto.so.10
ln: creating symbolic link `/usr/lib/libcrypto.so.10': File exists
[root@mysql2 soft]# ln -sf /usr/lib64/libcrypto.so.1.0.1e /usr/lib/libcrypto.so.10
[root@mysql2 soft]# ls -l /usr/lib/libcrypto.so.10 lrwxrwxrwx 1 root root 30 Aug 11 11:46 /usr/lib/libcrypto.so.10 -> /usr/lib64/libcrypto.so.1.0.1e
[root@mysql2 soft]# service mysql start
Starting MySQL (Percona Server)....[ OK ]
---自此,问题解决!
3、解决“/usr/lib/libssl.so.10: no version information available” [root@mysql2 soft]# mysql -u root -p mysql: /usr/lib/libssl.so.10: no version information available (required by mysql)
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
建立libssl的链接:
[root@mysql2 soft]# ln -sf /usr/lib64/libssl.so.10 /usr/lib/libssl.so.10

[root@mysql2 soft]# mysql -u root -p

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

-----问题解决!
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
修复:任务栏溢出在 Windows 11 上不起作用修复:任务栏溢出在 Windows 11 上不起作用Jul 18, 2023 am 09:41 AM

当Windows11任务栏溢出功能停止工作时,用户将丢失重要的自定义选项。这是因为该功能允许您将尽可能多的应用程序添加到任务栏并轻松启动它们。虽然这个问题可能令人沮丧,但并不是最难解决的。在本综合指南中,我们准备了万无一失的方法,以使任务栏溢出功能再次正常工作。为什么任务栏溢出在Windows11上不起作用?正如用户报告的那样,有几个因素可能导致任务栏溢出在Windows11上不起作用。以下是一些值得注意的原因:过时的PC:过时的操作系统是此问题的主要原因。如果您使用高于Windows11预览体

轻量化版 Win 11 – Tiny11 2311 正式推出:只占 8GB 空间轻量化版 Win 11 – Tiny11 2311 正式推出:只占 8GB 空间Nov 27, 2023 pm 02:06 PM

一款基于Windows11最新版本23H2的轻量化系统「Tiny112311」正式推出,提供了更精简的系统体验。该系统去除了许多不必要的组件和高硬件要求,使得安装后的占用空间仅需约8GB。Tiny112311集主要功能于一身作为基于最新Windows11版本23H2的产物,Tiny112311包含了微软引入的所有新功能,包括Copilot功能(需通过winget下载微软Edge,因为没有预装浏览器)、原生RAR支持、重新设计的音量滑块、设定应用中的RGB控制等。与之前的Tiny11版本相比,23

如何解决Win11安装后显示为Win10版本的问题如何解决Win11安装后显示为Win10版本的问题Dec 27, 2023 am 08:18 AM

一些朋友在下载安装完win11系统后,发现自己的win11版本显示的却是win10,这可能是因为我们下载了错误的win11系统,也可能是因为微软win11自身的原因,下面就跟着小编一起来看看吧。win11安装后显示版本是win10怎么办一、下载了错误的win111、如果我们下载了错误的win11系统,就可能会在安装后显示win10。2、因此大家可以重新下载一个win11进行覆盖安装。3、我们不需要重新退回win10,只需要装载该系统,然后运行“setup”安装程序进行安装就可以了。二、系统错误1

Stable Diffusion XL 现已推出—有什么新功能,你知道吗?Stable Diffusion XL 现已推出—有什么新功能,你知道吗?Apr 07, 2023 pm 11:21 PM

3月27号,Stability AI的创始人兼首席执行官Emad Mostaque在一条推文中宣布,Stable Diffusion XL 现已可用于公开测试。以下是一些事项:“XL”不是这个新的AI模型的官方名称。一旦发布稳定性AI公司的官方公告,名称将会更改。与先前版本相比,图像质量有所提高与先前版本相比,图像生成速度大大加快。示例图像让我们看看新旧AI模型在结果上的差异。Prompt: Luxury sports car with aerodynamic curves, shot in a

PHP8.0中的匿名函数PHP8.0中的匿名函数May 14, 2023 am 08:31 AM

PHP8.0是当前最新版本的PHP编程语言。一项重要的更新是对匿名函数的改进和增强。匿名函数(也称为闭包)是一种特殊类型的函数,可以在运行时动态创建并传递给其他函数或存储在变量中。在PHP中,匿名函数对于高级编程和Web开发至关重要。PHP8.0提供了一些新的语法和功能,可以使匿名函数更加灵活和易于使用。其中一些更新如下:函数参数的类型声明在PHP8.0中,

win101909和22h2对比,有什么区别?win101909和22h2对比,有什么区别?Dec 22, 2023 pm 04:09 PM

不少用户在使用电脑系统的时候都会比较纠结不知道该怎么选择win101909和22h2这两个版本,其实从版本迭代来看,建议是选择22H2更好,因为这个可以看成是一个版本更新。win101909和22h2哪个好答:win1022h2更好。Windows1022H2相较于先前的版本1909而言,虽然只是些许的更新改进,但这实际上算是一种微小的突破性进步。1、1909版乃是Windows10的第九款迭代版本,该产品在2019年的11月份正式浮出水面。2、此版本为功能升级,并非全新的Windows10版本

Windows将在不久的将来停用TLS 1.0和TLS 1.1Windows将在不久的将来停用TLS 1.0和TLS 1.1Aug 12, 2023 am 11:37 AM

Microsoft计划在Windows中禁用传输层安全性(TLS)协议版本1.0和1.1。该公司于1年2023月日在其技术社区网站上宣布了这一消息。这两个协议可以追溯到1999年(TLS1.0)和2006年(TLS1.1),此后被新版本TLS1.2和TLS1.3超越。Microsoft指出,在较旧的协议版本中发现了安全问题,并且“互联网标准和监管机构已弃用或不允许TLS版本1.0和1.1作为响应。多年来,TLS1.0和1.1的使用量显着下降,Microsoft认为禁用这两种协议的时候到了。Mic

解决win10最新版本2004驱动冲突的方法解决win10最新版本2004驱动冲突的方法Dec 26, 2023 am 10:37 AM

如果我们当前使用的操作系统是win102004的话,对于一些用户在使用的过程中可能就会遇到一些无法解决的问题。针对win10最新版本2004驱动冲突的情况,小编觉得我们可以尝试使用第三方软件进行问题的修复,可以升级更新自己的驱动或者重装驱动即可。详细操作方法就来看下小编是怎么做的吧~win10最新版本2004驱动冲突怎么解决方法一:1.找到桌面上的图标,右键点击。点击之后会弹出菜单,选择2.打开窗口之后,找到并点击窗口左侧的按钮3.打开之后,找到下的显卡型号一项,右键点击,并在弹出的菜单中选择4

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),