Hello every body
I found many people , who suffering from this problem
High MySQL LOUD but LOW Memory useing !!!
I will explain the case in little words …
” MySQL” gives the ” CPU ” most commands
We will edit your MySQL useing !!
Open SSH for your server
root@ # pico /etc/my.cnf
If you do not have any content
You should add this information
Also , If you have some of them >> add the missing lines
[mysqld]
local-infile = 0
set-variable = max_connections=500
safe-show-database
max_tmp_tables=1
query_cache_type=1
query_cache_limit=4M
query_cache_size=64M
thread_cache_size=8
table_cache=1024
>>>
Ctrk + X
Save your work
root@ # service mysql restart
GOOD LUCK