WordPress.org

Forums

WP-Optimize
[resolved] The plugin always tell to optimize (11 posts)

  1. simbian
    Member
    Posted 1 year ago #

    I noticed a strange behaviour of WP-Optimize plugin.
    If i run the optimization, then it tells me that all tables have been optimized. But if i refresh the settings page (or go to another page and then come back) they all become red and tells me need optimization...

    http://wordpress.org/plugins/wp-optimize/

  2. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    please post your version of mysql and php. Try it out also with phpMyAdmin, it WP-Optimize cant optimize, phpmyAdmin will not be able to optimize too.

    It may happen if one of your tables are corrupted. Also it may happen if you are running on windows server.

  3. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    It also happens when transient options are created automatically by some plugins and even by WordPress itself.

  4. simbian
    Member
    Posted 1 year ago #

    Hello and thanks for reply!

    Im on Linux, Litespeed web server, PHP 5.2.17, MySQL 5.5.34

    i tried with PHPMyAdmin and this is the result:

    http://img46.imageshack.us/img46/6215/0p0i.jpg

    for all tables it says: "note Table does not support optimize, doing recreate +..."

    i Googled and came to http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
    especially the paragraph referred to "For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE..."

    In PHPMyAdmin i checked and the type of WP Tables are InnoDB.

    I have other WordPress db istances that are type MyISAM and if i run the optimize sql query it works fine.

    So this is the "problem" and maybe why WP-OPTIMIZE doesn't affect.

    How i can do? Should i contact the web hosting or there is another SQL query i can run to optimize?

    thanks

  5. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    yeah innodb table types wont work.

    I don't have the solution for the moment.

    basically wpO uses the same thing as phpMyadmin.

  6. simbian
    Member
    Posted 1 year ago #

    ok and thanks for your support ruhanirabin!

  7. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    I am keeping my eye on this issue.

  8. James Roberts
    Member
    Posted 1 year ago #

    Any developments with this issue?

  9. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    @james-roberts , not yet. The alter table statement does not work always with innoDB tables.. not sure exactly why is that. So no solution for now.

  10. simbian
    Member
    Posted 1 year ago #

    after some Google searches i found that the optimization of Innodb tables is not a primary need, here is a clear discussion about

    http://dba.stackexchange.com/questions/55934/how-to-optimize-innodb-tables-in-mysql

  11. ruhanirabin
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks @simbian . I have seen that.. My point is .. it does work/does not work - randomly. So that is the reason I don't want to do it for inndoDB.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP-Optimize
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic