MarkLeith/dbahelper — pull request #3 by greenlion (2013-09-29 07:35:01+00:00)
Title: Add support for capturing P_S data into snapshot tables with a MySQL event.

Here is code for generative a (somewhat massive) event which grabs a consistent snapshot of all the P_S tables periodically. The results are dropped into a 'psmv' schema which contains the same table names as the P_S schema, but all tables contain two extra columns:
ts datetime(6)
serverid int(11) unsigned