Hello, Thanks for the idea.
At the current time, we do not add or features that are specific to a particular database unless it would make a dramatic improvement to Bacula, which I don't think applies here. If we were to do so, it would increase the support burden, which is already a bit overwhelming ... Best regards, Kern On Wednesday 04 June 2008 17:18:40 Jason A. Kates wrote: > 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,28 >379,28449,28525,28606,28687) | > > > Thanks -Jason ------------------------------------------------------------------------- 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
