Middle/Orta seviviye ve yüksek (4GB,8GB…) sunucular için - LAYERWEB

my.cnf

[client]
port                            = 3306
socket                          = /var/lib/mysql/mysql.sock

[mysqld-safe]
socket                          = /var/lib/mysql/mysql.sock
nice                            = 0

[mysqld]
# Basic
innodb_force_recovery = 1
bind-address                    = 127.0.0.1 # Comment out if you want remote servers to connect to this server's MySQL instance
datadir                         = /var/lib/mysql
lc-messages-dir                 = /usr/share/mysql
max-allowed-packet              = 128M
max-connect-errors              = 1000000
pid-file                        = /var/lib/mysql/mysql.pid
port                            = 3306
skip-external-locking
skip-name-resolve
socket                          = /var/lib/mysql/mysql.sock
tmpdir                          = /dev/shm/mysql/
user                            = mysql


# MyISAM Query Cache Settings
query-cache-limit               = 1M    # UPD
query-cache-size                = 70M   # UPD
query-cache-type                = 1

key-buffer-size                 = 150M   # UPD

low-priority-updates            = 1
concurrent-insert               = 2

# Common
max-connections                 = 100   # UPD
back-log                        = 512

wait-timeout                    = 90
interactive-timeout             = 90

join-buffer-size                = 2M    # UPD
read-buffer-size                = 2M    # UPD
read-rnd-buffer-size            = 4M    # UPD
sort-buffer-size                = 4M    # UPD

thread-cache-size               = 16   # UPD (most of the times you probably won't need to change this)
thread-stack                    = 192K

max-heap-table-size             = 50M
tmp-table-size                  = 50M

table-definition-cache          = 8000  # UPD
table-open-cache                = 1000  # UPD
open-files-limit                = 24000 # UPD

ft-min-word-len                 = 3     # Minimum length of words to be indexed for search results

expire-logs-days                = 2
log-error                       = /var/lib/mysql/mysql_error.log
log-queries-not-using-indexes   = 1
long-query-time                 = 0.1
max-binlog-size                 = 100M
slow-query-log                  = 1
slow-query-log-file             = /var/lib/mysql/mysql_slow.log

thread-cache-size               = 16   # UPD (most of the times you probably won't need to change this)
thread-stack                    = 192K

max-heap-table-size             = 50M
tmp-table-size                  = 50M

table-definition-cache          = 8000  # UPD
table-open-cache                = 1000  # UPD
open-files-limit                = 24000 # UPD

ft-min-word-len                 = 3     # Minimum length of words to be indexed for search results

expire-logs-days                = 2
log-error                       = /var/lib/mysql/mysql_error.log
log-queries-not-using-indexes   = 1
long-query-time                 = 0.1
max-binlog-size                 = 100M
slow-query-log                  = 1
slow-query-log-file             = /var/lib/mysql/mysql_slow.log

max_allowed_packet=32M
open_files_limit=50000
[mysqldump]
quick
quote-names
max-allowed-packet              = 16M

[mysql]

[isamchk]
key-buffer-size                 = 150M