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

2010-11-21 Thread Mikael Fridh
On Sat, Nov 20, 2010 at 9:24 AM, Mikael Fridh fri...@gmail.com wrote: 2010/11/17  c.kesch...@internet-mit-iq.de: SELECT /*!40001 SQL_NO_CACHE */ * FROM `File`; That's mysqldump, there is no SQL_NO_CACHE string anywhere in bacula source code. And... if I extend this half-assed answer a bit:

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

2010-11-20 Thread Mikael Fridh
2010/11/17 c.kesch...@internet-mit-iq.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 # u...@host: bacula[bacula] @ localhost [] # Query_time: 2793  Lock_time: 0  Rows_sent:

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

2010-11-18 Thread Mike Holden
Martin Simmons wrote: On Wed, 17 Nov 2010 17:30:33 +0100, C Keschnat said: 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 # u...@host: bacula[bacula] @ localhost [] # Query_time: 2793

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

2010-11-17 Thread C . Keschnat
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 # u...@host: bacula[bacula] @ localhost [] # Query_time: 2793 Lock_time: 0 Rows_sent: 127104387 Rows_examined: 127104387 use bacula;

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

2010-11-17 Thread Martin Simmons
On Wed, 17 Nov 2010 17:30:33 +0100, C Keschnat said: 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 # u...@host: bacula[bacula] @ localhost [] # Query_time: 2793 Lock_time: 0