I run a website called TMDb ( http://www.themoviedb.org/ ) and as the db is growing, I am finding there to be a lot of slow queries. Even simple things like a simple search across a table of 300 records will take 5 seconds…
The db is about 2 GB in size.
The box this DB is on is a dual quad core w/ 4GB of RAM, 2GB could easily be allocated to MySQL… everything is indexed, and there isn’t much data that changes (so the indexes don’t generally need to be re-written that often) I really don’t understand what I can do here. Any and all help would be great.
My my.cnf file looks like the following:
I am running MySQL 5.1.
Thanks for any help you guys can provide!