Database size has increased after optimization !

  • Resolved rom174

    (@rom174)


    6 years, 9 months ago

    Hello team,

    I just run an optimization after backing up my database.
    I checked optimizing tables, removing revisions and drafts (+4000), removing spams, removing expired transients and metadatas.
    Then I re backed up the database and it increased by 37mo (from 123mo to 160mo) !
    When I compare both files in text editor, I can see that there is a lot of new lines.

    Finally, I reloaded a page with and without the cache enabled but I didn’t see any change in the loading time compared to the loading time before the optimizations. So, I wonder if, even with decreased size of the database, I would have seen better performances.

    So, now I am a bit confused about the purpose of the optimizations offered by wp-optimize.
    Can you let me know what I missed and what I did wrong/misunderstood ?

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • Marc Lacroix

    (@marcusig)

    6 years, 9 months ago

    Hello,

    When you say

    When I compare both files in text editor, I can see that there is a lot of new lines.

    , what are those new lines?

    The WP-Optimize Database optimisation will add a few records to the options table to record what it did and when, but it will not add anything to your other WP tables.

    Regarding the cache, a page needs to be visited once after enabling cache. This first visit will save that page in the cache. So if you enabled cache and refreshed that page once, you wouldn’t get a cached version of it.

    If you still have caching enabled, you could share a link here and I’ll confirm what the difference is.

    Thread Starter rom174

    (@rom174)

    6 years, 9 months ago

    Hello @marcusig

    Thank you for this quick reply.

    When you say

    When I compare both files in text editor, I can see that there is a lot of new lines.

    , what are those new lines?

    It is content posts for the huge majority. I guess that even a few addition from wp-optimize won’t give an increase of 37mo.

    Regarding the cache, a page needs to be visited once after enabling cache. This first visit will save that page in the cache. So if you enabled cache and refreshed that page once, you wouldn’t get a cached version of it.

    Yes of course, not sure if we are talking about the same cache. I am talking of the browser cache enabling and disabling it from the button of the inspector.

    Thread Starter rom174

    (@rom174)

    6 years, 9 months ago

    Hello @marcusig
    Sorry, but I would need to know why this happened and if I have to worry about that weird growth.
    Do you now where those 37mo are coming ?
    It seems that @wb1968 reported the same issue with an older version of wp-optimize ?
    But there is no explaination about the issue in the thread.

    Why all those lines have been added in my database?
    What was the error ?
    Is there a compatibility issue ?
    Do I need to restore the database ?

    Thank you

    Marc Lacroix

    (@marcusig)

    6 years, 9 months ago

    Hello,
    As I said earlier, WP-Optimize does not add anything to the database, and if it does that would be a bug.

    You could have an increase in size on the database when running the optimisations because the OPTIMIZE TABLE command doesn’t necessarily reduce the size, but optimises for performance. BUT, this shouldn’t make a difference to a backup size.

    I can’t tell why those lines were added, because I don’t know what those lines are.

    Do you have samples of the extra lines you could show us?

    If you are able to restore your database without loosing data, you could look at the row numbers in the tables in both versions of the database, to see if they are different.

    If this is not conclusive, would you be able to send a request on this form: https://getwpo.com/ask-pre-sales-question/, including links to the before and after backup files of your database (not here, as this is a public place).
    If you add the URL of this topic, and mention me, it’ll find its way to me. Don’t worry about the “Yes, I am asking a pre-sales question” checkbox (it has to be ticked to submit the form, but if you mention this URL, it won’t get deleted!).

    That way I would be able to look closer and see where the issue comes from.

    • This reply was modified 6 years, 9 months ago by Marc Lacroix.
Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database size has increased after optimization !’ is closed to new replies.