Results 1 to 2 of 2

Thread: MySQLd hogging CPU

  1. #1
    Join Date
    May 2010
    Rep Power

    Default MySQLd hogging CPU


    Mysqld is hogging the CPU on one of my new NE installs (fluctuates between 40-80% and keeps the machine's overall load average quite high).

    We just rolled this server out and there's only one active mailbox on it. It's a bit of a doozy, a client who had a 13GB PST that had to be imported. Not only does he have a lot of mail, but he's a OCD sorted, so there are 2178 subfolders in his inbox. Most have only 2-3 emails in them.

    His account is currently be accessed by his Laptop (IMAP), iPAD (as an exchange account) and Blackberry (with ZBC).

    I'm assuming that the incredulous number of folders he has and the fact that he's hitting them 3x over might have something to do with the server running hot?

    If so, any tuning suggestions for someone with so many folders? We're hoping to get hundreds of more accounts on this server in the next few weeks, but I'm worried it's going to end up having to be dedicated to a single account :P
    Last edited by rbreck; 09-23-2011 at 03:21 PM. Reason: Solved

  2. #2
    Join Date
    May 2010
    Rep Power


    I ended up tweaking /etc/my.cnf and got it all to calm down..

    key_buffer = 384M
    max_allowed_packet = 8M
    table_cache = 512
    sort_buffer_size = 2M
    read_buffer_size = 2M
    read_rnd_buffer_size = 8M
    myisam_sort_buffer_size = 64M
    thread_cache = 4
    #thread_concurrency = 2
    thread_concurrency = 8
    query_cache_size = 128M
    query_cache_limit = 4M
    max_connections = 1500
    init_connect='SET collation_connection = utf8_general_ci'
    init_connect='SET NAMES utf8'
    character-set-server = utf8
    collation-server = utf8_general_ci

Similar Threads

  1. Mysqld cpu use high
    By akintemel in forum Administrators
    Replies: 0
    Last Post: 11-03-2010, 01:07 AM
  2. Mysqld demaon use %100 cpu
    By akintemel in forum Administrators
    Replies: 3
    Last Post: 10-27-2010, 07:54 AM
  3. Upgraded to 4.5.11; mysqld Now Consuming 99.9% CPU
    By LMStone in forum Administrators
    Replies: 3
    Last Post: 02-14-2008, 08:34 AM
  4. mysqld hogging all the cpu
    By jeffw in forum Administrators
    Replies: 7
    Last Post: 01-16-2008, 06:50 PM
  5. System-Load with M4
    By billybofh in forum Administrators
    Replies: 7
    Last Post: 02-15-2006, 01:11 AM

Posting Permissions

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