If we are running drupal (or Java) + Mysql on a production linux machine, what is the recommended MySQL configuration to get the most optimal performance? We are running on MySQL 5 and innodb as db type.
Currently, we set innodb_open_files 300 open_files_limit 65535 Thanks dev
