|
[Bacula-users] what does baculas select-query for mysql look like?
2010-11-17 11:59:58
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
# 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?------------------------------------------------------------------------------
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
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Bacula-users] what does baculas select-query for mysql look like?,
C . Keschnat <=
|
|
|
