Re: [Bacula-users] what does baculas select-query for mysql look like?
2010-11-20 03:28:44
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
|
|
|