• Hi guys.

    I have this strange problem, it seems that my wp_options.sql every day gets around 40 to 50 mb more than the real size. Sometime goes down when i optimise the all database, but most of the time stays the same .

    What can i do to prevent this for happening please ?

    Regards

Viewing 8 replies - 1 through 8 (of 8 total)
  • What plugins are you using?

    Thread Starter shqipoobserver

    (@shqipoobserver)

    i use

    MHR-Custom-Anti-Copy
    Facebook, Twitter & Google+ Social Widgets
    Easy Related Posts
    NextGEN Gallery by Photocrati
    Quick Adsense
    WP Super Cache

    You used the word ‘overloaded’
    The size of the database isn’t usually an issue so is that word being used in an error message?

    Thread Starter shqipoobserver

    (@shqipoobserver)

    The main problem is that sql table Option.sql from its original size of 5 mb goes to 60 mb, and this slow my website down, When i optimize sql goes down to its original size .

    It will not slow the site down by being large. I have worked on sites that have databases well over 200mb and they work well.

    What might slow it down though is the number of queries being done. Core WP will be fine which is why I wondered about plugins.

    Are you able to deactivate them one at a time to see which might be doing it?

    Or

    When the table is large export just that table using phpmyadmin and open it in a text editor to see what it is adding?

    Almost certainly one of your plugins is adding stuff to it, because WP wouldn’t do that by itself. Have you an example of the kind of entries being added to the wp_options table?

    60Mb is a hell of a lot for that table.

    Thread Starter shqipoobserver

    (@shqipoobserver)

    the biggest mystery is that i am trying to see whats inside and is nothing just an empty space . i turnd off plugins and after few hours it was same 55 mb and now i understand that is not plugin who cause the problem

    I would not worry about the size.

    You could have a database table size of 100mb and one of 10mb and yet the 10mb could cause more problems because of the queries being run on it. It being big really is not an issue.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘wp_options.sql Overloaded what can i do ??’ is closed to new replies.