Percona Server 5.5.43-37.2 发布，此版本基于 MySQL 5.5.43，包括其所有 bug 修复，是当前 5.5 系列的安全版本。
更新内容：
Bugs 修复
A server binary as distributed in binary tarballs could fail to load on different systems due to an unsatisfied
libssl.so.6dynamic library dependency. Bug fixed #1172916.mysql_install_dbwould make the server produce an“Error in my_thread_global_end(): 1 threads didn't exit”error message. Bug fixed #1402074.A string literal containing an invalid UTF-8 sequence could be treated as falsely equal to a UTF-8 column value with no invalid sequences. (MDEV-7649).
Percona Server
.debbinaries were built without fast mutexes. Bug fixed #1433980.Installing or uninstalling the Audit Log Plugin would crash the server if the audit_log_file variable was pointing to an inaccessible path. Bug fixed #1435606.
The audit_log_file variable would point to random memory area if the Audit Log Plugin was not loaded into server, and then installed with
INSTALL PLUGIN, andmy.cnfcontained audit_log_file setting. Bug fixed #1437505.Percona Server client
.debpackages were built with withEditLineinstead ofReadline. Bugs fixed #1266386 and #1332822 (upstream #63130 and #69991).
其他 bug 修复： #1436138 (upstream #76505).
更多内容请看发行说明。
Percona 为 MySQL 数据库服务器进行了改进，在功能和性能上较 MySQL 有着很显著的提升。该版本提升了在高负载情况下的 InnoDB 的性能、为 DBA 提供一些非常有用的性能诊断工具；另外有更多的参数和命令来控制服务器行为。
Percona Server 只包含 MySQL 的服务器版，并没有提供相应对 MySQL 的 Connector 和 GUI 工具进行改进。
Percona Server 使用了一些 google-mysql-tools, Proven Scaling, Open Query 对 MySQL 进行改造。
sudo service mysql stop 运行mysql_install_db前关闭原来apt安装的MySQL,以免受到影响.
sudo scripts/mysql_install_db \
--user=png_mysql \
--defaults-file=/png/percona/5.6.23/etc/my.cnf \
--basedir=/png/percona/5.6.23 \
--datadir=/png/percona/5.6.23/data
最后用服务管理脚本mysql.server或者mysqld_safe启动MySQL服务:
sudo /png/percona/5.6.23/bin/mysqld_safe --defaults-file=/png/percona/5.6.23/etc/my.cnf
修改服务脚本mysql.server,只读取一个配置,避免受到其他配置影响:
mysqld_pid_file_path 设为 /png/percona/5.6.23/data/mysqld.pid, 注意跟 /png/percona/5.6.23/etc/my.cnf 的 pid-file 对应.
注释掉 parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server` 这一行.
在'start'下把
$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
改为:
$bindir/mysqld_safe --defaults-file=/png/percona/5.6.23/etc/my.cnf >/dev/null 2>&1 &
[mysqld]
basedir=/png/percona/5.6.23
datadir=/png/percona/5.6.23/data
port=3306
socket = /tmp/mysql.sock
#sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=10M
innodb_log_file_size=5M
character-set-server=utf8
bind-address = 127.0.0.1
log_error = /png/percona/5.6.23/logs/error.log
#log-bin = /png/percona/5.6.23/logs/binlog
general_log = ON
general_log_file = /png/percona/5.6.23/logs/log.sql
slow_query_log = ON
slow_query_log_file = /png/percona/5.6.23/logs/slow.sql
long_query_time = 0.5
pid-file = /png/percona/5.6.23/data/mysqld.pid
user = png_mysql
table_definition_cache=400
table_open_cache=400
[client]
port=3306
socket = /tmp/mysql.sock
cmake . \
-DCMAKE_BUILD_TYPE=Release \
-DBUILD_CONFIG=mysql_release \
-DFEATURE_SET=community \
-DWITH_EMBEDDED_SERVER=OFF \
-DWITH_INNODB_MEMCACHED=ON \
-DCMAKE_INSTALL_PREFIX=/png/percona/5.6.23 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock
cmake/make/make install之后的操作:
新建组和用户:
sudo addgroup png_mysql --system
sudo adduser png_mysql --system --disabled-login --ingroup png_mysql --no-create-home --home /nonexistent --gecos "png_mysql user" --shell /bin/false
创建my.cnf配置文件:
cd /png/percona/5.6.23
cp support-files/my-default.cnf /png/percona/5.6.23/etc/my.cnf