Hello Andreas,
Saturday, March 17, 2001, 6:36:17 PM, you wrote:
AV I noticed that in 3. and 4. the machine load was constantly at 100% during
AV the inserts.
AV but during index recreation the load springs wildley between 0 and 100%, so
AV the machine is not maxed out in terms of CPU
-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
-Ursprngliche Nachricht-
Von: Peter Zaitsev [EMAIL PROTECTED]
An: Andreas Vierengel [EMAIL PROTECTED]
Cc: Greg Cope [EMAIL PROTECTED]; Heikki Tuuri
[EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Datum: 18 March, 2001 10:35
Betreff: Re[2]: Innobase in MySQL
Could you tell me
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
Hello Greg,
Sunday, March 18, 2001, 9:29:45 PM, you wrote:
The only problem I see here - i don't know how innobase/bdb will
handle tables without primary key... i think perfomance should not be
so good as with myisam. Still there is a possibility to load all data
to myisam and then run
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 test.sql | mysql innobase = 306 seconds
2. cat test.sql | mysql
Greg,
I think mysqldump and import work for all table handlers in the same
way in MySQL. But to get the maximum performance, there are some optimizations
available.
Andreas Vierengel measured that using autocommit=0 makes the import
much faster for Innobase. You have to issue a commit after you
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
cyt
Peter Well probably. But The problem is I can't backup database comfortable
Peter way doing this (I can write a script of couse but there is one which
Peter is doing almost the same thing and it's mysqldump)
Peter so it looks like
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
Hello Dan,
Tuesday, March 13, 2001, 6:37:16 PM, you wrote:
DN 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
hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello Dan,
Peter Tuesday, March 13, 2001, 6:37:16 PM, you wrote:
DN 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
Hello Heikki,
Tuesday, March 13, 2001, 1:31:04 AM, you wrote:
HT Joshua,
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
HT yes, you can use mysqldump without shutting down. It did not come to my
HT mind that actually mysqldump is a kind of online
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
]: Innobase in MySQL
Hello Heikki,
Tuesday, March 13, 2001, 1:31:04 AM, you wrote:
HT Joshua,
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
HT yes, you can use mysqldump without shutting down. It did not come to my
HT mind that actually
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
18 matches
Mail list logo
