I have one dedicated MySQL database server with 4GB RAM only serving one database and table engine is INNODB.
According to stats we are getting only INSERT,UPDATE,DELETE queries on this server with no SELECT queries. Also this database server receiving around 150 queries per second (as i applied trigger which records data in another database on same server). Mostly server hungs with “Too many connections” error and max_connections limit is 200.
innodb_buffer_pool_size is set to default 256MB. Can someone please let me know which parameters i need to look in to speedup data modification queries.
I guess innodb_buffer_pool is cache which used for SELECTs only. Let me know increasing innodb_buffer_pool_size speedup INSERT queries on not and which are other parameters i need to look in. Please help me out to tune this server.