Вход:  Пароль:  
FreeSource: MichaelShigorin/MySQL ...
Free Source | Каталог | Изменения | НовыеКомментарии | Пользователи | Регистрация |

MySQL for TYPO3 hosting

4 cores, 640+M RAM leased for this VPS


See also: mysql query cache performance optimization
http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html
http://www.mysqlperformanceblog.com/2006/07/27/mysql-query-cache/
mysqltuner
mytop


part of my.cnf follows:


# The MySQL server
[mysqld]
init-connect="set names koi8u"
chroot=/var/lib/mysql
datadir=/db
bdb-logdir=/log
#log=/log/queries
pid-file=/mysqld.pid
skip-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql
#port = 3306
skip-bdb
low-priority-updates


#wait_timeout = 30


thread_cache = 16
thread_concurrency = 6
#thread_stack = 512K


table_cache = 1024
#myisam_max_sort_file_size = 1G
#myisam_max_extra_sort_file_size = 1G
myisam_sort_buffer_size = 256M
sort_buffer_size = 64M
join_buffer_size = 64M
#key_buffer_size = 128M
read_buffer_size = 2M
#read_rnd_buffer_size = 64M
key_buffer = 512M
record_buffer = 32M


# http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html
#query_cache_type = 1
#query_cache_size = 32M
#query_cache_limit = 1M
#query_cache_min_res_unit=128
# http://typo3.org/development/articles/testing-and-tuning-typo3-performance/page/2/
query_cache_limit = 2M # default was 1M
query_cache_size = 64M # default was 0
query_cache_type = 1
key_buffer_size = 64M # default was 8M


max_allowed_packet = 1M
#max-connections = 50
#max_heap_table_size = 128M
#tmp_table_size = 128M


# http://web-scalability.solartxit.com/2008/05/30/mysql-%d1%82%d1%8e%d0%bd%d0%b8%d0%bd%d0%b3-%d0%bd%d0%b0%d1%81%d1%82%d1%80%d0%b0%d0%b8%d0%b2%d0%b0%d0%b5%d0%bc-%d0%bf%d0%be-%d0%b2%d0%b7%d1%80%d0%be%d1%81%d0%bb%d0%be%d0%bc%d1%83/
max_join_size=10000000
max_sort_length=20
wait_timeout=60


log-slow-queries=/log/slow-queries
long_query_time = 2
log_long_format
#log_warnings


ft_min_word_len = 4


#back_log = 50
#max_connections = 50


myisam_recover


# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 – 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50


[mysqld_safe]
open-files-limit = 4096


[mysqldump]
quick
quote-names
max_allowed_packet = 16M


[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
# Remove the next comment character if you are not familiar with SQL
#safe-updates


[isamchk]
key_buffer = 512M
key_buffer_size = 128M
sort_buffer_size = 512M
write_buffer = 4M
read_buffer = 4M


[myisamchk]
key_buffer = 512M
key_buffer_size = 128M
sort_buffer_size = 512M
read_buffer = 4M
write_buffer = 4M


[mysqlhotcopy]
interactive-timeout


 
Файлы [Скрыть файлы/форму]
Комментариев нет. [Показать комментарии/форму]