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

[Bacula-devel] Thought as to possible catalog enhancement.


If this feature request isn't in the correct format please let me know.

I was looking at the  mysql documentation on partitioning and it appeared to me that if the File table is able to be partitioned by JobId this will save a lot of time doing deletes as the old jobs are pruned they partitions could just be dropped.  (This would only work with Mysql >= 5.1)

http://dev.mysql.com/doc/refman/5.1/en/partitioning.html

show  full processlist;
+-----+--------+-------------------------+--------+---------+-------+----------+-----------------------------------------------------------------------------------------------------------------------------------------+
| Id  | User   | Host                    | db     | Command | Time  | State    | Info                                                                                                                                    |
+-----+--------+-------------------------+--------+---------+-------+----------+-----------------------------------------------------------------------------------------------------------------------------------------+
|  78 | jkates | localhost               | bacula | Query   |     0 | NULL     | show  full processlist                                                                                                                  |
| 101 | bacula | localhost               | bacula | Query   | 14880 | updating | DELETE FROM File WHERE JobId IN (27131,27478,27688,27758,27825,27892,27959,28026,28107,28175,28243,28311,28379,28449,28525,28606,28687) |


Thanks -Jason
-- 
----------------------------------------------------------------------------
Jason A. Kates (jason@xxxxxxxxx) 
Fax:    208-975-1514
Phone:  212-400-1670 x2
============================================================================

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.