>>>>> 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 Rows_sent: 127104387 Rows_examined: > 127104387 > use bacula; > SELECT /*!40001 SQL_NO_CACHE */ * FROM `File`; > > I wanted to test some suggestions I read in bug reports and for that I > copied the bacula server to play with it. I tried running > > date && echo 'SELECT SQL_NO_CACHE * FROM `File`;' | mysql -uroot -p bacula > >/dev/null && date > > but the process gets killed with "Out of memory: kill process 16377 > (mysql)..." after some time. Can anyone tell me how bacula queries the > database?
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 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
