Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+what\s+does\s+baculas\s+select\-query\s+for\s+mysql\s+look\s+like\?\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+what\s+does\s+baculas\s+select\-query\s+for\s+mysql\s+look\s+like\?\s*$/: 6 ]

Total 6 documents matching your query.

1. [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: C.Keschnat AT internet-mit-iQ DOT de; Date: Wed, 17 Nov 2010 17:30:33 +0100; Hi, I'm having problems with long running select statements (bacula 5.0.2). After activating mysql-slow-logs, I saw logs similar to [] 0 Rows_sent: 127104387 Rows_examined: 127104387 use bacula; SELE; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00271.html (12,992 bytes)
2. Re: [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: Martin Simmons <martin AT lispworks DOT com>; Date: Wed, 17 Nov 2010 19:26:18 GMT; It makes many different queries, but I doubt that is makes that one. It doesn't look like anything it needs to do. __Martin -- Beautiful is writing same markup. Internet Explorer 9 supports standard; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00274.html (13,091 bytes)
3. Re: [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: "Mike Holden" <bacula AT mikeholden DOT org>; Date: Thu, 18 Nov 2010 07:05:09 -0500; You will need to submit the query exactly as written anyway, which you haven't done. SELECT /*!40001 SQL_NO_CACHE */ * FROM `File`; SELECT SQL_NO_CACHE * FROM `File`; Note the "/*!40001" and the "*/"; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00294.html (14,379 bytes)
4. Re: [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: C.Keschnat AT internet-mit-iQ DOT de; Date: Thu, 18 Nov 2010 16:03:17 +0100; said: for process queries one. code, which is to help Hi, that's not it. It gets killed the same way with the exact same query: date && echo 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `File`;' | mysql; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00301.html (13,902 bytes)
5. Re: [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: Mikael Fridh <frimik AT gmail DOT com>; Date: Sat, 20 Nov 2010 09:24:54 +0100; 2010/11/17 <C.Keschnat AT internet-mit-iq DOT de>: That's mysqldump, there is no SQL_NO_CACHE string anywhere in bacula source code. -- Mikael -- Beautiful is writing same markup. Internet Explorer 9; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00331.html (12,541 bytes)
6. Re: [Bacula-users] what does baculas select-query for mysql look like? (score: 1): Author: Mikael Fridh <frimik AT gmail DOT com>; Date: Sun, 21 Nov 2010 09:26:26 +0100; And... if I extend this half-assed answer a bit: This mysqldump execution most likely comes from your catalog backup job. -- Mikael -- Beautiful is writing same markup. Internet Explorer 9 supports s; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2010-11/msg00335.html (12,469 bytes)

Current List: 1 - 6
Page: [1]