id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
12451	Playback start taking ages due to slow loading of the seek table from a heavily fragmented MyISAM table	Karl Egly	Karl Egly	"http://www.psce.com/blog/2012/07/09/data-fragmentation-problem-in-mysql-myisam/
hints that fragmented MyISAM tables can have very bad performance once the table gets to big for the memory caches.
On a backend that records and deletes recordings this will happen to the seek table.
There is a statement for live defragmentation on a running system (even in parallel to recordings)
{{{
ALTER TABLE recordedseek ORDER BY chanid, starttime;
}}}
attached is a proof of concept patch that adds the defragmentation to the daily database maintenance job after the removal of stale entries in the recordedseek table. As the query runs more then four minutes on my backend I'd prefer some testing by others before I commit this as is.
"	Patch - Feature	closed	minor	0.27.6	Contributed Scripts & Apps	Unspecified	medium	Fixed			0