| [B]scoundrel wrote on Fri, 19 October 2007 00:58[/B] |
|
First of all, if you use in-memory db, you don’t really need innodb because the most useful feature there is reliability and in your case it has no advantages at all. |
Earlier he explained his reasons for using InnoDB.
| [B]scoundrel wrote on Fri, 19 October 2007 00:58[/B] |
|
As for tests, your approach is REALLY strange and I personally don’t see any reasons to test such configuration because even if we’d be able to show that it is really fast, no one would use such approach because mysql has its own in-memory db implementation for such needs. |
The only reason for using RAM disc instead of in-memory tables
I see is faster warm-up. Initialization. Data load. In case of
memory table there should be a great number of insert statements
(even if packed into one dump file). In case of RAM disc just copy few files.