List:General Discussion« Previous MessageNext Message »
From:Michael Bacarella Date:October 10 2001 3:58am
Subject:Re: Last try guys! What is with the Spawning processes??
View as plain text  
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.
Thread
Last try guys! What is with the Spawning processes??Ryan Shrout10 Oct
  • Re: Last try guys! What is with the Spawning processes??Dan Nelson10 Oct
  • Re: Last try guys! What is with the Spawning processes??Ryan Shrout10 Oct
    • Re: Last try guys! What is with the Spawning processes??Dan Nelson10 Oct
      • Re: Last try guys! What is with the Spawning processes??David Turner10 Oct
      • Re: Last try guys! What is with the Spawning processes??Jeremy Zawodny10 Oct
    • Re: Last try guys! What is with the Spawning processes??Michael Bacarella10 Oct
      • Re: Last try guys! What is with the Spawning processes??Jeremy Zawodny10 Oct
  • Re: Last try guys! What is with the Spawning processes??Fournier Jocelyn [Presence-PC]10 Oct