Mysql Optimized configuration (centos 5.2-5.5, openSUSE11.0-11.3)

==========[my.cnf]==========

 

 

 

[client]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

 

[mysqld]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

skip-locking

skip-innodb

skip-bdb

key_buffer = 64k

max_allowed_packet = 1M

table_cache = 6

sort_buffer_size = 128K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 256k

 

skip-federated

server-id       = 1

 

[safe_mysqld]

log-error=/var/lib/mysql/mysqld.log

 

[mysqldump]

quick

max_allowed_packet = 16M

 

[mysql]

no-auto-rehash

 

[isamchk]

key_buffer = 8M

sort_buffer_size = 8M

read_buffer = 2M

write_buffer = 2M

 

[myisamchk]

key_buffer = 8M

sort_buffer_size = 8M

read_buffer = 2M

write_buffer = 2M

 

[mysqlhotcopy]

interactive-timeout

 

[mysqld_multi]

mysqld     = /usr/bin/mysqld_safe

mysqladmin = /usr/bin/mysqladmin

log        = /var/log/mysqld_multi.log

 

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

HowTo: Setup Lighttpd & MySQL 5 & PHP 5

  Light HTTP with MySQL 5 and PHP 5 (LLMP) OS: CentOS(5.2 - 5.5) by eServices GreeceAuthor:...

Rapid SSL CA Bundle

You will find the bundle here: http://www.geotrust.com/resources/root-certificates/

Set Correct Time and Timezone

For Dedicated servers & VMWare just set the time using date -s "17 JUN 2010 19:54:00"...

Lighttpd Optimized configuration (centos 5.2-5.5, openSUSE11.0-11.3)

==========[lighttpd.conf]==========       # lighttpd configuration file # #...

Python Script to Create XEN MAC's

  #! /usr/bin/python # createmacs.py (c) 2010 George Pantazis -...