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;
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?
------------------------------------------------------------------------------
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