Need Help Improving Speed on Large MySQL Database
Posted on 2012-09-05
I have a large MySQL database (about 6GB). I'm running on a cloud server that stores the MySQL data on a SAN. I have a VB.NET Windows application that processes large files (50MB-100MB) into the DB (inserts and updates). I am running at 80% of RAM (total RAM is 2GB), so I am not paging.
My performance is somewhat slow, and I was wondering whether I am using the best InnoDB parameters. Here's what I'm using:
Should any of these values be altered?
Thanks, Stu Engelman