I am working with a MySQL database that is mainly used to do inserts and almost never selects. Unfortunately, the system is already deployed and working, 24x7 roughly 14k inserts/day, and I cannot make many inserts in my test environment as it is very limited.
All the MySQL optimizations I read focus mainly in fast, cacheable selects, but this is no point in my system.
Is there any good guide to improve performance in such a system? Or a more focused question: do the vars *innodb_flush_method*, *innodb_buffer_pool_size* and *key_buffer_size* have any effect in such a system?