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?
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.