Saturday, 28 September 2013

Why Memory Engine is much larger than InnoDB engine store?

Why Memory Engine is much larger than InnoDB engine store?

I have a table stored about 100,000 rows data in InnoDB engine. I just
copy the data to a memory engine table, but I find that the size of the
new one is much large than orignal table. Why?
| Rows | Engine | Size |
| 96702 | Memory|741MB|
|96952|InnoDB|28MB|
WHY?

No comments:

Post a Comment