1
Od czasu do czasu VPS dostaje zmułki i podejrzewam, że jest to wina mysql'a.
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 skip-external-locking set-variable = max_connections=30 max_user_connections=24 safe-show-database #skip-locking #skip-innodb skip-external-locking key_buffer = 16M sort_buffer_size = 64M record_buffer = 32M table_cache = 2000 thread_cache_size = 256 tmp_table_size = 128M #128M read_rnd_buffer_size = 768K read_buffer_size = 8M max_allowed_packet = 16M query_cache_limit = 8M query_cache_size = 35M query_cache_type = 1 thread_concurrency = 4 default-character-set = utf8 join_buffer_size = 256K max_heap_table_size = 50M log-slow-queries = /var/log/mysql-slow-queries.log long_query_time = 5 open_files_limit = 2000 !includedir /etc/mysql/conf.d/
MySQL tunner:
>> MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.51a-24+lenny4-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1M (Tables: 287)
[--] Data in InnoDB tables: 320K (Tables: 20)
[OK] Total fragmented tables: 0
-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 5h 46m 17s (96K q [0.499 qps], 8K conn, TX: 80M, RX: 15M)
[--] Reads / Writes: 14% / 86%
[--] Total buffers: 111.0M global + 73.2M per thread (30 max threads)
[!!] Maximum possible memory usage: 2.3G (112% of installed RAM)
[OK] Slow queries: 0% (25/96K)
[OK] Highest usage of available connections: 20% (6/30)
[OK] Key buffer size / total MyISAM indexes: 16.0M/555.0K
[OK] Key buffer hit rate: 96.3% (57K cached / 2K reads)
[OK] Query cache efficiency: 49.6% (6K cached / 13K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 684 sorts)
[OK] Temporary tables created on disk: 4% (822 on disk / 18K total)
[OK] Thread cache hit rate: 99% (6 created / 8K connections)
[!!] Table cache hit rate: 0% (20 open / 5K opened)
[OK] Open file limit used: 0% (0/5K)
[OK] Table locks acquired immediately: 99% (12K immediate / 12K locks)
[OK] InnoDB data size / buffer pool: 320.0K/8.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Reduce your overall MySQL memory footprint for system stability
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
table_cache (> 2000)
MySQL działa ponad 24godziny.
Parametry VPS'a:
Procek: 1,7
RAM 1GB (gwar)/2GB (burst)
