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
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
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