>>>>> 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
> # 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`;
> 
> 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users