ebollengier wrote: > > > 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... > >
In fact, it's 4seconds, here... JobId=15 files=20000 Insert takes 4secs for 200000 records JobId=16 files=50000 Insert takes 11secs for 500000 records JobId=20 files=200000 Insert takes 43secs for 2000000 records -- View this message in context: http://old.nabble.com/VirtualFull-mysql-query-blocks-other-jobs-for-a-long-time-tp28149748p28167844.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
