Percona 5.6

[Moshe1010]

I've had to roll back to Percona 5.5 this evening.

Tried to restart apache, and it wouldn't restart.

httpd: Syntax error on line 40 of /usr/local/apache/conf/httpd.conf: Syntax error on line 9 of /usr/local/apache/conf/php.conf: Cannot load /usr/local/apache/modules/libphp5.so into server: /usr/local/apache/modules/libphp5.so: symbol client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference

MySQL 5.6 ISN'T compatible with Cpanel yet!!!!

It's quite funny that cPanel doesn't support 5.6 since 5.7 final is around the corner. cPanel is a year and half behind in terms of MySQL, which is quite disturbing.

 

[MattW]

No ETA either on 5.6 support

http://features.cpanel.net/responses/mysql-56-support-eta

 

[MattW]

Had some errors after the rollback

131014  5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/general_log.frm'
131014  5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/innodb_index_stats.frm'
131014  5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/innodb_table_stats.frm'
131014  5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/procs_priv.frm'
131014  5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/slow_log.frm'

Tried to repair the tables, but they came back corrupt.

This is basically because the table information was updated when the server was updated to 5.6

In order to get around this, I've copied the .frm files from the backup VPS, which is running the same version of MySQL, and copied these over the corrupt versions.

 1147  cp slow_log.frm /root/downloads/
1148  cp /home/z22se/slow_log.frm /var/lib/mysql/mysql/
1149  ls -al
1150  ps -ef | grep mysql
1151  cp general_log.frm procs_priv.frm /root/downloads/
1152  cp /home/z22se/general_log.frm /var/lib/mysql/mysql/
1153  cp /home/z22se/procs_priv.frm /var/lib/mysql/mysql/
1154  /etc/init.d/mysql start
1155  ls
1156  ls -al
1157  /etc/init.d/mysql stop
1158  cp innodb_* /root/downloads/
1159  rm innodb_*

These are the backed up corrupt files (/root/downloads/)

-rw-------  1 root    root    8.6K Oct 14 06:01 general_log.frm
-rw-------  1 root    root    13K Oct 14 06:04 innodb_index_stats.frm
-rw-------  1 root    root    10M Oct 14 06:04 innodb_index_stats.ibd
-rw-------  1 root    root    8.7K Oct 14 06:04 innodb_table_stats.frm
-rw-------  1 root    root    224K Oct 14 06:04 innodb_table_stats.ibd
-rw-------  1 root    root    8.7K Oct 14 06:01 procs_priv.frm
-rw-------  1 root    root      35 Oct 14 05:41 slow_log.CSM
-rw-------  1 root    root      0 Oct 14 05:41 slow_log.CSV
-rw-------  1 root    root    8.9K Oct 14 05:58 slow_log.frm

Still getting these errors, which I think are from tables that aren't needed, but will look into that later on

131014  6:04:40  InnoDB: Warning: table 'mysql/slave_master_info'
InnoDB: in InnoDB data dictionary has unknown flags 10.
131014  6:04:40  InnoDB: Warning: table 'mysql/slave_relay_log_info'
InnoDB: in InnoDB data dictionary has unknown flags 10.
131014  6:04:40  InnoDB: Warning: table 'mysql/slave_worker_info'
InnoDB: in InnoDB data dictionary has unknown flags 10.

 

[x3sphere]

Upgraded last night, didn't have any issues apart from some old config params in the my.cnf I had to remove.

 

[Mouth]

Anyone yet done a 5.6.15 upgrade to 5.6.16 with the new libperconaserverclient18.1 ??

I'm using automysqlbackup package, and finding that it's wanting to uninstall this very important tool. So not wanting to upgrade to 5.6.16 until I find out why and how to keep automysqlbackup.

 

[Slavik]

Anyone yet done a 5.6.15 upgrade to 5.6.16 with the new libperconaserverclient18.1 ??

I'm using automysqlbackup package, and finding that it's wanting to uninstall this very important tool. So not wanting to upgrade to 5.6.16 until I find out why and how to keep automysqlbackup.

use rpm -e --nodeps to remove percona, then install the new one you might need to symlink the old lib client or just manually install mysql56-shared

 

[Floren]

From many benchmarks that I've seen, 5.5 was much faster than 5.6
Have you tried to run benchmarks? I know they don't tell a lot and it really depends what system we are running, but if you say there are noticeable differences in xenForo, then I guess this what matters the most.

Percona 5.6 is much faster than MySQL 5.5/6 and MariaDB 5.5, but not faster than MariaDB 10. For example, Percona 5.6 uses a thread pool feature similar to the one available into enterprise version of MySQL.

 

[Moshe1010]

Percona 5.6 is much faster than MySQL 5.5/6 and MariaDB 5.5, but not faster than MariaDB 10. For example, Percona 5.6 uses a thread pool feature similar to the one available into enterprise version of MySQL.

I was comparing b/w Percona 5.5 vs 5.6

 

[Slavik]

Percona 5.6 is much faster than MySQL 5.5/6 and MariaDB 5.5, but not faster than MariaDB 10. For example, Percona 5.6 uses a thread pool feature similar to the one available into enterprise version of MySQL.

Any benchies ?

 

[Floren]

MySQL 5.6 ISN'T compatible with Cpanel yet!!!!

Time to get rid of this creepy product (CPanel)?

Any benchies ?

Google should provide it, I have none on hand but I know MariaDB will always have the edge.

 

[MattW]

Time to get rid of this creepy product (CPanel)?

Google should provide it, I have none on hand but I know MariaDB will always have the edge.

Got rid of it back in October