I have a web application which uses a MySQL database hosted on a virtual server. I've been using this server when I started the application and when the database was really small. Now it has grown and ...
I currently have innodb_buffer_size set to 2GB - yet I have well over 5GB of innodb databases, and another 4 gigs of free ram on the server (Centos 5). I tried to increase the value to 3 gig, but ...
What is the experience improving database performance using solid-state drives (particularly for PostgreSQL databases) such as HP's IO Accelerator? Did you see any marked improvements?