Hi,
We recently upgraded from MySQL 5.1 to Percona 5.6 and have had lots of problems and performance issues. Has anyone else noticed such problems?
Problems include:
MySQL server has gone away at random times
100% CPU for hours when a query uses block_nested_loop optimization (we now switch this off)
More deadlocks than we ever had with 5.1
More slow queries than we ever had with 5.1
I monitor the database using MONyog and didn’t get anywhere near as many emails as I do now when we were using 5.1
We had to migrate because we wanted to use the aes_encrypt and decrypt commands but I’m seriously regretting doing so now.