MySQL Study之--Percona Server 5.5升级5.6(五)

2015-12-15 22:18:19 · 作者: · 浏览: 113
percona-56]# rpm -qa |grep Percona-Server-server
Percona-Server-server-55-5.5.46-rel37.5.el6.x86_64
[root@cent65 percona-56]# rpm -e Percona-Server-server-55-5.5.46-rel37.5.el6.x86_64
error: Failed dependencies:
? ? ? ? mysql-server is needed by (installed) akonadi-1.2.1-2.el6.x86_64
[root@cent65 percona-56]# rpm -e Percona-Server-server-55-5.5.46-rel37.5.el6.x86_64 --nodeps


2)、安装server 5.6
[root@cent65 percona-56]# rpm -ivh Percona-Server-server* --force --nodeps


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%]


2015-12-03 12:41:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


2015-12-03 12:41:04 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 4000 ...


2015-12-03 12:41:04 4000 [Note] InnoDB: Using atomics to ref count buffer pool pages


2015-12-03 12:41:04 4000 [Note] InnoDB: The InnoDB memory heap is disabled


2015-12-03 12:41:04 4000 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins


2015-12-03 12:41:04 4000 [Note] InnoDB: Memory barrier is not used


2015-12-03 12:41:04 4000 [Note] InnoDB: Compressed tables use zlib 1.2.3


2015-12-03 12:41:04 4000 [Note] InnoDB: Using Linux native AIO


2015-12-03 12:41:04 4000 [Note] InnoDB: Using CPU crc32 instructions


2015-12-03 12:41:04 4000 [Note] InnoDB: Initializing buffer pool, size = 128.0M


2015-12-03 12:41:04 4000 [Note] InnoDB: Completed initialization of buffer pool


2015-12-03 12:41:04 4000 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!


2015-12-03 12:41:04 4000 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB


2015-12-03 12:41:04 4000 [Note] InnoDB: Database physically writes the file full: wait...


2015-12-03 12:41:04 4000 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB


2015-12-03 12:41:06 4000 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB


2015-12-03 12:41:08 4000 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0


2015-12-03 12:41:08 4000 [Warning] InnoDB: New log files created, LSN=45781


2015-12-03 12:41:08 4000 [Note] InnoDB: Doublewrite buffer not found: creating new


2015-12-03 12:41:09 4000 [Note] InnoDB: Doublewrite buffer created


2015-12-03 12:41:09 4000 [Note] InnoDB: 128 rollback segment(s) are active.


2015-12-03 12:41:09 4000 [Warning] InnoDB: Creating foreign key constraint system tables.


2015-12-03 12:41:09 4000 [Note] InnoDB: Foreign key constraint system tables created


2015-12-03 12:41:09 4000 [Note] InnoDB: Creating tablespace and datafile system tables.


2015-12-03 12:41:09 4000 [Note] InnoDB: Tablespace and datafile system tables created.


2015-12-03 12:41:09 4000 [Note] InnoDB: Waiting for purge to start


2015-12-03 12:41:09 4000 [Note] InnoDB:? Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 0


2015-12-03 12:41:09 4000 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.


2015-12-03 12:41:09 4000 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.


2015-12-03 12:41:41 4000 [Note] Binlog end