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
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: 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]
-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
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 utili
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 thier backup scripts.
GC> Del
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
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
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
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
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
Hello Michael,
Wednesday, March 14, 2001, 4:41:21 PM, you wrote:
Peter>> Well I tried to do so but still it takes an amount of time to add the
Peter>> indexes...
Peter>> I think the good Idea would be to add to mysqldump an option to create
Peter>> the table without index, then insert all 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 upsettin
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
gt;
> Cc: [EMAIL PROTECTED]
> Subject: Re[2]: 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?
&
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,
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
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 (
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
22 matches
Mail list logo
