“wp_wppa_session” table oversized

  • Resolved Pistolero7

    (@pistolero7)


    6 days, 22 hours ago

    Hi, I’ve got a mail from OVH to tell me that my database was full 203Mo/200Mo and I can’t access my WP anymore. (Read Only)

    I’ve checked on PHPMyAdmin and it seems that the bigger table is by far “wp_wppa_session” one, oversized to 153Mo (!) with more than 276 000 lines ! Some have status “valid” or “expired”…

    Please, could you tell me the kind of lines I can remove without any risk ? (I’m not aware about anything and I don’t understand most of the utility of these lines, so I don’t want to make any mistake…

    Thanks a lot in advance,

    have a nice day,

    Lilian

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    You may truncate (clear) the table.

    Are you sure cron processes run? It should be cleaned regularly (removed expired items older than one hour)

    Thread Starter Pistolero7

    (@pistolero7)

    Hi Jacob, thanks for your answer, sorry, notification went down into spams.

    I don’t know about cron processes but I’ll check this out for sure.

    I’ve got back to a previous version of the website (save from several hours ago) and table was cleaned that way to 53Mo only. I can’t explain it went oversized that fast…

    Thanks for your answer !

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    If you update to todays version 8.9.02.005 the expired items with timestamp < 1 hour ago will aso be removed when a new session is started, so this should help even with possible cron issues.

    Thread Starter Pistolero7

    (@pistolero7)

    Thanks, I’ve just did this morning. I hope this issue won’t happen again, I will let you know if it does. Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.