The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

unchecked eximstats - but it's still running and not disabled?

Discussion in 'E-mail Discussions' started by aww, Jul 28, 2012.

  1. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Unchecked eximstats under the service manager under the "TailWatch Drivers"

    Cpanel did it's thing and I thought it was stopped.

    But I am still seeing eximstats queries in the mysql slow log?

    I cannot find eximstats running under ps aux, but I never could so maybe it runs intermittently...

    Since it's now under tailwatch I cannot find it under chkconfig --list either.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Could you try moving the eximstats database as well after stopping MySQL temporarily? Just move it out of /var/lib/mysql entirely to another location. After it has been moved, then start MySQL again.

    You might also want to move the binary:

    Code:
    mv /usr/sbin/eximstats /usr/sbin/eximstats.bak
     
  3. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator

    Ah the idea was just to temporarily suspend it for a day to see if was contributing to load spikes, didn't want to do database deletion (or moving).

    Certainly removing the binary is going to stop it, but where is it actually being called, I guess tailwatch is still firing away on it? Where can I examine the tailwatch configuration?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Yeah, tailwatchd would still be calling it. You can see the logs for tailwatchd at /usr/local/cpanel/logs/tailwatchd_log file.

    You cannot examine the tailwatchd configuration itself as it's a binary at /usr/local/cpanel/bin/tailwatchd
     
  5. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    That's for all the details, good to know how eximstats works on cpanel.

    The good news is it seems to have corrected itself and I don't see anymore eximstats mysql queries, didn't have to do anything but it took overnight to stop. Pretty sure the queries were not on delay so it might have just been tailwatch restarting itself or some other cache clearing.
     
  6. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Aha! Nope it's not disabled, I'll have to investigate your other suggestions, this just showed up in the slow log - we had improved our mysql setup so it was faster and eximstats was now escaping the time limit

    Code:
    # User@Host: eximstats[eximstats] @ localhost []
    # Query_time: 1.562439  Lock_time: 0.000080 Rows_sent: 0  Rows_examined: 3970
    use eximstats;
    SET timestamp=1343701315;
    update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=3 where smtp.transport_is_remote=1 and sends.user IN ('-remote-','root','mailman') and smtp.processed=0;
    
    So still running a day or two later after disabled.
    Code:
    [319] [2012-07-28 15:27:47 -0400] [Cpanel::TailWatch::Utils::EnableDisable] [319] [2012-07-28 15:27:47 -0400] [main] 
    Cpanel::TailWatch::Eximstats was successfully disabled


    ps. Does the eximstats database table have all the indexes it should have for best performance?
     
    #6 aww, Jul 30, 2012
    Last edited: Jul 30, 2012
  7. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    What do you think of just renaming /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm

    I guess eximstats has two parts, one that collects the data into mysql, then the post-processor.

    Either one or both of them is still firing.
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    It might be better off to open up a ticket for us to see why this is still running even after it has been unchecked. Even with tailwatchd handling it, it should stop running queries if you've unchecked the service.
     
  9. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Not positive but I think I finally tracked this down.

    eximstats builds a backlog of queries at /var/cpanel/sql/eximstats.sql

    even though eximstats is off, cpanel checks to see if the log still exists, and if so, it slowly goes through the queries

    I renamed the log and the queries seem to have stopped
     
Loading...
Similar Threads - unchecked eximstats still
  1. nisamudeen97
    Replies:
    5
    Views:
    1,198
  2. phild
    Replies:
    3
    Views:
    1,010

Share This Page