Re: [Bacula-users] Proplem upgrading from 1.38 to 2.2
2008-05-17 04:33:18
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
|
|
|