List:General Discussion« Previous MessageNext Message »
From:Kevin Burton Date:May 7 2005 1:41am
Subject:Re: MySQL not using optimum disk throughput.
View as plain text  
Greg Whalin wrote:

>
> Deadline was much faster.  Using sysbench:
>
> test:
> sysbench --num-threads=16 --test=fileio --file-total-size=20G 
> --file-test-mode=rndrw run


Wow... what version of sysbench are you running?  Its giving me strange 
errors........

> sysbench v0.3.4:  multi-threaded system evaluation benchmark
>
> Running the test with following options:
> Number of threads: 16
>
> Extra file open flags: 0
> 128 files, 160Mb each
> 20Gb total file size
> Block size 16Kb
> Number of random requests for random IO: 10000
> Read/Write ratio for combined random IO test: 1.50
> Periodic FSYNC enabled, calling fsync() each 100 requests.
> Calling fsync() at the end of test, Enabled.
> Using synchronous I/O mode
> Doing random r/w test
> Threads started!
> FATAL: Failed to read file! file: 90 pos: 14761984 errno = 0 (Success)
> FATAL: Failed to read file! file: 103 pos: 161398784 errno = 0 (Success)
> FATAL: Failed to read file! file: 75 pos: 79413248 errno = 0 (Success)
> FATAL: Failed to read file! file: 79 pos: 67207168 errno = 0 (Success)
> FATAL: Failed to read file! file: 108 pos: 64028672 errno = 0 (Success)
> FATAL: Failed to read file! file: 53 pos: 96157696 errno = 0 (Success)
> FATAL: Failed to read file! file: 88 pos: 137068544 errno = 0 (Success)


-- 


Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com. 
See irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

   Kevin A. Burton, Location - San Francisco, CA
      AIM/YIM - sfburtonator,  Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 

Thread
MySQL not using optimum disk throughput.Kevin Burton6 May
  • Re: MySQL not using optimum disk throughput.Dan Nelson7 May
RE: MySQL not using optimum disk throughput.Dathan Pattishall7 May
  • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
    • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
      • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
        • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
          • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
            • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
              • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
                • Re: MySQL not using optimum disk throughput.Atle Veka7 May
                  • Re: MySQL not using optimum disk throughput.Kevin Burton7 May
                    • Re: MySQL not using optimum disk throughput.Atle Veka7 May
                  • Re: MySQL not using optimum disk throughput.Dan Nelson8 May
              • Re: MySQL not using optimum disk throughput.Peter Zaitsev7 May
                • Re: MySQL not using optimum disk throughput.Greg Whalin7 May
                  • Re: MySQL not using optimum disk throughput.Peter Zaitsev1 Jun
                    • RE: MySQL not using optimum disk throughput.Richard Dale1 Jun
        • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
          • Re: MySQL not using optimum disk throughput.Greg Whalin9 May
            • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
              • Re: MySQL not using optimum disk throughput.Greg Whalin9 May
                • Re: MySQL not using optimum disk throughput.Kevin Burton9 May
Re: MySQL not using optimum disk throughput.John David Duncan7 May
  • Re: MySQL not using optimum disk throughput.Peter Zaitsev7 May