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 thier backup scripts.
> GC> Delayed index creation is very usefull (in saving time) in larger DB
> GC> loads via a mysqldump - Hiekki is this difficult ?
>
> I as well as insertion speed is 90% limited by idex creation (at least
> for myisam) there could be an optimization generic for all table
> handlers, done on mysql level - at first to create tables without any
> keys, then insert all data in it and then run alter table to add all
> keys what should be in this table.
>
> 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 alter table which adds all indexes required and
> then converts the table to format required on the same pass.
>
Agreed, but it would be nice if this was automatic with mysqldump ?!
Although a gut feeling would be that create myisam table, insert, create
indexes, convert will be slower.
Greg
> I'll try to do some benchmarks accordint to this to se if it does any
> speed improvement.
>
> --
> Best regards,
> Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php