-Ursprngliche 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 not had time yet. But what parameters you
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 change
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
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 mysqldump in the
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 utilize
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
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
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 (it
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 consistent