List:General Discussion« Previous MessageNext Message »
From:Fournier Jocelyn [Presence-PC] Date:October 10 2001 8:55am
Subject:Re: Last try guys! What is with the Spawning processes??
View as plain text  
I confirm the compile-pentium script in MySQL-4.0 use InnoDB by default now.

Jocelyn Fournier
Presence-PC

----- Original Message -----
From: "Jeremy Zawodny" <jzawodn@stripped>
To: "Michael Bacarella" <mbac@stripped>
Cc: "Ryan Shrout" <mysql@stripped>; <mysql@stripped>
Sent: Wednesday, October 10, 2001 8:04 AM
Subject: Re: Last try guys! What is with the Spawning processes??


> On Tue, Oct 09, 2001 at 11:58:19PM -0400, Michael Bacarella wrote:
> > 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.
>
> Let's call it "nearly stable" :-)
>
> I've got an application I'm planning to build on InnoDB next week.
> It'll be a fairly heavy update system that gets pounded during the
> day.  I'm doing it after having heard the positive experience that
> others have had with InnoDB.
>
> And if all goes well, the application will be live and running in
> production by the end of the week.
>
> > Going with InnoDB also means you may lose some MySQLisms; like each
> > table no longer being represented as 3 easily transported files.
>
> Indeed.
>
> > BDB, I'm not sure. Perhaps there are speed issues?
>
> Yeah, BDB is probably going to become the ugly stepchild of MySQL
> table handlers.  It's not really seeing active development, and InnoDB
> will probably easily handle 95% of the cases that people might look to
> BDB for.
>
> > 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.
>
> In MySQL-Max they are, but you knew that. :-)
>
> And in MySQL 4.0, I believe InnoDB will be compiled in by default.
> (At least I believe that's what Monty said a while back.)
>
> Jeremy
> --
> Jeremy D. Zawodny, <jzawodn@stripped>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 34 days, processed 742,442,308 queries (252/sec.
avg)
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread87515@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

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