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.

Could Cou Help Me For My.Cnf

Discussion in 'General Discussion' started by HostAnadolu, Nov 18, 2007.

  1. HostAnadolu

    HostAnadolu Member

    Joined:
    Feb 6, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hello. i have E 6550 dedicated with 2gb ram. OS is Fedora 6. i use my-huge.cnf for mysql and mysql version is 5.0.27 . i have use mytop for mysql. While i using my-huge.conf i see memory used very high. Could you write me an ideal my.cnf for my dedicated.
    top -n1 :
    Mem: 2066928k total, 2012592k used, 54336k free, 12128k buffers
    Swap: 2031608k total, 1010764k used, 1020844k free, 287184k cached
    31993 mysql 20 0 593m 90m 2932 S 70 4.5 121:44.88 mysqld
    24650 nobody 20 0 32072 17m 1948 S 27 0.9 0:28.79 httpd
    23275 nobody 20 0 22016 8164 1608 S 12 0.4 0:00.12 httpd
    24699 nobody 20 0 30924 15m 2128 S 12 0.8 0:29.64 httpd
    24634 nobody 20 0 31252 13m 2160 S 4 0.7 0:24.84 httpd
    23215 nobody 20 0 23168 9484 1872 S 2 0.5 0:00.61 httpd
    23272 nobody 20 0 24356 10m 1628 S 2 0.5 0:00.69 httpd
    23439 root 20 0 2328 1044 712 R 2 0.1 0:00.01 top
    24610 nobody 20 0 31664 15m 2160 S 2 0.8 0:22.24 httpd

    Could you help me please?
     
  2. gupi

    gupi Well-Known Member

    Joined:
    Apr 27, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    16
  3. HostAnadolu

    HostAnadolu Member

    Joined:
    Feb 6, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    i want only a my.cnf. not a tool. thank you
     
  4. isputra

    isputra Well-Known Member

    Joined:
    May 3, 2003
    Messages:
    576
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Mbelitar
    my.cnf needed for one server will not the same with my.cnf for another server. it depend on how the server install and hardware that installed on the server.

    gupi is right, if you install tool from www.day32.com/MySQL, the tool will give you some information about what you must change on your my.cnf

    cheers
     
  5. HostAnadolu

    HostAnadolu Member

    Joined:
    Feb 6, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    how can i setup and use it?
     
  6. gupi

    gupi Well-Known Member

    Joined:
    Apr 27, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    16
    Execute the following commands in SSH
    Code:
    wget http://www.day32.com/MySQL/tuning-primer.sh
    chnod +x tuning-primer.sh
    ./tuning-primer.sh
     
Loading...

Share This Page