Results 1 to 2 of 2

Thread: MySQLd hogging CPU

  1. #1
    rbreck is offline Active Member
    Join Date
    May 2010
    Posts
    34
    Rep Power
    5

    Default MySQLd hogging CPU

    [SOLVED]

    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
    rbreck is offline Active Member
    Join Date
    May 2010
    Posts
    34
    Rep Power
    5

    Default

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

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    skip-locking
    old_passwords=1
    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
    log_slow_queries
    long_query_time=1
    
    init_connect='SET collation_connection = utf8_general_ci'
    init_connect='SET NAMES utf8'
    default-character-set=utf8
    character-set-server = utf8
    collation-server = utf8_general_ci
    
    
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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, 09:34 AM
  4. mysqld hogging all the cpu
    By jeffw in forum Administrators
    Replies: 7
    Last Post: 01-16-2008, 07:50 PM
  5. System-Load with M4
    By billybofh in forum Administrators
    Replies: 7
    Last Post: 02-15-2006, 02: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
  •