Network maps are not uploaded

[sanhces7]

Hello colleagues! Please, i need help!
I actively use network maps, and the problem always appears - when loading a network map it may not load completely, or leave a white box. Sometimes icons of devices without links appear. Sometimes the first time it loads normally. It is treated by repeated pressing F5 with reboot of the map - sooner or later loading takes place. The problem was noticed on Zabbix 3.4.6, updated to 3.4.11 - the problem remained. MySQL database. Tell me where to dig, please.

[kernbug]

Hello colleagues! Please, i need help!
I actively use network maps, and the problem always appears - when loading a network map it may not load completely, or leave a white box. Sometimes icons of devices without links appear. Sometimes the first time it loads normally. It is treated by repeated pressing F5 with reboot of the map - sooner or later loading takes place. The problem was noticed on Zabbix 3.4.6, updated to 3.4.11 - the problem remained. MySQL database. Tell me where to dig, please.

Hello,

You should start by diagnosing the performance of the server on which the Zabbix database is running (slow queries, storage performance, etc.)

[sanhces7]

Thanks for the answer!
Let's take the following steps:
- slow requests are present, start with the phrase:
"slow query: 1.092355 sec, "insert into history_uint (itemid,clock,ns,value) values (......."
- RAM is 8 Gb, used 70%:
info from htop - Mem[|||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||||||###********************5.3 0G/7.79G]
- a server based on a virtual machine (virtualization environment is Hyper-V). There are no claims to storage performance.
-mysqltuner gives the following recommendations:
-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 1h 45m 0s (15M q [87.970 qps], 379K conn, TX: 35B, RX: 3B)
[--] Reads / Writes: 37% / 63%
[--] Binary logging is disabled
[--] Total buffers: 4.5G global + 24.7M per thread (214 max threads)
[!!] Maximum reached memory usage: 9.7G (124.40% of installed RAM)
[!!] Maximum possible memory usage: 9.7G (124.09% of installed RAM)
[OK] Slow queries: 0% (24/15M)
[!!] Highest connection usage: 100% (215/214)
[OK] Aborted connections: 0.17% (632/379382)
[OK] Query cache efficiency: 61.3% (4M cached / 6M selects)
[!!] Query cache prunes per day: 123191
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 13M sorts)
[OK] Temporary tables created on disk: 3% (37K on disk / 1M total)
[OK] Thread cache hit rate: 99% (216 created / 379K connections)
[!!] Table cache hit rate: 0% (400 open / 445K opened)
[OK] Open file limit used: 0% (1/1K)
[OK] Table locks acquired immediately: 100% (38K immediate / 38K locks)

-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 18.2% (195M used / 1B cache)
[OK] Key buffer size / total MyISAM indexes: 1.0G/43.0K
[!!] Read Key buffer hit rate: 50.0% (6 cached / 3 reads)

-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 3.0G/149.7G
[OK] InnoDB buffer pool instances: 3
[OK] InnoDB Used buffer: 98.44% (193528 used/ 196600 total)
[OK] InnoDB Read buffer efficiency: 99.99% (3961794347 hits/ 3962245664 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 3471413 writes)

-------- AriaDB Metrics -----------------------------------------------------
[--] AriaDB is disabled.

-------- Replication Metrics -------------------------------------------------
[--] No replication slave(s) for this server.
[--] This is a standalone server..

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Restrict Host for user@% to user@SpecificDNSorIp
Reduce your overall MySQL memory footprint for system stability
Reduce or eliminate persistent connections to reduce connection usage
Increasing the query_cache size over 128M may reduce performance
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
Beware that open_files_limit (1024) variable
should be greater than table_open_cache ( 400)
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
max_connections (> 214)
wait_timeout (< 28800)
interactive_timeout (< 28800)
query_cache_size (> 256M) [see warning above]
table_open_cache (> 400)
innodb_buffer_pool_size (>= 149G) if possible.
Zabbix version is 3.4.11.

I apologize in advance, I'm not lazy and I want to solve my problems myself, but I do not understand which way to move in this situation.

[kernbug]

Thanks for the answer!

[--] Total buffers: 4.5G global + 24.7M per thread (214 max threads)
[!!] InnoDB buffer pool / data size: 3.0G/149.7G
[!!] Maximum reached memory usage: 9.7G (124.40% of installed RAM)
[!!] Highest connection usage: 100% (215/214)
innodb_buffer_pool_size (>= 149G) if possible.

More than confident that you need to partition the database (>100Gb), check connections usage (web? api? statistics?) and increase server RAM if possible.

[sanhces7]

Thank you very much!
I'm not sure that I myself will be able to carry out partisation of the existing database, but you answered my question.
Thanks you!