#2224: Support MySQL partitioning
------------------------+----------------------
Reporter: dustin | Owner:
Type: enhancement | Status: new
Priority: major | Milestone: 0.9.+
Version: 0.8.2 | Keywords: database
------------------------+----------------------
A big Buildbot install dumps massive amounts of data into the DB, and its
"normal" pruning process is just DELETE statements, which don't
necessarily free up space, and at any rate can leave tables badly
fragmented.
A DBA will tell you that the fix is to partition the data by time, and
simply drop partitions when they are no longer needed. No fragmentation,
no delays on pruning, no muss, no fuss.
I think that this is *primarily* something that would be done by a skilled
DBA without modification of Buildbot itself, but let's figure out if
Buildbot can make this easier or if there are other modifications that
could help.
--
Ticket URL: <http://trac.buildbot.net/ticket/2224>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
