Re[2]: Innobase in MySQL

2001-03-18 Thread Peter Zaitsev
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

Re: Re[2]: Innobase in MySQL

2001-03-18 Thread Andreas Vierengel
-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

Re[2]: Innobase in MySQL

2001-03-18 Thread Peter Zaitsev
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

Re[2]: Innobase in MySQL

2001-03-14 Thread Peter Zaitsev
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

Re[2]: Innobase in MySQL

2001-03-14 Thread Michael Widenius
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

Re[2]: Innobase in MySQL

2001-03-13 Thread Peter Zaitsev
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

Re: Re[2]: Innobase in MySQL

2001-03-13 Thread William R. Mussatto
for single DBA use until its fully recovered. This is how its done on the big systems. Just a thought. On Tue, 13 Mar 2001, Peter Zaitsev wrote: Date: Tue, 13 Mar 2001 11:43:30 +0300 From: Peter Zaitsev [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re[2