Hello,
My mysql server is eating 130% of my CPU. My site is a high traffic youtube like video site. It has over 1000 videos with over 5 million video video views. Recently my site got very slow cause of the CPU overload. Server is a high end dedicated. Can someone take a look at my variables and help out.
Server Specs:
core2Quad with 1 CPU and 4 cores, 1000GB hard drive, 8GB RAM
My.cnf Config:
#set-variable = innodb_buffer_pool_size=10M
#set-variable = innodb_additional_mem_pool_size=500K
#set-variable = innodb_log_buffer_size=500K
#set-variable = innodb_thread_concurrency=2
#set-variable = interactive_timeout=60
#set-variable = max_connections=1000
#set-variable = max_user_connections=1000
#set-variable = key_buffer=140M
#set-variable = join_buffer_size=4M
#set-variable = read_buffer_size=1M
#set-variable = sort_buffer_size=8M
#set-variable = table_cache=1800
#set-variable = thread_cache_size=64
#set-variable = wait_timeout=120
#set-variable = connect_timeout=60
#set-variable = tmp_table_size=300M
#set-variable = max_heap_table_size=64M
#set-variable = max_allowed_packet=200M
#set-variable = max_connect_errors=10
#set-variable = thread_concurrency=2
#set-variable = read_rnd_buffer_size=300M
#set-variable = myisam_sort_buffer_size=64M
#set-variable = bulk_insert_buffer_size=8M
#set-variable = query_cache_limit=1M
#set-variable = query_cache_size=32M
#set-variable = query_cache_type=1