offload without relation

  • mikestamford

    (@mikestamford)


    2 years ago

    ogirinal post in database is

    #post_content
    <img src=test.com/wp-content/image1.jpg”/>
    <img src=test.com/wp-content/image2.jpg”/>
    #post_content
    then when click edit or something its need long time to get s3 link form db like

    /test.com/wp-content/image1.jpg -> image.test.com/image1.jpg
    /test.com/wp-content/image2.jpg -> image.test.com/image2.jpg

    and now my site had about 1,000,000 image and this process make my site die
    some one help me to change post content in db to s3 link please

    i want replace all image in post content be like this

    #post_content
    <img src=image.test.com/image1.jpg”/>
    <img src=image.test.com/image2.jpg”/>
    #post_content

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Delicious Brains Support

    (@dbisupport)

    2 years ago

    Hi Mike,

    WP Offload Media Support Team here. Thanks for reaching out with your query, we would be happy to assist!

    We don’t recommend modifying the URLs in the database directly. WP Offload Media rewrites URLs on-the-fly to make it more compatible with other plugins that may rely on these images.

    One of the reasons why a site slows down is a plugin that accesses images on your server. If Remove Local Media is enabled, some plugins tries to access the images directly on your bucket. This could cause some performance issue.

    Another possible reason is an issue with object caching, if you are using one. WP Offload Media caches the rewritten URLs so that it doesn’t have to always check the database. If the plugin detects that you have object caching, it uses that instead of saving the URLs in the postmeta table.

    It’s possible that there’s an error happening during the rewrite process. If debugging is not enabled on your site, please try editing your wp-config.php file and replace this line –

    define( ‘WP_DEBUG’, false );

    With these lines –

    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    define(‘WP_DEBUG_DISPLAY’, false);

    This means that any errors are logged to /wp-content/debug.log, because some errors are not visible on screen. More details about that at https://ww.wp.xz.cn/support/article/editing-wp-config-php/#wp_debug

    Try editing a page again, then check your debug.log file for any errors. WP Offload Media logs its errors with “AS3CF” so you can search your debug.log file for that string to see if our plugin is experiencing some issues.

    Let us know how it goes for you.

    Thread Starter mikestamford

    (@mikestamford)

    2 years ago

    run all time and cant even access website, help me fix it please

    Thread Starter mikestamford

    (@mikestamford)

    2 years ago

    its still run even i try to deactivate all plugins 🥲🥲🥲

    Plugin Support Delicious Brains Support

    (@dbisupport)

    2 years ago

    Hi @mikestamford,

    WP Offload Media has some caching system built in so that it doesn’t always call the database to retrieve the S3 version of a file URL. It’s possible it’s not working properly on your site.

    Can you please try editing your wp-config.php file and replace this line –

    define( ‘WP_DEBUG’, false );

    With these lines –

    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    define(‘WP_DEBUG_DISPLAY’, false);

    This means that any errors are logged to /wp-content/debug.log, because some errors are not visible on screen. More details about that at <u>https://ww.wp.xz.cn/support/article/editing-wp-config-php/#wp_debug</u&gt;

    Can you try again the process that generated that slow query, and then attach the debug.log file with your reply please. WP Offload Media logs its errors with “AS3CF” so you can search your debug.log file for that string to see if our plugin is experiencing some issues.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘offload without relation’ is closed to new replies.