MySQL tweaking my.cnf for my server - need help

Galanthus

Well-Known Member
Nov 8, 2013
87
0
6
cPanel Access Level
Root Administrator
Good day guys,

I would appreciatie some help. I am having a VPS server and i am trying to tweak my MySQL.

Server information:
Code:
Total processors: 2

Processor #1
Vendor GenuineIntel
Name QEMU Virtual CPU version 1.7.1
Speed 2199.998 MHz
Cache 4096 KB

Processor #2
Vendor GenuineIntel
Name QEMU Virtual CPU version 1.7.1
Speed 2199.998 MHz
Cache 4096 KB

Memory: 3901980k/4718592k available (5326k kernel code, 524688k absent, 291924k reserved, 7013k data, 1280k init)

 total       used       free     shared    buffers     cached
Mem:       3922748    2961876     960872          0     100668    1662500
-/+ buffers/cache:    1198708    2724040
Swap:      3080184          0    3080184
Total:     7002932    2961876    4041056
My server has 4GB ram.


My current my.cnf:

Code:
[mysqld]
local-infile=0
default-storage-engine=MyISAM
innodb_file_per_table=1
long_query_time=5
slow_query_log=1
Any good suggestions?

Thanks :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463