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
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
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
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
11 matches
Mail list logo
