OS File types w.r.t DB objects
=========================
On creation of every table (engine=InnoDB):
.frm (contains table defintion)
.ibd (contains table data)
On creation of procedure/function :: No separate OS file been generated with that name.
On creation of view:
.frm file been created.
On creation of trigger:
.TRN (one file per Trigger)
.TRG (per table that has triggers)
Note:
- On INSERT/UPDATE/DELETE - only .ibd file get changes.
- On ALTER table: Adding/drop column/index - both .ibd/.frm files gets changed.
- Definition of procedure/function been stored at mysql.PROC.MYI and mysql.PROC.MYD
=========================
On creation of every table (engine=InnoDB):
.frm (contains table defintion)
.ibd (contains table data)
On creation of procedure/function :: No separate OS file been generated with that name.
On creation of view:
.frm file been created.
On creation of trigger:
.TRN (one file per Trigger)
.TRG (per table that has triggers)
Note:
- On INSERT/UPDATE/DELETE - only .ibd file get changes.
- On ALTER table: Adding/drop column/index - both .ibd/.frm files gets changed.
- Definition of procedure/function been stored at mysql.PROC.MYI and mysql.PROC.MYD
No comments:
Post a Comment