What plugins are you using?
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?
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.
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.
