I've been using MySQLTuner to optimize my database, and the only problem I am having is:
[!!] Maximum possible memory usage: 14.8G (126% of installed RAM)
I'm not sure what I should be changing to get this down under my 12G of RAM. I have a database with 110 tables, 10,000,000 rows (growing fairly quickly), and an average of 250 users online. My my.cnf has looks like:
query_cache_limit=1M
query_cache_size=128M
query_cache_type=1
max_user_connections=2000
max_connections=2000
interactive_timeout=100
wait_timeout=100
connect_timeout=100
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=15360
record_buffer=1M
sort_buffer_size=4M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1