MySQL tweaking my.cnf for my server - need help

[Galanthus]

Good day guys,

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

Server information:

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:

[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

 

[vanessa]

This topic has been discussed well in-depth on these forums, and if you Google for it, you'll find all sorts of information.

Sundry MySQL Scripts and Docs

 

[Galanthus]

This topic has been discussed well in-depth on these forums, and if you Google for it, you'll find all sorts of information.

Sundry MySQL Scripts and Docs

Hello Vanessa,

Thanks for the reply. Is there by any chance a tutorial on how to use this and install this script using SSH?

Thanls!

 

[cPanelMichael]

Hello

I have moved this thread to our "Optimization" forum. You should receive more user-feedback here. Note the following thread offers a good way to generate initial tuning statistics:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.