Posted 5 июня, 20168 yr comment_108092 Спойлер [OK] Maximum possible memory usage: 643.8M (64% of installed RAM) [OK] Slow queries: 0% (1/3K) [OK] Highest usage of available connections: 30% (9/30) [OK] Key buffer size / total MyISAM indexes: 5.0M/4.2M [OK] Key buffer hit rate: 97.6% (3K cached / 91 reads) [OK] Query cache efficiency: 44.7% (1K cached / 2K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 507 sorts) [!!] Joins performed without indexes: 51 [OK] Temporary tables created on disk: 7% (56 on disk / 775 total) [OK] Thread cache hit rate: 97% (9 created / 342 connections) [OK] Table cache hit rate: 98% (534 open / 541 opened) [OK] Open file limit used: 0% (102/30K) [OK] Table locks acquired immediately: 100% (1K immediate / 1K locks) [OK] InnoDB data size / buffer pool: 132.5M/500.0M Прошу решить проблему с этим -[!!] Joins performed without indexes: 51 Количество за сутки доходит свыше 50000 Как можно это пофиксить? Стоит 4 сайта + 6 баз для игры(CSGO). Все конечно грузится без проблем. Но хотелось бы добиться совершенства и сделать минимальную нагрузку на cpu. Версия сервера: 5.5.49-0ubuntu0.14.04.1 Link to comment https://ipbmafia.ru/topic/14593-pomosh-v-optimizacii-mysql/ Share on other sites Больше вариантов
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.