Блог WordPress

Конфигурации MySQL

my.cnf настраиваем правильно

[client]
port            		= 3306
socket          		= /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          		= /var/run/mysqld/mysqld.sock
nice           	 		= 0

[mysqld]
user            		= mysql
pid-file        		= /var/run/mysqld/mysqld.pid
socket          		= /var/run/mysqld/mysqld.sock
port            		= 3306
basedir         		= /usr
datadir         		= /var/lib/mysql
tmpdir          		= /tmp
language        		= /usr/share/mysql/english
old_passwords   		= 0
bind-address            	= 127.0.0.1

skip-external-locking

max_allowed_packet      	= 16M
key_buffer              	= 16M

innodb_buffer_pool_size

 	= 512M

innodb_file_per_table

   	= 1

innodb_flush_method

     	= O_DIRECT

innodb_flush_log_at_trx_commit

  = 0

thread_stack            	= 128K

thread_cache_size

       	= 128
myisam-recover          	= BACKUP
max_connections         	= 128
table_cache             	= 32

query_cache_limit       	= 1M

query_cache_size

    		= 4M

slow_query_log

        		= /var/log/mysql/mysql-slow.log
long_query_time         	= 1

expire_logs_days        	= 10

max_binlog_size

     		= 100M

[mysqldump]
quick
quote-names
max_allowed_packet      	= 16M

Похожие статьи

Добавить комментарий

Кнопка «Наверх»