Feb 27, 2017
6
0
1
Chile
cPanel Access Level
Root Administrator
This its my my.cnf file:

[mysqld]
max_connections = 200
query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 2M
performance-schema = 0
local-infile = 0
tmpdir=/mysqltmp
wait_timeout = 120
interactive_timeout = 120
sort_buffer_size = 2G
myisam_sort_buffer_size = 2G
default-storage-engine=MyISAM
innodb_file_per_table = 1
max_allowed_packet = 268435456
open_files_limit=12000
key_buffer_size = 2G
read_buffer_size = 16M

My server its a xeon 8 core and 8 gb ram.

What i did wrong?

Regards!
 

Jcats

Well-Known Member
PartnerNOC
May 25, 2011
807
160
168
New Jersey
cPanel Access Level
DataCenter Provider
It most likely has nothing to do with your mysql configuration.

You have to check the queries to see what is causing the usage:

Code:
# mysqladmin proc
 

SysSachin

Well-Known Member
Aug 23, 2015
604
48
28
India
cPanel Access Level
Root Administrator
Twitter
Hello,

You have to optimize MySQL by using mysqltuner script and update the my.cnf record as per the mysqltuner.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
Hello,

You'd need to first verify if any specific databases or tables are leading to the excessive resource usage. You can do this via the use of a command such as "mysqladmin processlist", as mentioned in the earlier posts to this thread.

Thanks!
 

Jcats

Well-Known Member
PartnerNOC
May 25, 2011
807
160
168
New Jersey
cPanel Access Level
DataCenter Provider
You have to optimize MySQL by using mysqltuner script and update the my.cnf record as per the mysqltuner.
You can tune it as much as you want, this more than likely has nothing to do with tuning.