No joy for me. MySQL runs hours with 100% processor with even a small job with 
some tens of files to process.

MYSQL Admin shows that it's processing command:

INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM 
batch) 
AS a WHERE NOT EXIST (SELECT Name FROM Filename AS f WHERE f.Name = a.Name)

Hmm?

Isnt

    "SELECT a.Name FROM (SELECT DISTINCT Name FROM batch) AS a" 

the same as

    "SELECT DISTINCT a.Name FROM batch AS a" 

???

What is this batch?





So I downloaded the source. sql_create.c says:

#ifdef HAVE_BATCH_FILE_INSERT
ok = db_sql_query(mdb,
"CREATE TEMPORARY TABLE batch ("
"FileIndex integer,"
"JobId integer,"
"Path blob,"
"Name blob,"
"LStat tinyblob,"
"MD5 tinyblob)",NULL, NULL);
.....
#else /* ! HAVE_BATCH_FILE_INSERT */
.....


blobs? BLOBS!!!

Arrrgh.

Is this #ifdef HAVE_BATCH_FILE_INSERT used in ALL production code, or is it 
only on my just downloaded backports.org -version?

Have to try to compile the source and see. I don't believe that could work. It 
does not in my server, at least!

I may be wrong, but this is hacking on a hard spot!


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users