Dan Rossi <[EMAIL PROTECTED]> wrote on 03/07/2006 05:47:41 AM:
> yet just another multi-national gupling up its competitors, i stumbled
> across this blog
> http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
> innodb.html and had no idea, its just as bad the the latest Eola patent
Hi Doug,
Thanks for the reply.
That is more or less what I was thinking too. (especially the ANT rant ;-)
I would be looking forward to read the paper in case its published one day.
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
Quoting "Douglas K. Fischer" <[EMAIL PRO
[EMAIL PROTECTED] wrote:
>>> speculating about that IMO.
>>
> What Oracle will do with Innobase is Oracle's matter, not much use in
>
> Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
> how the
> environment around Innobase / Innodb will change - and with it any
> support
>
What Oracle will do with Innobase is Oracle's matter, not much use in
speculating about that IMO.
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED how the
environment around Innobase / Innodb will change - and with it any support
options and other impacts that might have
Hi Valentin, all!
[EMAIL PROTECTED] wrote:
Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Correct.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
What Oracle will do with Innobase is Oracle's ma
>
> Note that the new BLOB code is not well tested yet, though
> I have not received any bug reports for it. It may be best to
> experiment first with pieces of your table instead of doing
> the whole, maybe several hours long, conversion at once.
>
Can you tell us a bit more about the BLOB
Hi!
I am back from holiday!
I guess using SELECT INTO OUTFILE (= mysqldump)
and LOAD FROM INFILE is as fast as converting
InnoDB->MyISAM->InnoDB.
I assume Ryan has a file system with > 2 GB files?
The outfile or the MyISAM table will be very big.
If you do not have > 2 GB files then you have to
On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote:
> I have a table that were created using innobase compiled with 64kb
> page tables. Now I want to upgrade to the newer version of innobase
> that supports the larger row sizes but as it mentions on the
> innobase .39b download page ( http://www
At 09:12 17/05/2001 -0300, Paulo Arantes de Azambuja wrote:
Hi,
Thanks for the bug report, I was able to repeat the same
behavior on Win9x. We will fix this ASAP, while this please
use mysqld-max.exe instead of mysqld.exe.
Regards,
Miguel
>Got the following message after starting mysqld on WinME:
Scott Ellsworth writes:
>
> Please find ctype.h attached. (I could have just trimmed, but it seemed
> likely that you might want info I blatantly trimmed away...)
>
> Also, on another topic, I tried building the berkeleydb option the other
> day, and got an error on startup about a lack
Leonard Coonan writes:
> I am trying to install Mysql (3.23.36) on windows NT. I have installed the
> software, but cannot find how to use the Innobase table structure. Can
> someone please point me in the right direction (apart from installing it on
> something else). I have tried putting
In the last episode (Apr 02), Leonard Coonan said:
> I am trying to install Mysql (3.23.36) on windows NT. I have
> installed the software, but cannot find how to use the Innobase table
> structure. Can someone please point me in the right direction (apart
> from installing it on something else)
Scott Ellsworth writes:
> Howdy, all.
>
> The following error came up when compiling under OS X release.
>
> c++ -DMYSQL_SERVER
> -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
> -DDATADIR="\"/usr/local/mysql/var\""
> -DSHAREDIR="\"/usr/local
Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 8:20 AM
To: [EMAIL PROTECTED]
Subject: Re: INNOBASE
Cal,
I will write more documentation during the week beginning 19th of
March, and post that to my website at www.innobase.fi. It will
also appear in the MySQL
Peter Zaitsev wrote:
>
> Hello Greg,
>
> Saturday, March 17, 2001, 3:31:53 AM, you wrote:
>
> GC> It would be very handy if Innobase (and the GEMINI when it comes along)
> GC> where to support mysqldump in the standard way, as I assume it works as
> GC> such and I and many others would have to
-Ursprüngliche Nachricht-
Von: Heikki Tuuri <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: 17 March, 2001 17:35
Betreff: Re: Innobase in MySQL
>Andy,
>
>thank you for your benchmark :). I was also going to measure these,
>but have no
Hi!
I exchanged some emails with Cal and he got his database running
today.
If you have repeating problems with creating the Innobase database,
check that you have deleted all Innobase data files and log files,
also a possible small archived log file, before trying the database
creation again. F
Andy,
thank you for your benchmark :). I was also going to measure these,
but have not had time yet. But what parameters you used in
my.cnf? You have a lot of RAM in your system, and you could make
the Innobase buffer pool big.
>I've benchmarked a few scenarios to load mysqldumped data into an
>
I've benchmarked a few scenarios to load mysqldumped data into an
innobase-table (about 27 columns, mostly int's and float's) with about
150.000 rows with primary key and an additional unique key. The mysqldumped
data was generated one insert per row (not dumped with --extended-inserts).
1. cat t
Cal Evans writes:
> Thanks for the reply but I'm not seeing any useful documentation.
> Specifically, is there a comprehensive list of all the my.cnf settings along
> with a detailed explanation of what they mean? Or is the one in the MySQL
> manual complete?
>
> Also, is there a tutorial o
ch 17, 2001 6:49 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: INNOBASE
Cal Evans writes:
> Other than the (sparse) documentation in the manual, is there any other
> documentation available for INNOBASE files?
>
> Cal
> http://www.calevans.com
>
Cal,
I will write more documentation during the week beginning 19th of
March, and post that to my website at www.innobase.fi. It will
also appear in the MySQL online manual at www.mysql.com, but
even sooner at my website, since I do not control the version
of the MySQL manual shown at www.mysql.c
Cal Evans writes:
> Other than the (sparse) documentation in the manual, is there any other
> documentation available for INNOBASE files?
>
> Cal
> http://www.calevans.com
>
>
Hi!
Try :
http://www.innobase.fi
Regards,
Sinisa
__ _ _ ___ == MySQL AB
Michael Widenius wrote:
>
> Hi!
>
> Try:
>
> mysqldump --tab=directory
>
> This does basicly what you want.
>
> After that, it's up to Heikki to fix Innobase to do delayed creation
> of indexes.
It would be very handy if Innobase (and the GEMINI when it comes along)
where to support mysqldum
, Richard RE SSI-GRAX
Cc: [EMAIL PROTECTED]
Subject: RE: Innobase compile problems
Rick,
have you downloaded version 3.23.34 and not 3.23.34a?
I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem
directory.
I have attached to this email a copy of mem0dbg.c.
Are your Makefile's
Rick,
have you downloaded version 3.23.34 and not 3.23.34a?
I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem
directory.
I have attached to this email a copy of mem0dbg.c.
Are your Makefile's such that they did not build all the
object files and libraries needed for linking
Please see my comments below.
>Do you mean that when you compile, on the compiler line >there is not the
>flag -I../include?
No, not really. I mean in the dependencies for a target.
>If the flag is missing, there obviously is something >wrong with our
Makefile.am's or configure.in's. You >prob
Peter,
could you ftp your binary (compiled with -g option) to
support.mysql.com directory /pub/mysql/Incoming
I can then try to run the ATIS test on your binary on our SMP Linux.
One possible reason for the errors you get is that your version
of GCC is buggy in inlining of code, but that is only
Rick,
>I tried to build from source the latest MySQL 3.23.34a and I found the
>following problems:
>
>1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
>paths on some dependencies.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include
I failed to mention that I used the RedHat Source RPM and I am using RedHat
6.2.
Rick
-Original Message-
From: Mehalick, Richard RE SSI-GRAX
Sent: Thursday, March 15, 2001 6:10 AM
To: 'Heikki Tuuri'
Cc: '[EMAIL PROTECTED]'
Subject: Innobase compile problems
Hi,
I tried to build from
On Wed, Mar 14, 2001 at 03:51:18PM +0900, Tatsuhiko Miyagawa wrote:
> Oops, really :-)
Yes, he posted it in the message with
Message-ID: <[EMAIL PROTECTED]>
Jeremy
> On Tue, 13 Mar 2001 22:48:58 -0800
> "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
>
> > > I can produce a core/backtrace if
Oops, really :-)
On Tue, 13 Mar 2001 22:48:58 -0800
"Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
> > I can produce a core/backtrace if necessary, but it sounds like this
> > easy to reproduce.
>
> Damn. Monty has already patched it. :-)
--
Tatsuhiko Miyagawa Livin' On The EDGE, Co.
On Tue, Mar 13, 2001 at 09:48:22PM -0800, Jeremy D. Zawodny wrote:
> On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote:
> >
> > On Mon, 12 Mar 2001 10:02:51 -0500
> > [EMAIL PROTECTED] wrote:
> >
> > >
> > > I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
In the last episode (Mar 13), Peter Zaitsev said:
> Well guys mysqldump have one serious problem - the speed.
>
> The backup speed is quite upsetting and loads system much, but the
> worst thing is recovery speed.
> In my case the data is added in realtime - most queries are inserts
> which utili
Hello Heikki,
Monday, March 12, 2001, 11:51:54 PM, you wrote:
HT> Hi Peter,
HT> and sorry that this response to your Big Mail comes some 12 days late.
HT> We have put together the release 3.23.34a and that has occupied
HT> my mind.
No Problem. At least the progress is going :) I'll try to test
Joshua,
>I hope you can also use MySQL dump, in which case, you don't have to shut
>down, right?
yes, you can use mysqldump without shutting down. It did not come to my
mind that actually mysqldump is a kind of online backup mechanism :).
Since Innobase is multiversioned, you will get consisten
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
j- k-
> >2) Can you perform backups as with other tables?
>
> You have to shut down the database, make sure that it shuts down without
> errors, and then copy the Innobase data files to a safe place (
Hi Peter,
and sorry that this response to your Big Mail comes some 12 days late.
We have put together the release 3.23.34a and that has occupied
my mind.
>HT> In pure insertions, copying a table to another, I have measured that
>HT> Innobase is about as fast as MyISAM. In aggregate queries from
Rick,
>Everything you wrote sounds good, except for one thing. I use the result
>count from a select or delete for logical branching within my code. I.e. I
>perform a select and if rowcount is zero, then I can do an update. That is
>a problem.
>
>Any thoughts?
The basic rowcount functionality
Hi Rick,
>In my C code, I use SQL statements, but I use the mySQL C API to pass on the
>SQL statements, check for errors, number of rows returned, and access the
>results. I would assume that this will still work; they still work with BDB
>tables.
ok, it should work like for BDB. There may be s
Rick,
>I wasn't sure if I should email to the mysql list or directly to you. Here
maybe it is best both to post to the mailing list and send a carbon copy
directly to me, so that others can share the advice.
>are my questions about the Innobase tables:
>
>1) Do you have to start a transaction
On Monday 12 March 2001 17:17, Heikki Tuuri wrote:
> Hi, readers of the mailing list!
>
> the Innobase table handler has finally been released as a part of
> the MySQL-3.23.34a source distribution Tarball.
Great news!
Congratulations for a great addition to the (already) great MySQL software.
--
Hello Heikki,
Monday, February 26, 2001, 5:08:52 PM, you wrote:
HT> Hi!
HT> There were more questions about Innobase:
>>Here is the comming question - can you speak some more about apace
>>allocation consepts used in innobase. For example how would it like to
>>work with huge number (10.000+ o
Hi!
There were more questions about Innobase:
>Here is the comming question - can you speak some more about apace
>allocation consepts used in innobase. For example how would it like to
>work with huge number (10.000+ of the tables) and how space allocation
The data dictionary is hashed, a huge
Hello Heikki,
Friday, February 23, 2001, 6:51:33 PM, you wrote:
HT> Peter and Sander,
HT> relevant questions, I will try to answer them.
>>Good questions - I have a few more :)
>>A) why does it seem to use fixed-size storage units. (The files)
HT> I have copied the concept of a tablespace con
Peter and Sander,
relevant questions, I will try to answer them.
>Good questions - I have a few more :)
>A) why does it seem to use fixed-size storage units. (The files)
I have copied the concept of a tablespace consisting of a small
number of files from Oracle. When the database itself manages
Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
B) what happens when they ar full?
C) can it auto-create new files as demand grows?
D) can you safely add new files when there is data in them already?
Regards,
Sander
> -Original Message
Hi again!
There were several questions on the mailing list, which I try
to answer:
- The MySQL manual says that you can convert between different table
types using ALTER TABLE, the same should hold for the Innobase table type,
though I must admit I have not yet tested it. ALTER TABLE is a high-l
Peter,
I guess you mean the source tree at www.bitkeeper.com? The interface
file ha_innobase.cc can be found there, but not yet the Innobase
source, I think. Then it cannot yet be compiled from the source tree,
because it needs Innobase header files.
But we should have the source out by Wednesda
>On a related note, how mature is the Innobase code? It is mostly new?
>Or like NuSphere's Gemini, it is older code which has been adapted to
>fit in with MySQL's table handler interface?
>
>Thanks!
>
>Jeremy
Hi,
I am also very interested in finding more out about innobase - code
maturity, com
Will I be able to change my BDB tables into Innobase tables using Alter
table and how does INNOBASE tables differ from the GEMINI tables (when they
are available)?
-
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ P
Is there a Windows version for InnoBase yet?
Lee
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 8:03 AM
To: [EMAIL PROTECTED]
Subject: Innobase + transactions & row level locks will be released in a
few days in MySQL 3.23.3x
Hi, reader
Hi Jeremy!
>Very cool!
>I see the change log entries in the on-line manual already, but the
>source tarball isn't on SourceForge yet. :-(
>Anyone have one yet?
No, we are still busy working on the distribution, and no one has
it yet.
I just 15 minutes ago got the Solaris version running :).
On Fri, Feb 16, 2001 at 03:02:38PM +0200, Heikki Tuuri wrote:
>
> Monty will roll a new distribution of MySQL 3.23.3x this weekend.
> Innobase will be included there and it will provide transactions,
> rollback, recovery, row level locking, and Oracle-like consistent
> read.
>
> Monty will leave
54 matches
Mail list logo
