Graham Keeling wrote:
>
> On Wed, Apr 07, 2010 at 08:22:09AM -0700, ebollengier wrote:
>> I tweaked my test to compare both queries, and it shows no difference
>> with
>> and without base job part... If you want to test queries on your side
>> with
>> your data, you can download my tool (accurate-test.pl) on
>> http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/docs;a=tree;f=docs/techlogs;hb=HEAD
>>
>> If you can tweak my script to reproduce your problem, i would be able to
>> fix
>> things.
>>
>> http://old.nabble.com/file/p28166612/diff-with-without-basejob.png
>
> I'm currently running your script to generate the test database. I think
> that is going to take a long time, so I'll leave it overnight.
>
>
This is your first problem, on my server (just a workstation), it takes less
than 10s to add 200,000 records...
>
>
> Meanwhile (unless I misunderstand), I think that your graph is labelled
> strangely.
>
> When I'm generating the file records, I get this:
>
> ...
> JobId=10 files=200000
> Insert takes 445secs for 2000000 records
> ...
> JobId=13 files=20000
> Insert takes 54secs for 200000 records
> ...
>
>
> So, JobIds 10 + 13:
> 220000 files
> 2200000 records
>
> Your script says:
> do_bench("10,13", 2200000);
> This is obviously the records number.
>
> Your graph uses this bigger number and labels it 'Files'.
>
The accurate query on jobid=10,13 will work on 2,000,000 + 200,000 files
(this is
the argument), as each filenames are different, you can expect to retrieve
2,2M files.
It's quite possible that it miss a *10 mutiplication somewhere in debug
messages (I insert files 10 by 10)
Bye
--
View this message in context:
http://old.nabble.com/VirtualFull-mysql-query-blocks-other-jobs-for-a-long-time-tp28149748p28167751.html
Sent from the Bacula - Users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|