Results 1 to 10 of 10
  1. #1
    Join Date
    May 2002
    Location
    singapore
    Posts
    455

    mysql problem ... server load 20-50 help!

    hi there ...

    even after reboot and apache is shut down,

    mysqld is using 60% of cpu resources and eating most of the RAM

    any idea what went wrong? and how do i fix it?



    mysql 147.71 131.07 0.0
    Top Process %CPU 99.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking
    Top Process %CPU 91.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking
    Top Process %CPU 72.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking



    thanks
    current and satisfied customer of softlayer.com and webnx.com

  2. #2
    Join Date
    Jun 2003
    Location
    Indiana, US
    Posts
    1,355
    *edit*

  3. #3
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,681
    What does your /etc/my.cnf look like? what are the box specs?
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  4. #4
    Join Date
    May 2002
    Location
    singapore
    Posts
    455
    thelinuxguy

    it's default setup ... it was fine until few days ago ...
    current and satisfied customer of softlayer.com and webnx.com

  5. #5
    Join Date
    May 2002
    Location
    singapore
    Posts
    455
    thelinuxguy,

    would you be able to fix it for me? if yes which one of your service shoudl i get?
    current and satisfied customer of softlayer.com and webnx.com

  6. #6
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,681
    what is the server specs?
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  7. #7
    Join Date
    May 2002
    Location
    singapore
    Posts
    455
    it's athlon 2400 ... 1gb ram
    current and satisfied customer of softlayer.com and webnx.com

  8. #8
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,681
    [mysqld]
    skip-locking
    key_buffer=16M
    join_buffer=1M
    record_buffer=1M
    sort_buffer=2M
    table_cache=1028
    max_connections=250
    thread_cache_size=286
    max_allowed_packet=5M
    connect_timeout=15
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    thread_concurrency=2
    wait_timeout=15
    try using something like that in /etc/my.cnf
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  9. #9
    Join Date
    May 2002
    Location
    singapore
    Posts
    455
    it doesnt help ... still sky high
    current and satisfied customer of softlayer.com and webnx.com

  10. #10
    Join Date
    Nov 2002
    Posts
    2,780
    try reindex the whole database,
    then do a mysqlcheck -rao on the Dbs,
    http://Ethr.net jay@ethr.net
    West Coast AT&T / Level3 / Savvis Bandwidth, Colocation, Dedicated Server, Managed IP Service, Hardware Load Balancing Service, Transport Service, 365 Main St, SFO / 200 Paul Ave, SFO / PAIX, PAO / Market Post Tower, 55 S. Market, SJC / 11 Great Oaks, Equinix, SJC

Posting Permissions

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