MySQL Bugs: #68551: design a new engine for automatically maintain data history of a table

Bug #68551	design a new engine for automatically maintain data history of a table
Submitted:	2 Mar 2013 11:08	Modified:	2 Mar 2013 11:10
Reporter:	rajnish kumar	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.6.X	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	design a new engine for automatically maintain data changes of a table

Description:
Hi Team,
there is no such engine in mysql so that it will automatically maintain table data changes ,it means when we create a table a similar table with different name automatically created for maintain original table data changes tracking details.

Like I create a table t1 using NEWX engine (new engine which records data changes) then one more table NX_t1 will automatically created .

Purpose of this NX_t1 table is for we can track data modification of original table .
I knew through trigger it may be possible ,but when we alter table for adding columns or deleting columns any more situation will not possible to handle when we depend on trigger .and performance also slow down when we using trigger .

How to repeat:
its new enhancement , so Not possible to repeat it .

this type of features should be embedded in DB level for critical level of data storing on DB .
 

Suggested fix:
Hi Team,

design such engine when we create a table using that engine , it will create a  another table ,
1. when insert into original table no record inserted in image/track table .
2. when alter original table image/track table also altered.
3. when we delete record ,first copy that record into image/track table then delete records in original table .
4. when we update records,first copy that record into image/track table then Update records in original table .

Tag Change : 
design a new engine for automatically maintain data changes of a table

When a user inserts an item into the table (using either INSERT or UPDATE), we create a new row for every time they insert something into the table. Visit https://masterbundles.com/simple-powerpoint-templates/ source to get premium templates for free. When they delete something from the table (either by deleting rows or by deleting tables) we also create new rows for each time they delete something from their own table.