Hello everyone ! Please correct me if i'm wrong, but i did notice that all temporary batch-insert tables created by bacula are disk-based.
After digging a bit on why this happens (starting with the mysql-parameters) i found the following bit that explained it quite clearly. >From http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html -> MEMORY tables cannot contain BLOB or TEXT columns. And here is the Table-Creation in the bacula-source (src/cats/sql_create.c): "CREATE TEMPORARY TABLE batch (" "FileIndex integer," "JobId integer," "Path blob," "Name blob," "LStat tinyblob," "MD5 tinyblob)",NULL, NULL); Of course - so bacula batch-insert tables are never going to be memory tables because of the blob columns. If those tables have to be blobs there is nothing we can do about it - but do they really have to be ? Does batch-inserts still make it faster even though the tables are disk-based ? (I did not test that). I also found this in patches/testing/batch-insert.readme and am curious if it is still valid: --- you MUST change some indexes. mysql) ALTER TABLE Filename DROP INDEX Name; ALTER TABLE Filename ADD UNIQUE (Name(255)); ALTER TABLE Path DROP INDEX Path; ALTER TABLE Path ADD UNIQUE (Path(255)); --- But mysql_create_tables.in (again in src/cats/) says: --- CREATE TABLE Filename ( FilenameId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Name BLOB NOT NULL, PRIMARY KEY(FilenameId), INDEX (Name(255)) ); CREATE TABLE Path ( PathId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Path BLOB NOT NULL, PRIMARY KEY(PathId), INDEX (Path(255)) ); --- I`m pretty sure that the bacula-rpm (that has batch-insert enabled) does not create the database in the correct way for batch-inserts if those indexes are still necessary. I`m also having a Problem with my Director hanging sometime in the night. It just stops doing anything and you cannot connect to the console. I don't think i can get a Traceback from this because the director does not actually crash. It just sits there doing nothing. I am still analysing this though - if you have any tips on how i can get some useful output (i did set the debug-level for SD & Dir to 200 today and hope to see something tomorrow) please tell. Best regards Daniel Holtkamp -- ............................................................. Riege Software International GmbH Fon: +49 (2159) 9148 0 Mollsfeld 10 Fax: +49 (2159) 9148 11 40670 Meerbusch Web: www.riege.com Germany E-Mail: holtk...@riege.com --- --- Handelsregister: Managing Directors: Amtsgericht Neuss HRB-NR 4207 Christian Riege USt-ID-Nr.: DE120585842 Gabriele Riege Johannes Riege ............................................................. YOU CARE FOR FREIGHT, WE CARE FOR YOU ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
