Le serveur tombe tous les jours à peu près au même moment. Associé à MYSQL?

Nous avons un serveur dédié avec plusieurs applications exécutées, y compris le forum Vbulletin et site Wordpress. La principale application intensive de ressources - Ceci est une application de discussion PHP, Qui utilise également MYSQL.

Il semble que chaque jour soit à peu près à la même heure que le serveur est éteint ou se bloque. La charge de processeur est plus élevée, mais toujours dans la plage valide. Je ne vois pas d'événements de course. Je soupçonne que quelque chose arrive à MYSQL, et il s'éteint, car chaque fois que je redémarre MYSQL, Tout semble être corrigé, mais cela peut être une coïncidence.

Sur le serveur installé ​​Cpanel. Brancher Engintron pour Nginx et MariaDB 10.1 Pour la base de données. CentOS 7.

Voici mes résultats MYSQLTuner:

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 10.1.33-MariaDB

[OK] Operating on 64-bit architecture



-------- Storage Engine Statistics -----------------------------------------------------------------

[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE 

[--] Data in MyISAM tables: 2G (Tables: 310)

[--] Data in InnoDB tables: 28G (Tables: 308)

[--] Data in MEMORY tables: 16M (Tables: 3)

[!!] Total fragmented tables: 111

[!!] failed to execute: SHOW TABLE STATUS FROM \`#mysql50#.ssh\`

[!!] FAIL Execute SQL / return code: 256



-------- Security Recommendations ------------------------------------------------------------------

[OK] There are no anonymous accounts for any database users

[OK] All database users have passwords assigned

[!!] There is no basic password file list!



-------- CVE Security Recommendations --------------------------------------------------------------

[--] Skipped due to --cvefile option undefined



-------- Performance Metrics -----------------------------------------------------------------------

[--] Up for: 2d 9h 41m 49s (37M q [182.400 qps], 12M conn, TX: 116G, RX: 12G)

[--] Reads / Writes: 85% / 15%

[--] Binary logging is disabled

[--] Physical Memory     : 62.7G

[--] Max MySQL memory    : 51.0G

[--] Other process memory: 2.5G

[--] Total buffers: 35.1G global + 16.3M per thread (1000 max threads)

[--] P_S Max memory usage: 0B

[--] Galera GCache Max memory usage: 0B

[OK] Maximum reached memory usage: 35.9G (57.19% of installed RAM)

[OK] Maximum possible memory usage: 51.0G (81.37% of installed RAM)

[OK] Overall possible memory usage with other process is compatible with memory available

[OK] Slow queries: 0% (518/37M)

[OK] Highest usage of available connections: 4% (46/1000)

[OK] Aborted connections: 0.17%  (20794/12263809)

[!!] Query cache efficiency: 10.6% (2M cached / 24M selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (22 temp sorts / 6M sorts)

[!!] Joins performed without indexes: 1016

[OK] Temporary tables created on disk: 0% (5K on disk / 15M total)

[OK] Table cache hit rate: 74% (1K open / 1K opened)

[OK] Open file limit used: 0% (787/1M)

[OK] Table locks acquired immediately: 99% (52M immediate / 52M locks)



-------- ThreadPool Metrics ------------------------------------------------------------------------

[--] ThreadPool stat is enabled.

[--] Thread Pool Size: 12 thread(s).

[--] Using default value is good enough for your version (10.1.33-MariaDB)



-------- Performance schema ------------------------------------------------------------------------

[--] Performance schema is disabled.



-------- MyISAM Metrics ----------------------------------------------------------------------------

[!!] Key buffer used: 20.2% (867M used / 4B cache)

[OK] Key buffer size / total MyISAM indexes: 4.0G/617.7M

[OK] Read Key buffer hit rate: 100.0% (1B cached / 82K reads)

[!!] Write Key buffer hit rate: 42.3% (111K cached / 64K writes)



-------- AriaDB Metrics ----------------------------------------------------------------------------

[--] AriaDB is enabled.

[OK] Aria pagecache size / total Aria indexes: 128.0M/1B

[OK] Aria pagecache hit rate: 97.9% (253K cached / 5K reads)



-------- InnoDB Metrics ----------------------------------------------------------------------------

[--] InnoDB is enabled.

[OK] InnoDB buffer pool / data size: 30.0G/28.9G

[!!] InnoDB buffer pool instances: 20

[!!] InnoDB Used buffer: 54.49% (1071288 used/ 1966060 total)

[OK] InnoDB Read buffer efficiency: 99.99% (13800614528 hits/ 13801405527 total)

[OK] InnoDB Write log efficiency: 95.40% (68361750 hits/ 71657060 total)

[!!] InnoDB log waits: 0.00% (39 waits / 3295310 writes)



-------- TokuDB Metrics ----------------------------------------------------------------------------

[--] TokuDB is disabled.



-------- Galera Metrics ----------------------------------------------------------------------------

[--] Galera is disabled.



-------- Replication Metrics -----------------------------------------------------------------------

[--] Galera Synchronous replication: NO

[--] No replication slave(s) for this server.

[--] This is a standalone server.



-------- Recommendations ---------------------------------------------------------------------------

General recommendations:



Run OPTIMIZE TABLE to defragment tables for better performance

Adjust your join queries to always utilize indexes

Variables to adjust:



query_cache_limit (> 1M, or use smaller result sets)



join_buffer_size (> 4.0M, or always use indexes with joins)



innodb_buffer_pool_instances(=30)



innodb_log_buffer_size (>= 8M)

Merci d'avance pour toute aide.

Mise à jour: on dirait que le problème était dans une charge importante sur le serveur. J'ai été installé csf, Et il a trop scanné sur le serveur, alors je l'ai abaissé. J'ai aussi apporté des changements à my.cnf. Il semble que cela ait beaucoup aidé.