Why is the MyISAM Index Cache score high?

Question

MySQL

Good afternoon
I have a very high MyISAM index - always 50%. Increased key_buffer_size to 2GB, hosting is good, but the indicator does not change. Site buybags96.ru. The Bitrix version is the latest, on the Bitrix VM hosting, from the bvat configuration, the only thing that has changed is key_buffer_size. Caching is enabled. The configuration shows that not everything is in order with the speed of working with sql.

Answer 1

Just in case, I'll tell you how I solved a similar problem.
In addition to such an error as on the screen of the TC, my MySQL was constantly falling. I studied the CentOS logs, it turned out that the system kills the mysqld process when for some reason the free space in the swap is depleted - during backup, for example, when the database is loaded into memory.
It turned out that by default, when deploying a virtual machine, Bitrkis sets the swap partition to 512 MB. For a fresh empty base, this is normal. Over time, this is no longer enough. I have databases on projects of the order of 5-6 GB.
Following the instructions , I created a swap file equal to the amount of memory allocated to the system (6 GB, I have virtual hosts). Next, I disabled the swap partition. And everything started working without errors and crashes.
PS. Swap consumption can be monitored in real time using the htop utility, which is easily installed on the system.

Answer 2

Judging by the index size of 140 KB, you have almost no MyISAM tables or none at all, so this cache is simply not used as unnecessary and it makes no sense to inflate it to incredible values. If you have a problem with the DBMS, then it is 100% not here.
PS key_buffer_size put 500 Kb. You don't need more.