Jump to content

Featured Replies

Спойлер

[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.


Guest
Ответить в этой теме...

Последние посетители 0

  • No registered users viewing this page.