Re: [MRBS-general] VERY slow saves of entries

[Craig K. <cra...@gm...>]

in /var/log/apache2/error.log there are some " MRBS: Failed to acquire
exclusive database access, referer: http://...." but only 11 times, which
seems to be far too low.

hmmmmmm.
Craig


On Tue, Feb 28, 2012 at 9:49 PM, Campbell Morrison <
cam...@gm...> wrote:

> I suppose if all else fails you could start inserting some debug info in
> edit_entry_handler.php to find out what’s taking the time.   It sounds like
> it may not be the SQL query.****
>
> ** **
>
> Campbell****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Craig Knights [mailto:cra...@gm...]
> *Sent:* 28 February 2012 08:41
> *To:* mrb...@li...
>
> *Subject:* Re: [MRBS-general] VERY slow saves of entries****
>
> ** **
>
> OK tried that, no difference, didn't have them enabled, at least not in
> the config file.  I put that disable line in, since I don't want email
> support.****
>
> ** **
>
> Can't think of anything that has changed...  maybe a bigger load on the
> server's other function which is a webcam, but the server doesn't seem
> busy..  at all..   and it's still slow, even now, the network connection is
> just idling, the system load is low..****
>
> ** **
>
> I've just been playing with mysql's log slow queries feature, it caught
> one big 3s long SELECT from phpmyadmin, but not the mrbs save which took
> more than a minute.   I made up some dummy data and inserted it using
> phpmyadmin into the mrbs_entry table.  it was very fast.. tried it twice,
> both times very fast.****
>
> ** **
>
> I have noticed apache2 giving me a warning "waiting apache2: Could not
> reliably determine the server's fully qualified domain name, using
> 127.0.1.1 for ServerName"   so I'm going to investigate that.****
>
> ** **
>
> thanks very much!****
>
> Craig****
>
> ** **
>
> ** **
>
> On Tue, Feb 28, 2012 at 9:25 PM, Campbell Morrison <
> cam...@gm...> wrote:****
>
> I wonder whether it could have anything to do with the mail system.   Have
> you got email notifications turned on?    If so, you can try disabling them
> by setting****
>
>  ****
>
> $mail_settings['disabled'] = TRUE;****
>
>  ****
>
> in your config file.****
>
>  ****
>
> Has anything changed on your system in the last few days?****
>
>  ****
>
> Campbell****
>
>  ****
>
>  ****
>
>  ****
>
>  ****
>
> *From:* Craig Knights [mailto:cra...@gm...]
> *Sent:* 28 February 2012 00:18
> *To:* General purpose list (support/developers/users)
> *Subject:* Re: [MRBS-general] VERY slow saves of entries****
>
>  ****
>
> 1) myISAM, 2) 4063****
>
> On Tue, Feb 28, 2012 at 12:40 PM, John Beranek (MRBS Developer) <
> jbe...@us...> wrote:****
>
> On 27/02/2012 23:02, Craig Knights wrote:
> > In the last few days, when saving a new entry or editing an old one..
> > When I use the Save button, it greys out and takes around 1.5 minutes to
> > save.  Displaying of pages is generally acceptably fast.****
>
> Possibly important things to know:
>
> 1) Table engine, MyISAM or InnoDB?
> 2) Number of rows in mrbs_entry
>
> John.
>
> --
> John Beranek - MRBS Developer <http://mrbs.sourceforge.net/>
>
> To generalise is to be an idiot.
>  -- William Blake
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
> Want to unsubscribe: mailto:mrb...@li...
> ?subject=unsubscribe****
>
>  ****
>
>
>
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
> Want to unsubscribe: mailto:mrb...@li...
> ?subject=unsubscribe****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
> Want to unsubscribe: mailto:mrb...@li...
> ?subject=unsubscribe
>
>