Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql old_passwords=1 skip-name-resolve key_buffer_size = 1280M #was 256M max_allowed_packet = 2M #was 64M table_cache = 2048 #was 1000 sort_buffer_size = 3M read_buffer_size = 3M read_rnd_buffer_size = 3M myisam_sort_buffer_size = 3M thread_cache_size = 250 wait_timeout=45 #was 60 join_buffer_size=4M #was 3mb query_cache_size=256M query_cache_limit=4M concurrent_insert = 4 interactive_timeout = 3600 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 16 # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 low_priority_updates=1 character_set_server=utf8 collation_server=utf8_general_ci max_connections=500 long_query_time=5 log-slow-queries=/var/lib/mysql/slow-queries_0209.log #log-queries-not-using-indexes max_heap_table_size = 512M tmp_table_size = 512M skip-innodb skip-bdb [mysql] no-auto-rehash [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!