• Resolved szimpi

    (@szimpi)


    Hello,
    I experienced on some of my websites that database has grown huge. Actually wppa_session table got very big for example on this site I attached link to. It contains 1100 albums and 16777 photos. I know it’s a decent bunch of pics but this table looks too big for me.
    Is there any way to decrease this size and prevent growing so big?
    Best regards, Erik

    The page I need help with: [log in to see the link]

Viewing 6 replies - 16 through 21 (of 21 total)
  • Thread Starter szimpi

    (@szimpi)

    I’ve just run the cleanup cron but the deleted photos still remain.

    Yep, I supposed it can be a problem. Where can I enable WP_Cron?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    define( 'DISABLE_WP_CRON', true ); should be in wp-config.php
    Might be put in by you manually or by a plugin. If so, i would like to know which plugin…

    Thread Starter szimpi

    (@szimpi)

    Yes, there is in the wp-config.php. Should I delete it? I didn’t put it manually.
    I cannot say which plugin has put it into wp-config.php. I use the same plugins on all my sites (and the same theme as well). You’re rigth, it would be very important to know which can cause this database issue. I’ll try to find out.

    Thread Starter szimpi

    (@szimpi)

    I rewrote “true” to “false” in wp-config.php and now I can run manually wppa_cleanup cron. The deleted photos have disappeared too.

    Do you need the list of my plugins I use?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Yes, would be nice. I will also see if i can change wppa so that if this setting is true, it will do all cron actions synchronously, because they have to be done anyway, despite possible performance issues.

    I am glad it works again for you.

    Thread Starter szimpi

    (@szimpi)

    I thanks for the professional support. This photo album plugin the best I ever used. And I tried almost all the similar plugins ??

    The list of plugins I use:
    Add Meta Tags
    Advanced Database Cleaner
    Advanced Tag List
    Akismet Anti-Spam
    All in one Favicon
    Azigen
    Cache Enabler
    Contextual Related Posts
    Datafeedr Random Ads V2
    Display Widgets
    Google XML Sitemap for Images
    Google XML Sitemaps
    ITRO Popup Plugin
    JCH Optimize
    Jetpack a WordPress.com-tól
    Lana Security
    Optimus
    Page Speed PRO
    Platinum SEO Pack
    RSS Just Better
    Simple Google Sitemap
    Simple Google Sitemap XML
    Sitemap Index
    WP Missed Schedule
    WP Performance Score Booster
    WP Photo Album Plus
    WP Smush

    I’ll try to find out which can cause this issue and I’ll let you know if there is something new experience. I truncated the WP tables the day before yesterday so I need some time to check what happens. I tested it on one sites first.

Viewing 6 replies - 16 through 21 (of 21 total)
  • The topic ‘wppa_session table got huge’ is closed to new replies.