On Tue, Oct 09, 2001 at 11:29:34PM -0400, Ryan Shrout wrote:
> Well, here are some quick stats on the server when its running:
> Key Reads/Key Requests = 0.000936 (Cache hit = 99.999064%)
> Queries/second = 129.574 (/hour = 466465.492)
> Slow Queries/second = 0.000 (/hour = 0.000)
> Uptime = 2 hr 49 min 23 sec
> Are there any drawbacks to using InnoDB or DBD? If they are really better,
> why aren't they always used?
InnoDB is considered "unstable" by some people. Going with InnoDB
also means you may lose some MySQLisms; like each table no longer being
represented as 3 easily transported files.
BDB, I'm not sure. Perhaps there are speed issues?
They're also not defaults*, which means that they need to be added
in through extra effort. Most people probably don't want to bother
until they absolutely have to.
* The MySQL-Max distribution uses InnoDB by default.
Michael Bacarella <mbac@stripped>
Technical Staff / System Development,
New York Connect.Net, Ltd.