MattW
Well-known member
Just seen that Percona 5.6 is now on their stable branch, and available via their yum repo.
So, just spent the last 20 minutes upgrading.
Had a bit of a scare when it wouldn't start back up again, but per their instruction, you need to start it with skip-grant-tables to run the initial mysql_upgrade. This didn't stop when I killed it and tried to restart it properly, and it couldn't get a lock on the ibdate1 file
kill -9 on the previous process stopped it, and I eventually got it started again.
I had to remove some settings from my.cnf to get it back up again:
Other than that, it's back up and running on 5.6
Initial impressions are that it's definitely quicker.
For example, posting a thread in my announcement section where a lot of people are watching with notifications used to take ~4 seconds to post the thread. It's now doing it < 1 second!
So, just spent the last 20 minutes upgrading.
Had a bit of a scare when it wouldn't start back up again, but per their instruction, you need to start it with skip-grant-tables to run the initial mysql_upgrade. This didn't stop when I killed it and tried to restart it properly, and it couldn't get a lock on the ibdate1 file
Code:
2013-10-12 05:34:09 10933 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2013-10-12 05:34:09 10933 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2013-10-12 05:34:10 10933 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2013-10-12 05:34:10 10933 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2013-10-12 05:34:10 10933 [Note] InnoDB: Unable to open the first data file
kill -9 on the previous process stopped it, and I eventually got it started again.
I had to remove some settings from my.cnf to get it back up again:
Code:
2013-10-12 05:25:20 8279 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_flush_neighbor_pages=0'
2013-10-12 05:25:56 8331 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_ibuf_max_size=4M'
2013-10-12 05:26:47 8418 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_adaptive_flushing_method=keep_average'
Other than that, it's back up and running on 5.6
Initial impressions are that it's definitely quicker.
For example, posting a thread in my announcement section where a lot of people are watching with notifications used to take ~4 seconds to post the thread. It's now doing it < 1 second!