5 million rows in wp_litespeed_img_optm

  • Resolved searchvista

    (@searchvista)


    1 year, 8 months ago

    Hi there, I’ve noticed that I’m getting disk space warnings, and upon investigation, I have ~5M rows in wp_litespeed_img_optm. There are 861 items in the Media Library.

    A sample row data is like so:

    id: <auto increment value>
    post_id: 0
    optm_status: -8
    src: 0
    src_filesize: 0
    target_filesize: 0
    webp_filesize: 0

    Any idea how I can prevent this?

    Is it realted to another issue I have?

    I have Formidable Forms installed.

    One of the forms allows a User to upload an image.

    Litespeed attempts (and fails) to optimise the images in the secure upload directory, which results in a log file full of lines like so:

    [07-Mar-2023 15:02:17 UTC] PHP Warning:? md5_file(<path-tofile>.jpeg): Failed to open stream: Permission denied in /home/jodent/public_html/wordpress/wp-content/plugins/litespeed-cache/src/media.cls.php on line 139

    Any help appreciated.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Hai Zheng?

    (@hailite)

    We fixed this issue in v5.4. You can use beta test to try latest ‘master’ branch for the fix.

    V5.4 will be released in the end of this month

    Thread Starter searchvista

    (@searchvista)

    Hi, thanks for getting back to me.

    • Will version 5.4 drop the empty rows from the DB, or do I need to do that myself?
    • Does 5.4 fix the log file problem with protected files?

    Thanks!

    Plugin Support Hai Zheng?

    (@hailite)

    When you do optimization, it will remove db records gradually until done.

    what is your secure upload folder?

    Thread Starter searchvista

    (@searchvista)

    Hi there,

    WP is installed in a sub-folder called “wordpress”.

    My secure upload folder is created by Formidable Forms, and is as below:

    /<user>/public_html/wordpress/wp-content/uploads/formidable/2/

    Where ‘2’ is the ID of the form.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘5 million rows in wp_litespeed_img_optm’ is closed to new replies.