Support » Plugin: WordPress MU Domain Mapping » wp_domain_mapping_logins reaches 10 MBs!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    No, normally those get deleted. A cause for that might be that your site was being hit heavily with bots trying to hack passwords with log in attempts.

    Thread Starter WebNashr

    (@webnashr)

    The oldest row is for 2014-01-09.

    Plugin Author Ron Rennick

    (@wpmuguru)

    The age of the records isn’t particularly important. A bot doing login attempts does not load the second request that removes the record.

    Thread Starter WebNashr

    (@webnashr)

    Is it safe to delete the rows?

    Plugin Author Ron Rennick

    (@wpmuguru)

    Yes.

    Thread Starter WebNashr

    (@webnashr)

    Thnx
    Isn’t there a way to control the size of the table in the plugin?
    Now it has reached 11mb

    I just noticed this problem on my site too. over 65,000 rows in this table!!!!!

    Data gets logged in this table every time there is a user logout. The problem is this data only gets removed if the “remote login” option is turned on. The query that clears this stuff out doesn’t trigger when remote login is off. This seems like a small oversight in code but has huge potential for bloat on busy sites/networks.

    Most of these logged rows in the domain_mapping_logins table are supposed to be deleted if they’re older than 2 MINUTES by the plugin, but again, the query never runs if remote login is off.

    Crazy town!

    I’m manually disabling this query that adds the data to the DB because it appears the data only seems to be relevant if remote login is being used (comment out line 680 in the most recent version of the plugin).

    The long term solution IMO would be to have the plugin updated to not log this info at all if remote login is off. I may not understand the intent of this info though.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wp_domain_mapping_logins reaches 10 MBs!’ is closed to new replies.