Martin Simmons wrote:
>>>>>> 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
>
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 "*/" in the original code, which is
omitted in the second version? With my experience of Oracle, that
looks like an "execution hint", in other words a directive to help
the database choose the most efficient way of retrieveing the data.
It's a specially formed comment, hence the /* ... */, so you either
need to include the entire comment, or omit it entirely, but you
have included the SQL_NO_CACHE part, and omitted the rest, which is
probably causing some weird error in the database.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
------------------------------------------------------------------------------
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
|
