Сервер дома: слабый компьютер, настройка системы

Тема в разделе "Администрирование серверов", создана пользователем irip, 4 янв 2017.

Модераторы: mefish
  1. balinese

    balinese Создатель

    Регистр.:
    17 мар 2014
    Сообщения:
    31
    Симпатии:
    6
    а, mysqltuner-ом погоняйте мускул. может чего изменится
     
  2. irip

    irip

    Регистр.:
    12 авг 2006
    Сообщения:
    515
    Симпатии:
    50
    Почему не будет, в личку дать могу, конечно


    -------- 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)