Not loading table optimization options

  • Resolved Masud Rana

    (@yeelloo)


    3 years, 6 months ago

    Hi There,

    We have a relatively large database (45gb).
    Wanted to optimize our tables monthly but I see optimizations option are not loading at all ! Probably the size has to do something with it !
    Is WP Optimize able to handle such data volume ?

    https://prnt.sc/abaMJgDxNhcN

    Regards
    Masud Rana

    • This topic was modified 3 years, 6 months ago by Masud Rana.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Venkat Raj

    (@webulous)

    3 years, 6 months ago

    @yeelloo I’m not sure about the issue. Do you see any errors in browser console?
    Or timeout error in the php error log file?

    Thread Starter Masud Rana

    (@yeelloo)

    3 years, 6 months ago

    @webulous Yes, The request keeps hanging for 1.5 mins then
    POST /admin-ajax.php?_fs_blog_admin=true 502
    Note: I do get tables tab with table information after clicking Refresh data
    action: wp_optimize_ajax
    subaction: get_table_list

    Plugin Contributor Venkat Raj

    (@webulous)

    3 years, 6 months ago

    @yeelloo 502 is a bad gateway error

    According to MDN…

    > Note: A Gateway might refer to different things in networking and a 502 error is usually not something you can fix, but requires a fix by the web server or the proxies you are trying to get access through.

    https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/502

    That said, could you please try our CLI commands and see if that works?

    To list all optimizations
    wp optimize optimizations

    To do optimization
    wp optimize do-optimization --optimization-id=<optimization_name> eg. postmeta

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

The topic ‘Not loading table optimization options’ is closed to new replies.