Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2005
    Location
    Manchester, UK
    Posts
    65

    SQL taking up huge resources

    I've just noticed that on one of my dedicated servers (a Barton 3000 with 1Gb of DDR RAM) that SQL is sometimes using over 50% of the available memory - is this right? (currently it is at about 20%)

    The server only hosts 1 slightly busy zencart powered ecom site and a smaller (hardly used) zencart site...

    Other server specs are CentOS, WHM & Cpanel and running mySQL v4.0

    If this seems a little high - is there anything I can do?

    Thanks in advance...

    Tony

  2. #2
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

  3. #3
    Join Date
    Oct 2005
    Location
    Orlando, FL
    Posts
    24
    Are you using the latest Centos 4.2 kernel? 2.6.9-22?

    There's a bug in that kernel that affects MySQL regarding memory caching. I had to revert to -11 to avoid the issue, for now. This may or may not be your problem though.

  4. #4
    Join Date
    Sep 2005
    Location
    Manchester, UK
    Posts
    65
    Originally posted by xheliox
    Are you using the latest Centos 4.2 kernel? 2.6.9-22?

    There's a bug in that kernel that affects MySQL regarding memory caching. I had to revert to -11 to avoid the issue, for now. This may or may not be your problem though.
    I'm not sure - WHM reports CentOS 3.5 i686 but doesn't go into any more detail... The server is managed so i'll pop the issue and the OS version question in a ST and see what occurs..

    Thanks for all the help

    Tony

  5. #5
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

  6. #6
    Join Date
    Sep 2005
    Location
    Manchester, UK
    Posts
    65
    Originally posted by ThinkSupport
    You can check the kernel version at shell prompt with uname -a command.
    Thanks...

    Shell reports 2.4.21-32.0.1.EL

    So I guess i am not running the buggy version...

    Tony

  7. #7
    Join Date
    Oct 2005
    Location
    Orlando, FL
    Posts
    24
    Doesn't look like it.

  8. #8
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

  9. #9
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

  10. #10
    Join Date
    Sep 2005
    Location
    Manchester, UK
    Posts
    65
    Originally posted by ThinkSupport
    Hey Tony,

    This might help you a bit with your mysql tweaking :

    http://www.webhostingtalk.com/showth...hreadid=453770
    Thank you very much - it's appreciated!

  11. #11
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •