The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL tweaking my.cnf for my server - need help

Discussion in 'Workarounds and Optimization' started by Galanthus, Jun 17, 2014.

  1. Galanthus

    Galanthus Well-Known Member

    Joined:
    Nov 8, 2013
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    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 :)
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    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
     
  3. Galanthus

    Galanthus Well-Known Member

    Joined:
    Nov 8, 2013
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page