'Convert a relational (InnoDB) database to an in-memory (Memory) database in MySQL
I am trying to perform a couple of operations on my databases (Disk-based & In-memory) such as removing trailing spaces, joining ordering, aggregate, filter etc. Considering that I have obtained a disk-based database with dummy data is there a way to copy this data into an In-memory database so I can be able to compare the different speeds of the operations between the two databases in MySQL? P.s this is for my research. TIA
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|