Hey guys,
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:
[mysqld]
max_allowed_packet=32M
character-set-server=utf8
query_cache_size=32M
table_cache=1024
key_buffer=256M
thread_cache=128
thread_concurrency=12
read_buffer_size=1M
long_query_time=5
log-slow-queries=/var/log/mysql-slow.log
I am running MySQL 5.1.
Thanks for any help you guys can provide!