We are using Elmah on production to log problems in our web applications. Elmah logs are stored in a MySql table which structure is a slightly modified version of the elman_error table from the original Elmah script (I changed the engine to InnoDB and added partitioning over TimeUTC column):
CREATE TABLE IF NOT EXISTS `elmah_error` (
`ErrorId` CHAR(36) NOT NULL ,
`Application` VARCHAR(60) NOT NULL ,
`Host` VARCHAR(50) NOT NULL ,
`Type` VARCHAR(100) NOT NULL ,
`Source` VARCHAR(60) NOT NULL ,
`Message` VARCHAR(500) NOT NULL ,
`User` VARCHAR(50) NOT NULL ,
`StatusCode` INT(10) NOT NULL ,
`TimeUtc` DATETIME NOT NULL ,
`Sequence` INT(10) NOT NULL AUTO_INCREMENT ,
`AllXml` TEXT NOT NULL ,
PRIMARY KEY (`Sequence`, `TimeUtc`) ,
INDEX `IX_ErrorId` (`ErrorId`(8) ASC) , -- UNIQUE can't be created if it does not include all partition columns
INDEX `IX_ELMAH_Error_App_Time_Seql` (`Application`(10) ASC, `TimeUtc` DESC, `Sequence` DESC) ,
INDEX `IX_ErrorId_App` (`ErrorId`(8) ASC, `Application`(10) ASC) )
ENGINE InnoDB DEFAULT CHARACTER SET latin2
partition by range columns(`TimeUtc`)
(
partition before20130719 values less than ('2013-07-19 00:00')
);
