Administrace komentářů

Zdravím,

na 2 malé weby (každý po 10mb databázi) s cca 1k uip dohromady jsem si pořídil virtuál se 4gb od wedosu. Tzn. silně naddimenzováno.

Reálně je využito dle top 1gb, další 3gb jsou free, 3 vlákna procesoru se nudí k smrti

Vzhledem k úmyslnému přebytku paměti ram, mám vytvořený tmpfs ramdisk, kde jsou naházeny sessions a mysql tmp dir (samozřejmě php-apc.stat, memcached) je taky v provozu, innodb vyřazeno, jede to na myisam vše.

Ale stejně se mi nelíbí, že se občas stránka loaduje 0,3s. Prosím, můžete mrknout, jestli vám tam nepřijde něco co by se dalo ještě vylepšit? Vím že tam mám nějakou vyšší rezervu pro cache a indexy, ale to nevadí, vzhledem k velkému přebytku ram.

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


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

[mysqld]
#
# * Basic Settings
#
log_slow_queries = ON
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 4
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /mnt/tmpfs/mysql
language	= /usr/share/mysql/english
skip-external-locking
skip-locking
skip-innodb
skip-federated
ft_min_word_len = 2
#
# Instead of skip-networking the default is now to listen only on  
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 192M
key_buffer_size		= 192M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 100
table_cache            = 1k
#table_open_cache = 600
#thread_concurrency     = 10
thread_concurrency = 6
#
# * Query Cache Configuration
#
query_cache_limit	= 16M
query_cache_size        = 128M
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Něco z tuneru (jede to chvilku, takže ty read/write ještě trochu zefektivní):

[OK] Maximum possible memory usage: 604.7M (15% of installed RAM)
[OK] Slow queries: 0% (0/3K)
[OK] Highest usage of available connections: 2% (2/100)
[OK] Key buffer size / total MyISAM indexes: 192.0M/8.6M
[!!] Key buffer hit rate: 65.9% (21K cached / 7K reads)
[OK] Query cache efficiency: 43.9% (1K cached / 2K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 150 sorts)
[OK] Temporary tables created on disk: 19% (142 on disk / 739 total)
[OK] Thread cache hit rate: 99% (2 created / 372 connections)
[OK] Table cache hit rate: 20% (88 open / 432 opened)
[OK] Open file limit used: 7% (152/2K)
[OK] Table locks acquired immediately: 100% (1K immediate / 1K locks)

Díky moc!