[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] Alternative DB proposal


Hello,

Could you summarize the difference in your schemas.

>From what I am seeing it looks like your first test that ran 39 hours is a 
standard Bacula File table more or less, and the second test NEW DB that ran 
35 hours is a standard Bacula File table with additional fields and produces 
a smaller size.

If that is true, then I don't understand the timing differences.

Regards,

Kern



On Tuesday 14 October 2008 09:22:44 Yuri Timofeev wrote:
> Hi
>
> 2008/10/7 John Huttley <John@xxxxxxxxxxxxxxxxxx>:
> > Hi
> > My first test are complete.
> > To aid in getting all the questions/answers and results in one place,
> > I've made a wiki entry.
> >
> > http://wiki.bacula.org/doku.php?id=wiki:playground
>
> My first test are complete. ;)
>
> Summary:
>
> MySQL, ProLiant DL180G5, CentOS 5.2
>
> 1. Batch inserts 10M unique! records in table 'File' (DB schema not
> changed) : 39 hours (23+16), DB file size 15,4 Gb
> 2. Batch inserts 10M unique! records in table 'File' (NEW DB schema
> see also create_mysql_test2.sh) : 35 hours (19+16), DB file size 15,2
> Gb
>
> Source code attached.
>
> Please note that the length of time (16 hours) insert records from the
> table 'batch' to the table 'File' the same.
> This indicates the stability of results.
>
>
>
>
>
> Full report:
>
> # ./test
> Date: Oct 10 2008 11:27:37
> Host: Localhost via UNIX socket
> Use database: 'bacula_test'.
> Temporary table 'batch' created.
> Start filling tables 'batch'(temporary), 'Path', 'Filename' ...
> End.
> 10000000 records inserts.
> *** CPUs time used : 375.880000
> *** Elapsed time (wall clock) : 85334.000000
>
> Start inserts from temporary table 'batch' to 'File' ...
> End inserts to 'File' ...
> *** CPUs time used : 0.000000
> *** Elapsed time (wall clock) : 58838.000000
>
>
>
>
> # ./test2
> Date: Oct 10 2008 11:27:37
> Host: Localhost via UNIX socket
> Use database: 'bacula_test2'.
> Temporary table 'batch' created.
> Start filling tables 'batch'(temporary), 'Path', 'Filename' ...
> End.
> 10000000 records inserts.
> *** CPUs time used : 384.650000
> *** Elapsed time (wall clock) : 71670.000000
>
> Start inserts from temporary table 'batch' to 'File' ...
> End inserts to 'File' ...
> *** CPUs time used : 0.000000
> *** Elapsed time (wall clock) : 58564.000000



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.