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 ([EMAIL PROTECTED])
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
