0
votes
2answers
97 views

Server configurations for hosting MySQL database

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 ...
0
votes
0answers
538 views

Cannot enlarge MySQL Innodb_Buffer_Size, causes MySQL to crash

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 ...
3
votes
3answers
2k views

Database I/O acceleration using solid state drives

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?