Mengatasi service Mysql Banyak Memakan Memory

Kasusnya ketika merunning aplikasi sangat lah lambat,. saya kira karena ada query yang lambat pas dicek query fine-fine saja berikut hasil cek nya :

Cara Mengatasi nya bisa menggunakan ini :

In your my.cnf (MySQL configuration) file:

Add a setting in [mysqld] block

[mysqld]

performance_schema = 0

---

For MySQL 5.7.8 onwards, you will have to add extra settings as below:

[mysqld]

performance_schema = 0

show_compatibility_56 = 1

NOTE: This will cut your Memory usage to more than 50%-60%. "show_compatibility_56" is optional, for some cases it works, better to check it once added to the config file.