2
votes
1answer
23 views

wp_options table value

I am trying to understand a wordpress behaviour. When I add a tag in the admin panel mysql does a sequence of queries. Essentially: update wp_terms update wp_term_taxonomy and udate wp_options with ...
0
votes
2answers
30 views

WP_Options high

I have a site where the options_id field in the wp_options table have grown very, very large. After a month and a half after the installation the auto_increment value is now at over 10 million. ...
1
vote
1answer
36 views

Does auto_load to 'no' in wp_options improve performance

I am trying to improve the performance of a wordpress based blog. I am looking at wp_options table and am thinking to set the column auto_load to 'no'. Does it have any side-effect on the site ...
0
votes
1answer
32 views

Image link issues after importing a database backup to my local web server

I am pretty new in WP (I came from Joomla) and I have the following problem trying to import an old WP blog (made using WP 3.5) on my local web server. I have put the old blog foder into my www ...
0
votes
1answer
28 views

How to find an option in the database?

As far as I can tell, the plugin that I'm using is saving options to the wp_options file: ### New global settings container, will eventually be the only one! $cformsSettings = ...
0
votes
2answers
138 views

Accidentally deleted active_plugins portion of the wp_options DB table

Ok, so I'm pretty sure I'm screwed here, because I do not have a database backup, but I figured I'd ask just in case. Within PhpMyAdmin, I meant to just go to the wp_options table and empty out ...
0
votes
1answer
175 views

accessing wordpress serialized data outside wp

I've never worked with serialized data... I need a little help with how to load "text" widgets title and content in php script outside wordpress... my script just connects to database (including ...
4
votes
1answer
374 views

What is the advantage of the wp_options design pattern?

As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key. We ...
3
votes
2answers
2k views

How to change option recently_edited?

WP recently_edited option can be very useful - it tracks last 5 files that you've made changes to. Only problem is - well, that's all, 5 files. What if I've been made numerous changes to Wordpress ...
1
vote
2answers
2k views

clean wp_options table unused rows

In my Wordpress Blog site i have installed too much plugin and remove also many plugins. In database table "wp_options" size increases approx 13MB and there are many rows which are unused at this ...
1
vote
5answers
6k views

Will it break my site if I delete all transient records in wp_options table?

My site currently has an outrageous 500k+ transient records in the wp_options table. This causes the table to be crashed frequently and so be my site. I thought transient records will all expired ...
0
votes
1answer
765 views

Should I remove transients from the wp_options table?

I have been doing some cleaning up in the database of one of my WordPress installs, and I noticed that the wp_options table was about 2.1mb, and had 1200 rows. I've gotten it down to around 800 rows, ...
0
votes
1answer
2k views

store simple data in get_option()

I am trying to store simple data, a few links inside wp_options. Basically using the following way: update_option( 'simple_links', '<a href="">link 1</a>' ); my question is if it is ...
0
votes
2answers
419 views

Efficiency of wp_options vs a new table

I'm building a WordPress theme framework, that will likely have many options as development progresses. I found a related question: When is it appropriate to create a new table in the WordPress ...
1
vote
2answers
209 views

Help running a MySQL query to update all wp_#_options tables in a Multisite install

I'd like to run a query through my WordPress database that updates the blog_public values on all individual sites. I'm stuck on how to have the statement look for wp_2_options, wp_3_options, etc. I ...
3
votes
2answers
3k views

Transient RSS feeds in wp_options not removed automatically?

I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while. So I ran: delete from `wp_options` where `option_name` like '_transient_timeout_rss%' delete from ...