I'm running 16 GB of RAM with dual 3.0 Ghz processors with Ubuntu Server
My PHPMyAdmin is showing: Opened_tables 2,573 - The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
I just restarted MySQL about 4 minutes ago and adjusted table_cache
from default
to 256
, it's not a heavy load time. My databases combined are all under 250 MB at the moment. Is it possible that this number PHpMyAdmin is showing is old and I just need to wait to get it updated?
Current configuration:
key_buffer = 1024M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections = 1500
table_cache = 256
thread_concurrency = 4
#
# * Query Cache Configuration
#
query_cache_limit = 10M
query_cache_size = 512M
query_cache_type = 1
#
# * Custom Configuration
#
tmp_table_size = 512M
max_heap_table_size = 128M
join_buffer_size = 512M
myisam_sort_buffer_size = 512M