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
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?
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