Comment 5 for bug 1329772

Jericho Rivera (jericho-rivera) wrote :

Tested with Oracle MySQL, with the following procedures and can't repeat with either:

1st procedure:

- Installed 5.6.16 binaries
- Enabled P_S on my.cnf
- yum remove 5.6.16, then install 5.6.17 binaries
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.6.17, for Linux (x86_64) using EditLine wrapper

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.17 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 min 9 sec

Threads: 1 Questions: 6 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.086
--------------

mysql> show global variables like 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
1 row in set (0.00 sec)

mysql> select * from performance_schema.accounts limit 1
    -> ;
+------+-----------+---------------------+-------------------+
| USER | HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+------+-----------+---------------------+-------------------+
| root | localhost | 1 | 1 |
+------+-----------+---------------------+-------------------+
1 row in set (0.00 sec)

mysql> exit

Works! And encountered no errors on log file.

- yum update to latest 5.6.19, and nothing 'breaks'

2nd procedure
- Installed 5.6.16 binaries
- Enabled P_S on my.cnf
- Ran yum update to install 5.6.19

P_S does not break either. No errors on error log as well.

mysql> \s
--------------
mysql Ver 14.14 Distrib 5.6.19, for Linux (x86_64) using EditLine wrapper

Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.19 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 17 sec

Threads: 1 Questions: 5 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.294
--------------

mysql> show global variables like 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
1 row in set (0.00 sec)

mysql> select * from performance_schema.accounts limit 1;
+------+-----------+---------------------+-------------------+
| USER | HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+------+-----------+---------------------+-------------------+
| root | localhost | 1 | 1 |
+------+-----------+---------------------+-------------------+
1 row in set (0.00 sec)

mysql> exit
Bye
bash-4.1# grep ERROR /var/lib/mysql/5164bba0dca8.err
bash-4.1#