Új hozzászólás Aktív témák

• bambano titán

  #5609

  #5608 Toma1974

  2013-12-28 17:08:24

  Új Válasz

  Új hozzászólás

  Összes hozzászólása itt Válaszok az összes hozzászólására itt Válaszok erre a hozzászólásra

  

  bambano

  titán

  #5608 Toma1974

  #5608 Toma1974

  --] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
  [!!] Total fragmented tables: 441

  -------- Security Recommendations -------------------------------------------
  [OK] All database users have passwords assigned

  -------- Performance Metrics -------------------------------------------------
  [--] Up for: 8h 51m 25s (781K q [24.510 qps], 5K conn, TX: 319M, RX: 97M)
  [--] Reads / Writes: 10% / 90%
  [--] Total buffers: 382.0M global + 52.5M per thread (500 max threads)
  [!!] Maximum possible memory usage: 26.0G (265% of installed RAM)
  [OK] Slow queries: 0% (0/781K)
  [OK] Highest usage of available connections: 4% (20/500)
  [OK] Key buffer size / total MyISAM indexes: 100.0M/78.2M
  [OK] Key buffer hit rate: 99.9% (1M cached / 1K reads)
  [OK] Query cache efficiency: 43.8% (49K cached / 113K selects)
  [OK] Query cache prunes per day: 0
  [OK] Sorts requiring temporary tables: 0% (1 temp sorts / 2K sorts)
  [OK] Temporary tables created on disk: 1% (54 on disk / 2K total)
  [OK] Thread cache hit rate: 99% (31 created / 5K connections)
  [!!] Table cache hit rate: 5% (1K open / 19K opened)
  [OK] Open file limit used: 48% (1K/2K)
  [OK] Table locks acquired immediately: 100% (637K immediate / 637K locks)
  [!!] Connections aborted: 26%
  [!!] InnoDB data size / buffer pool: 11.8G/150.0M

  -------- Recommendations -----------------------------------------------------
  General recommendations:
  Run OPTIMIZE TABLE to defragment tables for better performance
  MySQL started within last 24 hours - recommendations may be inaccurate
  Reduce your overall MySQL memory footprint for system stability
  Enable the slow query log to troubleshoot bad queries
  Increase table_cache gradually to avoid file descriptor limits
  Your applications are not closing MySQL connections properly
  Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
  table_cache (> 1000)
  innodb_buffer_pool_size (>= 11G)

  Aki tud segítsen a pontos beállításban,mert lag van a szerveren, és pontosan mit mire kell állítani my.cnf-be

  ott van benne minden:
  add ram
  Your applications are not closing MySQL connections properly

  ezekkel kell kezdeni. vagy pedig felraksz egy rendes adatbáziskezelőt.

Új hozzászólás Aktív témák