mev

If I deactivate everything, no errors.

Trying to deactivate a page, it seems to wait forever with a please wait message.

I haven’t done many customizations so may delete the entire plugin and then reinstall.

Thanks for your prompt attention to this. It works well now. I have updated my rating.

Deleting all the
_displayed_gallery_*
_displayed_galleries_*
_transient_timeout_*
_transient_[0-9a-f]*
entries brings my wp_options table to only 529 entries and drops the amount of memory used (with NextGen 1.9.13) to be 27.62 MB or 31%. It also fixes symptoms I observed with SimplePie giving out of memory errors.

I don’t know if 2.0.40 was where this started or whether WordPress 3.8 + 2.0.40 was what finally pushed things over the edge with all this junk inserted earlier in the 2.0.* release. However, will stay with 1.9.13 for now and mark this as resolved.

I am still copying over the web site to separate test domain.

However, in process of copying the database one thing very quickly jumps out:
– The text size of my “wp_options” table is 22MB of characters and has autoincremented to 3523730 entries. It is almost entirely filled with entries with the following types of names

* displayed_gallery_rendering_<hash>
* _transient_timeout_<hash>
* displayed_galleries_<hash>
* _transient_<hash>

In fast there are so many of these names that the table will not import in phpmyadmin (at least in one try).

So this leads me to a few questions:
1. What is the purpose of those entries?
2. Do I need all these entries for proper functioning of NextGen Gallery – or can I delete them all before bring in the table?
3. Is there an “options leak” where NextGen gallery is creating space in a MySQL table and never cleaning up?

The hypothesis I am going on now is that NextGen has had some versions that “leaked” all these entries which polluted my wp_options table and consumed a huge amount of memory. I don’t know if this is still in the NextGen code but having a few photos and albums and a web site with a few hits meant this accumulated to point where the trash is polluting the web site. Any thoughts on this or more information?

Here is the mixed data I have been able to measure so far:

1. phpinfo() – tells me I have a total of 90M of memory available.

2. I also added “define(‘WP_MEMORY_LIMIT’, ’90M’);” to my wp-config.php file so wordpress and phpinfo() are both consistent on the amount of memory used.

3. I used the WP-Memory-Usage to tell me the amount of memory used in my Dashboard. This tells me the following values:
– With NextGen Gallery disabled = 34.57 MB or 38%
– With NextGen Gallery 1.19.13 = 36.37 MB or 40%
– With NextGen Gallery 2.0.40 = 40.95 MB or 46%
so this definitely tells me 2.0.40 is using more memory though none of these amounts should be close to my limits. For example, it seems to suggest that NextGen Gallery 2.0.40 is using triple the memory of 1.9.13.

4. My blog is not particularly large, but following are the counts:
– 192 posts
– 85 comments
– 38 pages
– 766 images
– 13 galleries
– 2 albums
Until I emptied my spam folder, I did have 8861 spam comments though emptying that folder didn’t seem to change things.

5. Potentially un-related but I also have one other memory related message show up on the dashboard. While displaying WordPress News, it gives

Warning: xml_parse() [function.xml-parse]: Memory allocation failed : growing buffer in …/wp-includes/SimplePie/Parser.php on line 154

This appears regardless of which configuration of NextGen gallery I use.

6. At this point reverting back to 1.9.13 addresses at least the symptoms so I’m going to keep my main site running that. I prefer not to give out credentials to this site or have it be a further testbed but if I get some time next weekend I’ll see if I can backup and create a copy that could be examined for testing.

I have looked at list of conflicting plugins and stopped W3 total cache. I also tried selective turning off, though tougher to turn everything off on a live site.

Also my permalinks are “Day and Name” instead of default, but toggling this didn’t seem to help.

List of plugins enabled:
Askimet
Broken Link Checker
Calais Auto Tagger
Display Posts Shortcode
Exec-Php
Geo Mashup
Google AJAX Translation
Google Map Link
Homepage Canonical Link
iFrame
List Category Posts
Multi-Level Navigation
NextGEN Gallery
Online Backup for WordPress
ProgPress
Quotes Collection
SABRE
Simple Google Sitemap XML
Simple Page Ordering
Subscribe Connect Follow
Tweet My Post
Ultimate Google Analytics
W3 Total Cache (turned off and flushed)
WP-Contact Form
WP-Cron Control
wp-google-drive
WP-Memory-Usage
WP-Table-Reloaded
WP-Filter Post Category
WP RSS Aggregator
wp SubPages redirect
YouTube Shortcode