How to reduce the memory consumed by Mysql?

Question

MySQL

Installed XAMPP as a local development server. I didn’t change mysql settings, I noticed that mysqld turned out to be the most memory consuming of all processes, this is strange, before I didn’t notice mysql at all.
This would be tolerable, but MySql is extremely slow, for example when opening PhpMyAdmin. Tried several versions of PhpMyAdmin - no difference.

Answer 1

Размер глобальных буферов (key_buffer_size + tmp_table_size + innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + query_cache_size).

+
*

умножаем на Максимальное количество подключений (max_connections).
Получаем максимально возможный загруз памяти

Well, if in short, in fact, there is of course more.
BUT
Why would you want to decrease this value? I would increase it.

Answer 2

Mysql has a spring aggravation now. It takes and eats memory like crazy, without any external reasons such as a grown database, for example, on innodb, which is actively loaded into memory. Yes?

Answer 3

Deleted all databases except for the one I work with