Support Forum

Simple:Press 6 Coding Questions

PHP memory/Mysql issue

PHP memory/Mysql issue

John Logsdon

Member

Free Members

Offline

Jun 16, 2012 - 6:21 am

After a weeks's running with about 200 members I have had a curious database access issue that traces back to SP.

Platform: Ubuntu 10.04, Mysql Ver 14.14 Distrib 5.1.63

php5 5.3.2-1ubuntu4.15 with Suhosin-Patch and eAccelerator. (memory_limit = 128M)

Wordpress version 3.3.2 (yes I know I should move to 3.4 but it's only been out few days!).

Apache/2.2.14 currently using mod_php .

Simple:Press version 5.1.1 with plugins admin-bar font-resize online plupload post-preview post-rating private-messaging quicktags-bbcode subscriptions tinymce-richtext watches

/var/log/syslog reported at 7:02 this morning:

WordPress database error MySQL server has gone away for query SELECT * FROM wp4_sfforums WHERE forum_rss_private=0 made by require, require_once, include, suffusion_content, do_action, call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require, the_content, apply_filters, call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include, sp_load_template, include, sp_AllRSSButton, spdb_table, spdb_select

followed by:

WordPress database error MySQL server has gone away for query UPDATE wp4_sftrack#015#012#011#011#011 SET notification='a:2:{i:0;i:1;i:1;s:22:"Invalid database query";}'#015#012#011#011#011 WHERE id=1540 made by require, require_once, include, suffusion_content, do_action, call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require, the_content, apply_filters, call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include, sp_load_template, include,

with the last message repeated lots of times then PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in [...] wp-includes/wp-db.php on line 1549

These message were repeated for about 50 minutes as people are finding the site very slow to load then a whole slew (about 450) of undefined variables are reported from the two files in wp-content/sp-resources/forum-themes/default/styles/.

This is a puzzle. The system showed no signs of running out of memory and was running other sites (except they probably slowed a bit) without problems. It had been running for about a week.

Can you suggest any fix? This is a new site that is already taking a lot of traffic so I want to make sure it is robust.

TIA

Yellow Swordfish

Glinton, England

SP Master

Offline

Jun 16, 2012 - 8:11 am

I think you need to go and repair your database.

MySQL tables really need to be optimised on a regular basis to stop what is called 'overflow' and the need for the engine to start to create temporary storage spaces. Failure to deal with this will eventually result in a dramatic slowdown in performance and data errors.

I would recommend you install the wp-dbmanager plugin that will allow you to run an optimisation of the db on a scheduled basis - say once a week. But it also has repair and check options you can use instantly.