Сервер дома: слабый компьютер, настройка системы
- Автор темы irip
- Дата начала
irip
Гуру форума
- Регистрация
- 12 Авг 2006
- Сообщения
- 540
- Реакции
- 55
- Автор темы
- #63
Почему не будет, в личку дать могу, конечно
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 1G (Tables: 757)
[--] Data in InnoDB tables: 1M (Tables: 18)
[!!] Total fragmented tables: 50
-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 1m 50s (2M q [38.564 qps], 81K conn, TX: 13B, RX: 378M)
[--] Reads / Writes: 88% / 12%
[--] Binary logging is disabled
[--] Total buffers: 346.0M global + 2.2M per thread (100 max threads)
[OK] Maximum reached memory usage: 382.0M (20.37% of installed RAM)
[OK] Maximum possible memory usage: 571.0M (30.45% of installed RAM)
[OK] Slow queries: 0% (30/2M)
[OK] Highest usage of available connections: 16% (16/100)
[OK] Aborted connections: 0.00% (0/81599)
[OK] Query cache efficiency: 82.9% (2M cached / 2M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (6 temp sorts / 159K sorts)
[!!] Joins performed without indexes: 4074
[!!] Temporary tables created on disk: 43% (34K on disk / 78K total)
[OK] Thread cache hit rate: 99% (16 created / 81K connections)
[OK] Table cache hit rate: 75% (879 open / 1K opened)
[OK] Open file limit used: 19% (1K/8K)
[OK] Table locks acquired immediately: 99% (800K immediate / 801K locks)
-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 37.3% (25M used / 67M cache)
[OK] Key buffer size / total MyISAM indexes: 64.0M/347.2M
[OK] Read Key buffer hit rate: 100.0% (53M cached / 13K reads)
[OK] Write Key buffer hit rate: 98.5% (3M cached / 46K writes)
-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 8.0M/1.4M
[!!] InnoDB Used buffer: 25.59% (131 used/ 512 total)
[OK] InnoDB Read buffer efficiency: 100.00% (22433756 hits/ 22433851 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 387 writes)
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 1G (Tables: 757)
[--] Data in InnoDB tables: 1M (Tables: 18)
[!!] Total fragmented tables: 50
-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 1m 50s (2M q [38.564 qps], 81K conn, TX: 13B, RX: 378M)
[--] Reads / Writes: 88% / 12%
[--] Binary logging is disabled
[--] Total buffers: 346.0M global + 2.2M per thread (100 max threads)
[OK] Maximum reached memory usage: 382.0M (20.37% of installed RAM)
[OK] Maximum possible memory usage: 571.0M (30.45% of installed RAM)
[OK] Slow queries: 0% (30/2M)
[OK] Highest usage of available connections: 16% (16/100)
[OK] Aborted connections: 0.00% (0/81599)
[OK] Query cache efficiency: 82.9% (2M cached / 2M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (6 temp sorts / 159K sorts)
[!!] Joins performed without indexes: 4074
[!!] Temporary tables created on disk: 43% (34K on disk / 78K total)
[OK] Thread cache hit rate: 99% (16 created / 81K connections)
[OK] Table cache hit rate: 75% (879 open / 1K opened)
[OK] Open file limit used: 19% (1K/8K)
[OK] Table locks acquired immediately: 99% (800K immediate / 801K locks)
-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 37.3% (25M used / 67M cache)
[OK] Key buffer size / total MyISAM indexes: 64.0M/347.2M
[OK] Read Key buffer hit rate: 100.0% (53M cached / 13K reads)
[OK] Write Key buffer hit rate: 98.5% (3M cached / 46K writes)
-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 8.0M/1.4M
[!!] InnoDB Used buffer: 25.59% (131 used/ 512 total)
[OK] InnoDB Read buffer efficiency: 100.00% (22433756 hits/ 22433851 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 387 writes)