Page 6 of 6 FirstFirst ... 456
Results 76 to 85 of 85

Thread: eximstats SQL delayed insert

  1. #76
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    11,307
    cPanel/WHM Access Level

    Root Administrator

    Default Re: eximstats SQL delayed insert

    Case 59361 has been resolved in version 11.32.3.15 and later. If you are still experiencing these issues, please let us investigate them via http://go.cPanel.net/bugs

  2. #77
    Member
    Join Date
    Oct 2001
    Posts
    177

    Default Re: eximstats SQL delayed insert

    I am getting this on all servers. Build stable 3.32.3 (build 23)

  3. #78
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel/WHM Access Level

    Root Administrator

    Default Re: eximstats SQL delayed insert

    As stated, please submit a bug report at http://go.cpanel.net/bugs if this is still happening
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  4. #79
    Member
    Join Date
    Apr 2005
    Posts
    137

    Default Re: eximstats SQL delayed insert

    Quote Originally Posted by cPanelTristan View Post
    As stated, please submit a bug report at http://go.cpanel.net/bugs if this is still happening
    I see it happening on atleast 20 cPanel boxes, submitted ticket.

  5. #80
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: eximstats SQL delayed insert

    If you want to disable Delayed inserts:

    WHM >> Tweak Settings >> Stats and Logs >> Use delayed sql inserts in the eximstats process to reduce the number of disk writes. >> [Off]

    If you want to disable eximstats completely (you will loose mail delivery reports, email address tracing, and smtp bandwidth reporting), you can do so in WHM >> Service Manager >> Eximstats (uncheck this and save)
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  6. #81
    Member
    Join Date
    Apr 2005
    Posts
    137

    Default Re: eximstats SQL delayed insert

    Quote Originally Posted by cpanelnick View Post
    If you want to disable Delayed inserts:

    WHM >> Tweak Settings >> Stats and Logs >> Use delayed sql inserts in the eximstats process to reduce the number of disk writes. >> [Off]

    If you want to disable eximstats completely (you will loose mail delivery reports, email address tracing, and smtp bandwidth reporting), you can do so in WHM >> Service Manager >> Eximstats (uncheck this and save)
    I've been told you *cant* disable Eximstats. You can disable tailwatch for eximstats, but it's still going to waste your CPU cycles by inserting useless data into mysql.

    Can you confirm?

  7. #82
    Member albatroz's Avatar
    Join Date
    Mar 2003
    Location
    Virtual Orbis / Peru
    Posts
    172
    cPanel/WHM Access Level

    Root Administrator

    Default Re: eximstats SQL delayed insert

    So, in summary is bad idea to upgrade to CPanel 11.32 ?

    Quote Originally Posted by optize View Post
    I've been told you *cant* disable Eximstats. You can disable tailwatch for eximstats, but it's still going to waste your CPU cycles by inserting useless data into mysql.

    Can you confirm?

  8. #83
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel/WHM Access Level

    Root Administrator

    Default Re: eximstats SQL delayed insert

    There's a discussion on why this might be occurring here:

    http://forums.cpanel.net/f43/uncheck...ml#post1203291

    Basically, those queries will still be inserted. Move the file if you don't want these to log to MySQL.
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  9. #84
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: eximstats SQL delayed insert

    If you disable the eximstats tailwatchd module, nothing should be inserted from the exim logs into the database.
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  10. #85
    Member
    Join Date
    Mar 2008
    Posts
    264

    Default Re: eximstats SQL delayed insert

    When will this be solved? This is affecting some of my servers for over a year now.

    MySQL is constantly using 50% of CPU because of all the delayed eximstats.
    PingHosters - Expert hosting community for hosters - Soporte en Espaņol para cPanel y WHM

Page 6 of 6 FirstFirst ... 456

Similar Threads

  1. sql db/ sql db users not checked in cpanel
    By Jheroen in forum Database Discussions
    Replies: 1
    Last Post: 05-14-2012, 01:26 AM
  2. Delayed insert
    By big_bull in forum Database Discussions
    Replies: 2
    Last Post: 08-09-2010, 12:06 PM
  3. Replies: 3
    Last Post: 05-29-2010, 06:49 PM
  4. Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in ...
    By pcsousa in forum cPanel & WHM Discussions
    Replies: 4
    Last Post: 12-30-2008, 02:20 AM
  5. How to insert some php code ?
    By Radio_Head in forum Themes and Branding
    Replies: 5
    Last Post: 10-18-2002, 08:59 PM