Best my.cnf configuration

memomohannad

• January 22, 2014 17:16

Hi I need the best optimization/configuration for "my.cnf" - MySQL 5.5 - CENTOS 6.5 x86_64 standard Currently for my.cnf I have the following: #open_files_limit=4006[mysqld] #innodb_file_per_table=1 #max_connections=150 #interactive_timeout=30 #wait_timeout=30 #query_cache_size=128M #query_cache_limit = 4M #tmp_table_size=512M #max_heap_table_size=512M #key_buffer=256M #key_buffer_size=2048M #long_query_time=5 #join_buffer_size=2M #thread_cache_size=16k #low_priority_updates=1 #concurrent_insert=ALWAYS #table_cache = 1K #table_definition_cache = 4K #open_files_limit = 3K
Processor Information Total processors: 8 Processor #1 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 1200.000 MHz Cache 8192 KB Processor #2 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 2534.000 MHz Cache 8192 KB Processor #3 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 2534.000 MHz Cache 8192 KB Processor #4 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 1200.000 MHz Cache 8192 KB Processor #5 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 1200.000 MHz Cache 8192 KB Processor #6 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 1200.000 MHz Cache 8192 KB Processor #7 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 1200.000 MHz Cache 8192 KB Processor #8 Vendor GenuineIntel Name Intel(R) Xeon(R) CPU X3440 @ 2.53GHz Speed 2534.000 MHz Cache 8192 KB
Memory Information Memory: 8032544k/9437184k available (5223k kernel code, 1057676k absent, 346964k reserved, 7119k data, 1264k init)
thank you a lot for your help Mohannad

• 

  cPanelMichael

  • January 23, 2014 12:06

  Re: i need a help please Hello :) Please review the following thread in order to provide us with enough information to make recommendations: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  memomohannad

  • January 23, 2014 20:59

  Re: i need a help please Thank you.

  0

Please sign in to leave a comment.