Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 47 7 Older Entries

Displaying posts with tag: sysbench (reset)

Seeking public data for benchmarks
+3 Vote Up -0Vote Down

I have several side projects when time permits and one is that of benchmarking various MySQL technologies (e.g. MySQL 5.0,5.1,5.4), variants (e.g. MariaDB, Drizzle) and storage engines (e.g. Tokutek, Innodb plugin) and even other products like Tokyo Cabinet which is gaining large implementations.

You have two options with benchmarks, the brute force approach such as Sysbench, TPC, sysbench, Juice Benchmark, iibench, mysqlslap, skyload. I prefer the realistic approach however these are always on client’s private data. What is first needed is better access to public data for benchmarks. I have compiled this list to date and I am seeking additional sources for reference.

  • Feebase – Data is in clean loadable format
  • IMDB – Not
  [Read more...]
NILFS – may be not yet
+1 Vote Up -0Vote Down

Inspired by NILFS: A File System to Make SSDs Scream and some customers asked if they should try NILFS on their SSD disks I decided to run quick tests to see how it performs.

Installation on our Ubuntu 8.10 with SSD disk (Intel X25-E, 32GB) was pretty plain and I got partition with NILFS without problem. After that I run script for sysbench fileio:

PLAIN TEXT CODE:
  • for size in 256M 16G; do
  •    for mode in seqwr seqrd rndrd rndwr rndrw; do
  •       ./sysbench --test=fileio --file-num=1 --file-total-size=$size prepare
  •       for threads in 1 4 8; do
  •          echo PARAMS $size $mode $threads>
  •   [Read more...]
    Setting up sysbench with MySQL & Drizzle
    +2 Vote Up -0Vote Down

    Sysbench is a open source product that enables you to perform various system benchmarks including databases. Drizzles performs regression testing of every trunk revision with a branched version of sysbench within Drizzle Automation.

    A pending branch https://code.launchpad.net/~elambert/sysbench/trunk_drizzle_merge by Eric Lambert now enables side by side testing with MySQL and Drizzle. On a system running MySQL and Drizzle I was able install this sysbench branch with the following commands.

    cd bzr
    bzr branch lp:~elambert/sysbench/trunk_drizzle_merge
    cd trunk_drizzle_merge/
    ./autogen.sh
    ./configure
    make
    sudo make install
    

    Running the default lua tests

      [Read more...]
    configure: error: mysql_config executable not found
    +0 Vote Up -0Vote Down

    If your compiling a product that includes a dependency of MySQL, you can easily get the error

    configure: error: mysql_config executable not found
    

    I generally don’t see this problem, because I use MySQL binary tar files, however if you use MySQL packages, such as Ubuntu, you can easily miss the required dependency.

    My currently installed MySQL packages on this Ubuntu machine are:

    $ sudo dpkg -l | grep mysql
    ii  libdbd-mysql                               0.8.2-1-4.1                               MySQL database server driver for libdbi
    ii  libdbd-mysql-perl                          4.008-1                                   A Perl5 database interface to the MySQL data
    ii  libmysqlclient15off                        5.1.30really5.0.75-0ubuntu10.2            MySQL database client library
    ii  libmysqlclient16
      [Read more...]
    MySQL 5.4 Scaling on Nehalem with Sysbench
    Employee +1 Vote Up -0Vote Down
    As a final followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on a Sun Fire X4270 platform using the Intel x86 Nehalem chip (2 sockets/8 cores/16 threads). All CPUs were turned on during the runs. The my.cnf was the same as described in the previous blog.

    The Sysbench version used was 0.4.12, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    

    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here are the results graphically running on Linux.

      [Read more...]
    MySQL 5.4 Sysbench Scalability on 64-way CMT Servers
    Employee +1 Vote Up -0Vote Down
    As a followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on the same platform. The tests were carried out using the same basic approach (i.e. turning off entire cores at a time) - see my previous blog for more details.

    The Sysbench version used was 0.4.8, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    
    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here is the data presented graphically. Note that the number of vCPUs is the same as the number of active

      [Read more...]
    MySQL 5.4 Scaling on Nehalem with Sysbench
    Employee +0 Vote Up -0Vote Down
    As a final followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on a Sun Fire X4270 platform using the Intel x86 Nehalem chip (2 sockets/8 cores/16 threads). All CPUs were turned on during the runs. The my.cnf was the same as described in the previous blog.

    The Sysbench version used was 0.4.12, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \\
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    

    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here are the results graphically running on Linux.

      [Read more...]
    MySQL 5.4 Scaling on Nehalem with Sysbench
    Employee +0 Vote Up -0Vote Down
    As a final followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on a Sun Fire X4270 platform using the Intel x86 Nehalem chip (2 sockets/8 cores/16 threads). All CPUs were turned on during the runs. The my.cnf was the same as described in the previous blog.

    The Sysbench version used was 0.4.12, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \\
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    

    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here are the results graphically running on Linux.

      [Read more...]
    MySQL 5.4 Sysbench Scalability on 64-way CMT Servers
    Employee +0 Vote Up -0Vote Down
    As a followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on the same platform. The tests were carried out using the same basic approach (i.e. turning off entire cores at a time) - see my previous blog for more details.

    The Sysbench version used was 0.4.8, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \\
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    
    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here is the data presented graphically. Note that the number of vCPUs is the same as the number of

      [Read more...]
    MySQL 5.4 Sysbench Scalability on 64-way CMT Servers
    Employee +0 Vote Up -0Vote Down
    As a followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on the same platform. The tests were carried out using the same basic approach (i.e. turning off entire cores at a time) - see my previous blog for more details.

    The Sysbench version used was 0.4.8, and the read-only runs were invoked with the following command:

    sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \\
       --oltp-read-only=on --num-threads=[NO_THREADS] run
    
    The "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.

    Here is the data presented graphically. Note that the number of vCPUs is the same as the number of

      [Read more...]
    10 Newer Entries Showing entries 31 to 40 of 47 7 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.