-------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Enable the slow query log to troubleshoot bad queries somebody knows how to do it?
but even when i don't have anything on /etc/my.cnf i keep getting this message 2 quad cores + 10GB [mysqld] #local-infile=0 #external-locking memlock myisam_recover skip-name-resolve max_connect_errors = 1000000 max_connections = 10000 innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 4G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 key_buffer = 32M read_buffer_size = 2M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M table_open_cache = 2048 sort_buffer_size = 8M join_buffer_size = 8M thread_concurrency = 32 thread_stack = 1M transaction_isolation = REPEATABLE-READ myisam_sort_buffer_size = 64M table_cache = 5000 thread_cache_size = 700 wait_timeout = 10 connect_timeout = 10 interactive_timeout=10 max_heap_table_size = 64M max_allowed_packet = 64M query_cache_limit = 4M query_cache_size =128M query_cache_type = 1 #log #log_warnings [mysqld_safe] # Increase the amount of open files allowed per process. Warning: Make # sure you have set the global system limit high enough! The high value # is required for a large number of opened tables open-files-limit = 8192
