RE: InnoDB frightens me...

2002-03-05 Thread Weaver, Walt
ias Lind - Telia Internet; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: InnoDB frightens me... On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote: > I sure would, thanks Monty and Tobias. In particular some sample > update/insert/delete db code for MyISAM vs. InnoDB, (espec

Re: InnoDB frightens me...

2002-03-05 Thread Jeremy Zawodny
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote: > I sure would, thanks Monty and Tobias. In particular some sample > update/insert/delete db code for MyISAM vs. InnoDB, (especially in > the case where you're not adding transactions, just trying to take > advantage of row-locking.

RE: InnoDB frightens me...

2002-03-05 Thread Steve Rapaport
ge on replication issues. Steve Rapaport. ] -Original Message- ] From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]] ] Sent: Tuesday, March 05, 2002 1:46 PM ] To: [EMAIL PROTECTED] ] Cc: [EMAIL PROTECTED] ] Subject: Re: InnoDB frightens me... ] ] ] Thanks - that would be great!

RE: InnoDB frightens me...

2002-03-05 Thread savaidis
ias Lind - Telia Internet [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 2:46 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: InnoDB frightens me... > > > Thanks - that would be great! > I'm sure a lot of people will find this very helpf

Re: InnoDB frightens me...

2002-03-05 Thread Tobias Lind - Telia Internet
> Sent: Tuesday, March 05, 2002 12:36 PM Subject: Re: InnoDB frightens me... > > Hi! > > Tobias> Hi! > Tobias> I'm in the same position as Steve: Considering switching from MyISAM to >InnoDB because of the > Tobias> row-level locking capabilities. My applica

Re: InnoDB frightens me...

2002-03-05 Thread Michael Widenius
Hi! Tobias> Hi! Tobias> I'm in the same position as Steve: Considering switching from MyISAM to InnoDB because of the Tobias> row-level locking capabilities. My application has quite a lot of updates/inserts mixed with Tobias> selects, and is starting to suffer from the table-locking policy...

AW: InnoDB frightens me...

2002-03-04 Thread Christian Rabe
to another tablespace. Regards, Christian -Ursprungliche Nachricht- Von: Rick Flower [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Marz 2002 19:17 An: MySQL Mailing List Cc: Heikki Tuuri Betreff: AW: InnoDB frightens me... Christian Rabe writes: >Are there plans on creating more than o

Re: InnoDB frightens me...

2002-03-04 Thread jayce
On Monday 04 March 2002 09:32 pm, you wrote: > On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote: > > Hi Heikki, > > > > I don't know if this has been requested, but what about a tool to > > 'pre-create' dataspace? This tool would allow someone to create a > > new dataspace, then a qui

Re: InnoDB frightens me...

2002-03-04 Thread Jeremy Zawodny
On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote: > > Hi Heikki, > > I don't know if this has been requested, but what about a tool to > 'pre-create' dataspace? This tool would allow someone to create a > new dataspace, then a quick restart (After adding the name of the > space to 'my

AW: InnoDB frightens me...

2002-03-04 Thread Rick Flower
Christian Rabe writes: >Are there plans on creating more than on tablesspace plus making them >selectable ? >So that I can tell the DB: >- in which datafiles to store the tablespace X >- in which tablespace to store table Y This is one of the things I was wondering about.. If I have multiple Inn

Re: InnoDB frightens me...

2002-03-04 Thread Ken Menzel
sage - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 6:46 AM Subject: Re: InnoDB frightens me... > Steve, > > I added an item to the TODO list at http://www.innodb.com/todo.html > > .. > May, 2002: >

AW: InnoDB frightens me...

2002-03-04 Thread Christian Rabe
, 3. März 2002 12:46 An: [EMAIL PROTECTED] Betreff: Re: InnoDB frightens me... Steve, I added an item to the TODO list at http://www.innodb.com/todo.html .. May, 2002: Make a data file auto-extendible. You can specify the last data file in innodb_data_file_path like this: ibdata1

Re: InnoDB frightens me...

2002-03-04 Thread Tobias Lind - Telia Internet
l MySQL/InnoDB support at https://order.mysql.com/ Speed up adding of features to MySQL/InnoDB through support contracts See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Steve Rapaport <[EMAIL PROTECTED]> Newsgroups: mailing.database.m

Re: InnoDB frightens me...

2002-03-03 Thread Heikki Tuuri
online manual and latest news on InnoDB -Original Message- From: Steve Rapaport <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Sunday, March 03, 2002 12:18 AM Subject: InnoDB frightens me... >I'm seriously considering switching to mysql-max so I can make my >

Re: InnoDB frightens me...

2002-03-02 Thread Jeff Kilbride
IL PROTECTED]> Sent: Saturday, March 02, 2002 7:11 PM Subject: Re: InnoDB frightens me... > On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote: > > > I'm looking to make the move to InnoDB, too. All I've heard is positve. > > Here's a reply I got on

Re: InnoDB frightens me...

2002-03-02 Thread Jeremy Zawodny
On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote: > I'm looking to make the move to InnoDB, too. All I've heard is positve. > Here's a reply I got on another list: > > > If you have a very busy read/write op database, MyISAM can't handle > it. It's very efficie

Re: InnoDB frightens me...

2002-03-02 Thread Jeff Kilbride
;[EMAIL PROTECTED]> To: "Steve Rapaport" <[EMAIL PROTECTED]> Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 6:19 PM Subject: Re: InnoDB frightens me... > On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport

Re: InnoDB frightens me...

2002-03-02 Thread Jeremy Zawodny
On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport wrote: > > I'm seriously considering switching to mysql-max so I can make my > session handling table an Innodb type. Currently the mysql locking > policy allows big traffic jams when several sessions are active > simultaneously, and it's t

InnoDB frightens me...

2002-03-02 Thread Steve Rapaport
I'm seriously considering switching to mysql-max so I can make my session handling table an Innodb type. Currently the mysql locking policy allows big traffic jams when several sessions are active simultaneously, and it's the only table that has frequent updates. I need row-locks! BUT, and it's