On Thursday 30 September 2004 13:31, Juan Erbes wrote:
¿How much Gigabytes has the database? The database im testing with is approx 1GB if you dump it with mysqldump, approx 2G imported in mysql.
I mean, that for a real test, the database must have many millions of rows. With a database with few megabytes, its\'nt a real test for 64 bits. I disagree, if I wanted a database with millions of rows i would take our forum database (currently over 30G), but than i would be testing the I/O subsystem, not the processor/memory combination. The database im using fits in 4G ram, so after the first minutes of testing there should be almost no diskreads (im even thinking of putting the database files on a ramdisk to be sure the I/O subsystem wont influence the results. I'm going to monitor the diskstats closely to see that the hardisk wont influence the results.
If i wanted to test the IO system i would go and get myself a huge database and do random selects, that way you can be sure mysql is reading almost nonstop from the disk. I do have such a benchscript, and i'm considering running them too, but my scsi disks died on me (all three) and i dont have any disks till monday. -kees