MySQL tweaking my.cnf for my server - need help

Galanthus

• June 17, 2014 16:00

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

  • June 18, 2014 01:31

  This topic has been discussed well in-depth on these forums, and if you Google for it, you'll find all sorts of information. [url=http://www.day32.com/MySQL/]Sundry MySQL Scripts and Docs

  0
• 

  Galanthus

  • June 18, 2014 10:36

  [quote="vanessa, post: 1666992">This topic has been discussed well in-depth on these forums, and if you Google for it, you'll find all sorts of information. [url=http://www.day32.com/MySQL/]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!

  0
• 

  cPanelMichael

  • June 18, 2014 15:58

  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.

  0

Please sign in to leave a comment.