On 2013-04-25 16:33, Iain Mckay wrote:
> We want to archive the data for two reasons:
>
> 1. To pinpoint what pages misbehave and some useful information on where they are misbehaving (certain operations taking too long/too much memory).
> 2. To provide historical performance data.
We do either of those using RRD - we have a lot of graphs here.
Of course, if there is some kind of data that isn't present on some graph, it's lost and cannot be restored.
> The storage requirements are a non-issue for us we just wanted to know if there was a way to persist the data. Either by storing it in one massive
>table (with the performance issues you noted) or by archiving them to another longer term table where performance isn't an issue.
I've heard of some people periodically copying the data to some other tables (MyISAM or InnoDB probably).
--
Wbr,
Antony Dovgal
---
http://pinba.org - realtime profiling for PHP