Re: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)

2003-10-27 Thread Heikki Tuuri
Gabriel, - Original Message - From: "Gabriel Ricard" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, October 27, 2003 6:46 PM Subject: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1) > On Monday, O

InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)

2003-10-27 Thread Gabriel Ricard
On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote: 2. I personally use ReiserFS for all of my stuff, most of which is based upon InnoDB. One thing you have to remember is that InnoDB treats the space inside the tablespace as a Berkeley Fast Filesystem-style space, using the underlayin

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-27 Thread Chris Nolan
ournaled file system extra overhead? If so, is Raw significantly more efficient? How does this choice effect backup soultion? thanks, Jon - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 9:55 PM Sub

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-27 Thread Heikki Tuuri
Hancock" <[EMAIL PROTECTED]> > > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> > > Lähetetty: Monday, October 27, 2003 10:42 AM > > Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > > > > > > > Heikki, > >

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-27 Thread Jon Hancock
more efficient? How does this choice effect backup soultion? thanks, Jon > - Original Message - > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 24, 2003 9:55 PM > Subject: Re: MySQL/InnoDB-4.0.16 is rele

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-26 Thread Martijn Tonies
Hi Heikki, > > As you know - I'm a transaction zealot :-) > > > > Is there a way to get a signal back to the client when a > > transaction has started? > > what do you mean? If you have AUTOCOMMIT=0, then every SELECT, INSERT, > UPDATE, DELETE starts a new active transaction. Aha - that's good, I

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-25 Thread Heikki Tuuri
Martijn, - Original Message - From: ""Martijn Tonies"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, October 24, 2003 4:08 PM Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > Hi Heikki, > > As you know -

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Martijn Tonies
Hi Chris, > I'm not the almighty Heikki, but I might be able to fill you in to some > extent. :-) > Your first and third questions I cannot answer with certainty, but I'm > pretty > sure the answer is "no". Regarding the first one, I'm not too sure as to > why you'd need > it. Looking at the out

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Eduardo D Piovesam
CTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 11:23 AM Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > Eduardo, > > - Alkuperäinen viesti - > Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]> > Vastaanottaja: "

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Chris Nolan
Hi! I'm not the almighty Heikki, but I might be able to fill you in to some extent. Your first and third questions I cannot answer with certainty, but I'm pretty sure the answer is "no". Regarding the first one, I'm not too sure as to why you'd need it. Looking at the output of SHOW VARIABLES

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Heikki Tuuri
Eduardo, - Alkuperäinen viesti - Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Friday, October 24, 2003 6:17 PM Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Eduardo D Piovesam
00MB each or - Just one table2.ibd with 600MB or 1GB? Thanks again, Eduardo - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 10:55 AM Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Martijn Tonies
Hi Heikki, As you know - I'm a transaction zealot :-) Is there a way to get a signal back to the client when a transaction has started? Or perhaps something like @@trancount in MSSQL? Is there a way to turn ON/OFF auto-commit? And, are metadata operations under transaction control? With regar

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Heikki Tuuri
com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables .. From: "Eduardo D Piovesam" ([EMAIL PROTECTED]) Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-24 Thread Heikki Tuuri
, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables From: Chris Nolan ([EMAIL PROTECTED]) Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 View this article only Newsgroups: mailing.database.myodbc Date: 2003-

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-23 Thread Eduardo D Piovesam
(Sorry for the last email, it's not complete). Hello Heikki, Sorry, but I didn't understand the concept of tablespace applied. It's different from Oracle, right? AFAIK, tablespace is utilized to logically group "tables" into one (or more) files. And to group "indexes" into another files... But

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-23 Thread Eduardo D Piovesam
Hello Heikki, I didn't understand the concept of tablespaces utilized, - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 12:00 PM Subject: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 >

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

2003-10-22 Thread Chris Nolan
Hello Heikki!!! Multiple table spaces eh? Funky! Of course, as you've no doubt become aware, I am one of these annoying people that has many questions to ask the list the moment something like this comes along! Please feel free to ignore these questions though, as we're all hanging out for 4.1.1