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.
0 Comments