WP Optimize taking too long

  • Resolved Ron DiLauro

    (@rdilauro)


    6 years, 3 months ago

    I just installed the WP-Optimize Plugin. I used several of the optimize buttons without any problems. When I used the Optimize Database tables , it ran for over 3 hours with no final results.

    What should the first time running this tool take in time?

    Data base is 12Gig, WP Optimize says it can save 7.2gig

    At this point, I am a little hesitant to run the optimize table again. There is no status indicating or progress bar so, I could see what is happening

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Ron DiLauro

    (@rdilauro)

    I s tarted this again this morning The initial message said there were 47 tables to optimize. So far, wall clock time, the optimization has been running 3.5 hours

    Thread Starter Ron DiLauro

    (@rdilauro)

    Ive had the same problem. Site owners indicate no server error log associated with my domain and process.
    I watched WP-Optimize go through the SQL tables. It seemed to go fast through smaller tables, but right now, its been 2 hours on a table that is 1.1Mib in size.
    If anything, having a process indicator from WP-Optimize would be helpful.
    When I’ve talked to the site owners, they all say everything is fine on their end and my values, I/O, Timeout, CPU, etc are in below their thresholds, so they are saying that the problems has to be with the plugin.
    Nut where and why does it take so long.

    There really needs to be some type of indicator so you can visually see the progress of the optimizing of the database

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    Unfortunately, a progress indicator on the table space optimization (i.e. the top one on the list) is not possible, because all that’s happening is that WP-Optimize passes the “optimize” command to MySQL. From there, MySQL does whatever it does, and when it finishes, passes back control. i.e. MySQL itself gives no feedback on progress.

    For that reason too, it’s unlikely anything actually runs for hours. It’s likely that PHP is set up on the webserver to run for a maximum of a few minutes (or less), and if control hasn’t been passed back at that point, the PHP process dies and the command aborts. If you have multi-gigabyte tables or tables that don’t optimize within the configured PHP timeout on your server, you’ll probably have to run the optimize command from a command-line (i.e. shell) (https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html).

    David

    Thread Starter Ron DiLauro

    (@rdilauro)

    Thanks for the reply.
    I found that using MyPHPAdmin getting to my SQL database and using their Optimize is the better way for me to go.
    Takes less than 30 seconds to run and since I use CPANEL often, its simply to do.

    I will probably continue to use your plugin for some of the other functions it runs

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WP Optimize taking too long’ is closed to new replies.