List:Database Benchmarks« Previous MessageNext Message »
From:Peter Zaitsev Date:January 14 2005 4:19am
Subject:Re: sysbench results for XFS, reiserfs and ext3
View as plain text  
On Thu, 2005-01-13 at 07:27, Bas Meijer wrote:
> As per peter's suggestion I also tested with sysbench using 200 threads
> and 2milion records
> 
> XFS rules clearly.

Hi, 

Good to hear you find SysBench helpful.  Thank you for taking a time to
test MySQL and make results public.

I however should mention small concern with this test - you're using 
MyISAM storage engine for "read-write" test.  LOCK TABLES WRITE are used
in this case so results are basically serialized. I would recommend to
run test in read-only mode with MyISAM and with Innodb if it falls in
your area of interest. 


I'm also pretty surprised to see you get so low performance with
ReiserFS in this benchmark.

> 
> 
> 
> # sysbench --num-threads=200 --test=oltp --oltp-table-size=2000000
> --mysql-db=ext3 --mysql-user=root --mysql-table-type=myisam run
> sysbench v0.3.1:  multi-threaded system evaluation benchmark
> 
> Running the test with following options:
> Number of threads: 200
> 
> Doing OLTP test.
> Using mixed OLTP test
> Using Special distribution (12 iterations,  1 pct of values are returned
> in 75 pct cases)
> Using "LOCK TABLES WRITE" for starting transactions
> Maximum number of requests for OLTP test is limited to 10000
> Threads started!
> Done.
> 
> OLTP test statistics:
>     queries performed:
>         read:                            140000
>         write:                           40000
>         other:                           20000
>         total:                           200000
>     transactions:                        10000  (153.43 per sec.)
>     deadlocks:                           0      (0.00 per sec.)
>     read/write requests:                 180000 (2761.68 per sec.)
>     other operations:                    20000  (306.85 per sec.)
> 
> Test execution summary:
>     total time:                          65.1778s
>     total number of events:              10000
>     total time taken by event execution: 12898.5532
>     per-request statistics:
>          min:                            0.0962s
>          avg:                            1.2899s
>          max:                            3.1135s
>          approx.  95 percentile:         2.6789s
> 
> Threads fairness:
>     distribution:                        98.04/99.92
>     execution:                           98.08/99.84
> 
> # sysbench --num-threads=200 --test=oltp --oltp-table-size=2000000
> --mysql-db=xfs --mysql-user=root --mysql-table-type=myisam run
> sysbench v0.3.1:  multi-threaded system evaluation benchmark
> 
> Running the test with following options:
> Number of threads: 200
> 
> Doing OLTP test.
> Using mixed OLTP test
> Using Special distribution (12 iterations,  1 pct of values are returned
> in 75 pct cases)
> Using "LOCK TABLES WRITE" for starting transactions
> Maximum number of requests for OLTP test is limited to 10000
> Threads started!
> Done.
> 
> OLTP test statistics:
>     queries performed:
>         read:                            140000
>         write:                           40000
>         other:                           20000
>         total:                           200000
>     transactions:                        10000  (225.53 per sec.)
>     deadlocks:                           0      (0.00 per sec.)
>     read/write requests:                 180000 (4059.58 per sec.)
>     other operations:                    20000  (451.06 per sec.)
> 
> Test execution summary:
>     total time:                          44.3396s
>     total number of events:              10000
>     total time taken by event execution: 8642.5186
>     per-request statistics:
>          min:                            0.0961s
>          avg:                            0.8643s
>          max:                            1.0572s
>          approx.  95 percentile:         1.0176s
> 
> Threads fairness:
>     distribution:                        98.04/99.88
>     execution:                           98.28/99.68
> 
> # sysbench --num-threads=200 --test=oltp --oltp-table-size=2000000
> --mysql-db=reiser --mysql-user=root --mysql-table-type=myisam run
> sysbench v0.3.1:  multi-threaded system evaluation benchmark
> 
> Running the test with following options:
> Number of threads: 200
> 
> Doing OLTP test.
> Using mixed OLTP test
> Using Special distribution (12 iterations,  1 pct of values are returned
> in 75 pct cases)
> Using "LOCK TABLES WRITE" for starting transactions
> Maximum number of requests for OLTP test is limited to 10000
> Threads started!
> Done.
> 
> OLTP test statistics:
>     queries performed:
>         read:                            140000
>         write:                           40000
>         other:                           20000
>         total:                           200000
>     transactions:                        10000  (95.16 per sec.)
>     deadlocks:                           0      (0.00 per sec.)
>     read/write requests:                 180000 (1712.82 per sec.)
>     other operations:                    20000  (190.31 per sec.)
> 
> Test execution summary:
>     total time:                          105.0899s
>     total number of events:              10000
>     total time taken by event execution: 20881.3255
>     per-request statistics:
>          min:                            0.1206s
>          avg:                            2.0881s
>          max:                            7.5624s
>          approx.  95 percentile:         4.0176s
> 
> Threads fairness:
>     distribution:                        98.04/99.96
>     execution:                           98.47/99.84
> 
> 
> Bas Meijer
-- 
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com



Thread
sysbench results for XFS, reiserfs and ext3Bas Meijer13 Jan
  • Re: sysbench results for XFS, reiserfs and ext3Peter Zaitsev14 Jan