Bacula-users

Re: [Bacula-users] what does baculas select-query for mysql look like?

2010-11-20 03:28:44
Subject: Re: [Bacula-users] what does baculas select-query for mysql look like?
From: Mikael Fridh <frimik AT gmail DOT com>
To: C.Keschnat AT internet-mit-iq DOT de
Date: Sat, 20 Nov 2010 09:24:54 +0100
2010/11/17  <C.Keschnat AT internet-mit-iq DOT de>:
> Hi,
> I'm having problems with long running select statements (bacula 5.0.2).
> After activating mysql-slow-logs, I saw logs similar to
>
> # Time: 101117 11:32:56
> # User@Host: bacula[bacula] @ localhost []
> # Query_time: 2793  Lock_time: 0  Rows_sent: 127104387  Rows_examined:
> 127104387
> use bacula;
> SELECT /*!40001 SQL_NO_CACHE */ * FROM `File`;

That's mysqldump, there is no SQL_NO_CACHE string anywhere in bacula
source code.

--
Mikael

------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users