Re: Some more info about backup.

2001-06-03 Thread Heikki Tuuri
Hi! >With mysqldump which uses the following query to do this: > >SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits > >It takes: >real1m23.177s (first time) >real1m20.934s (second time) The dump speed is 45000 rows or 5 MB per second. I think best disks today can write 1

Some more info about backup.

2001-06-02 Thread Michael Widenius
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> I'm repeating my test's now with more information and on more Peter> powerfull maching with no load now, this should give more accurate Peter> results. Peter> The machine is Dual PIII-750/1GB RAM

Some more info about backup.

2001-06-02 Thread Peter Zaitsev
Hello mysql, I'm repeating my test's now with more information and on more powerfull maching with no load now, this should give more accurate results. The machine is Dual PIII-750/1GB RAM I'm trying the following table structure: CREATE TABLE g00hits ( id int(10) unsigned NOT NULL