Results 1 to 5 of 5

Thread: Myslqd

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Posts
    42
    Rep Power
    10

    Exclamation Myslqd

    Every so often mysqld pins my server's processor (100%) for about 1-2 minutes. I'm not sure of the exact frequency, but it's high enough that I've noticed it in top.

    This is a a pretty decent server: AMD Sempron(tm) Processor 2600+ with 1G of ram.

    Ideas?

  2. #2
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    What version do you have? M2 had a new logger process that didn't have enough data indexes. This will be fixed going forward.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    Join Date
    Nov 2005
    Posts
    42
    Rep Power
    10

    Default

    Quote Originally Posted by KevinH
    What version do you have? M2 had a new logger process that didn't have enough data indexes. This will be fixed going forward.
    I'm using M2. Is there a sql script I could use to update the log tables to add these indexes? This is causing some serious performance problems for me.

    Thanks!

  4. #4
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default indices to add

    su - zimbra
    logmysql
    use zimbra_logger;

    alter table mta add index i_arrive_time (arrive_time);
    alter table amavis add index i_arrive_time (arrive_time);
    alter table mta_aggregate add index i_period_start (period_start);
    alter table mta_aggregate add index i_period_end (period_end);
    alter table amavis_aggregate add index i_period_start (period_start);
    alter table amavis_aggregate add index i_period_end (period_end);

  5. #5
    Join Date
    Nov 2005
    Posts
    42
    Rep Power
    10

    Default

    Quote Originally Posted by marcmac
    su - zimbra
    logmysql
    use zimbra_logger;

    alter table mta add index i_arrive_time (arrive_time);
    alter table amavis add index i_arrive_time (arrive_time);
    alter table mta_aggregate add index i_period_start (period_start);
    alter table mta_aggregate add index i_period_end (period_end);
    alter table amavis_aggregate add index i_period_start (period_start);
    alter table amavis_aggregate add index i_period_end (period_end);
    Yeah, that fixed it. It used to take 2 minutes at 100% processor. Now it takes 3 seconds at 7%.

    Thanks for the quick turnaround.

    bp

Posting Permissions

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