I am using Percona Server 5.6 with Magento CE 1.8. I originally used the percona tool to generate the my.cnf file that I am currently using. It's been in play for 3-4 weeks now, and I haven't noticed any issues because of these settings as far as I can tell. However, today, I was trying to consolidate a barely used database server which just held the data for a single wordpress install. Suddenly, things that were working fine, were not working at all, and I was racking my brain until I finally realized that the set "sql_mode" values in the my.cnf were to blame. Frankly, I don't know a ton about this setting, though I am quickly learning. For a quick workaround, I have disabled all sql modes for the wordpress sessions, but it got me thinking - which of these modes, if any, do I need for Magento? I don't want to disable it all and cause issues if I need some of these, nor do I want to leave any in play if they in fact are causing problems.
Can someone more informed than I tell me which I need to keep and which I should get rid of? I am more looking for which ones are detrimental or necessary to the daily operation of magento. If one happens to be, say, user preference, please note as such. Unfortunately I have not been able to find much information about these options and Magento specifically with my Google-Fu. I can take the time to research these if you don't feel like writing out an explanation, so don't feel obligated to explain every little detail.
[mysqld] ... sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY ... innodb-strict-mode = 1