We just upgraded from percona 5.6.28 to 5.6.34. When I started mysql up as root, it printed these messages:
Starting MySQL (Percona XtraDB Cluster)./usr/bin/mysqld_safe: line 931: test: ON: integer expression expected
/usr/bin/mysqld_safe: line 956: test: ON: integer expression expected
… SUCCESS!
These messages were not printed in the error log.
Since it looked like it was complaining about my.cnf variables defined as ‘ON’, I tested this by changing
flush_caches = ON
to
flush_caches = 1
On the restart, these messages were not printed.
It is not clear what the definitions should be in my.cnf. The 5.5 documentation says use values 0/1, but then 5.6 docs clearly say use ON/OFF.
But clearly flush_caches=1 is wanted for 5.6.34.
I am inclined to set these in my.cnf:
flush_caches = 1
numa_interleave = 1
innodb_buffer_pool_populate = 1
I can confirm that numa_… and innodb_… are set correctly, but do not find flush_caches in show [global] variables?
Does anyone have advice here?