Repair problem – High mysql cpu load but low memory useing

0
866

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

NO COMMENTS

LEAVE A REPLY