Posted by threemints, 03-30-2010, 01:58 PM | Hello,
I ordered this server
Intel Xeon E5520 Nehalem 2.26GHz 4x256KB L2 Cch / 8MB L3 Cch Quad-Core
1TB First hard
250GB Second hard
6TB bandwidth
12GB RAM
WHM/Cpanel
but i don't know what is the best my.cnf will be for the server, i'm running vbulletin for my sites.
|
Posted by Sileep Kumar M S, 03-31-2010, 01:59 AM | Better contact your system admin to check your server and then optimize my.cnf.
Here is a sample my.cnf
|
Posted by vapetrov, 03-31-2010, 02:28 AM | The example above is just example. Do not copy/paste it. Think a lot before did.
I suggest you leave my.cnf as is by default. Default options is smart enough.
Than use mysqltuner.pl script (download it from http://mysqltuner.pl/) to optimize my.cnf parameters.
|
Posted by ksv2nash, 03-31-2010, 09:14 AM | Hello,
You can yse this for Mysql Hardening
/etc/my.cnf
delete all lines in it and then paste following
------------------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10# Try number of CPU's*2 for thread_concurrencythread_concurrency=8
myisam_sort_buffer_size=64M
#log-binserver-id=1
old-passwords = 1
[mysql.server]
user=mysqlbasedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quickmax_allowed_packet=16M
Remaining........
|
Posted by assistanz247, 03-31-2010, 09:24 AM | Oops I cannot see the most important lines which are needed for the MySQL security is missing here,
skip-networking
set-variable=local-infile=0
local-infile=0
Better add these lines to protect the MySQL from attacks.
|
Posted by VIPoint, 03-31-2010, 10:39 AM | Please beware of mysql scripts that are not customized for your server. The my.cnf should contain parameters that has been customized as per your server configuration. It is NOT necessary that the script which is working for a user will work for your server too.
I will recommend to you to hire a sysadmin or contact your hosting support to get a customized my.cnf exclusively for your server. Using just any or sample my.cnf might result in bad performance of your server.
|
Posted by threemints, 03-31-2010, 11:26 AM | Thank you all for your advices
|
Posted by boxer, 03-31-2010, 07:28 PM | sorry for dig the topic, but if we put this file is that okay?
|
Posted by ksv2nash, 04-01-2010, 04:31 AM | Hello,
You can try with this.
|
Posted by bvsonline, 04-30-2010, 12:49 AM | You may please go through this URL:- http://drupal.org/node/85768
|
|
Add to Favourites
Print this Article |