ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Query taking excessive time

November 14, 2012 1:57pm

Subscribe [2]
  • #1 / Nov 14, 2012 1:57pm

    Bantha Skull

    2 posts

    I upgraded my site to Expression Engine 2 over the weekend (from 1.6.3).  The upgrade went well, but since the upgrade, I’ve suffered near round the clock CPU throttling.  I went through the routine steps (database repair and optimize) and it did not help.  I checked the slow query log, and the following was present almost every time:

    UPDATE `ex_online_users` SET `member_id` = 0, `name` = ‘’, `ip_address` = ‘188.143.232.202’, `date` = 1352910496, `anon` = ‘’, `site_id` = ‘1’ WHERE `site_id` =  ‘1’ AND `ip_address` =  ‘188.143.232.202’ AND `member_id` =  0

    Sometimes taking more than 10 seconds.  I actually don’t care about this logging.  Can it just be disabled?

    Also, the IP address in question is from Russia and would not be my usual traffic.  Is there a security measure I should take to block access?

    Thank you,
    Chris

  • #2 / Nov 14, 2012 2:10pm

    Bantha Skull

    2 posts

    I was able to find where to disable the online user tracking.

  • #3 / Nov 15, 2012 2:34pm

    Shane Eckert

    7174 posts

    Hey there Bantha Skull,

    Awesome! Glad you found it.

    Is there anything else I can help with?

    Cheers,

  • #4 / Nov 15, 2012 3:45pm

    Bantha Skull

    2 posts

    If you had a link handy for general EE performance tuning tips, I’d appreciate it.

    Thank you,
    Chris

  • #5 / Nov 15, 2012 4:12pm

    Shane Eckert

    7174 posts

    Hey there Bantha Skull,

    Sure things! Check these guidelines out.

    If you need anything else, please just let me know by opening a new thread.

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases