Shulou(Shulou.com)05/31 Report--

Editor to share with you what is the difference between the stress testing tool swingbench and sysbench. I hope you will get something after reading this article. Let's discuss it together.

Swingbench

Let's start with swingbench, which was developed by an employee of Oracle in the UK with Java, and suddenly became the best choice for stress testing of Oracle. Of course, Oracle also has many such tools, such as DUL (Data UnLoader), which is developed by an employee in New Zealand with c, a tool that can read data files directly, which is basically used by the ACS department to provide advanced services. The other is SQLT, also known as SQLTXPLAIN, which is a tool provided by Oracle Server Technologies Center of Expertise-ST CoE and can be downloaded through MOS ID (ID 215187.1). Of course, there are many such tools.

Back to our topic, swingbench has good cross-platform support because it is based on Java. Basically we are testing the database performance on the server side on the Windows platform, using Java, so it is natural to use JDBC.

The design style of swingbench is completely componentized, and each component can be extracted and used separately, so if you go to a supported site to check it out. The advertised component diagram is still very domineering. Such as the main interface of swingbench, data generator, tracking analysis.

There's something even cooler. Monitor a number of indicators of the database, DB time, etc. This effect is comparable to that of commercial spotlight monitoring.

There is no doubt that swingbench is a good thing, a toolbox to continue to carry forward, it depends on everyone's use and promotion. As the saying goes, there are only two kinds of tools in the world, one is scolded, the other is unused. The more people are scolded, the higher the attention, the higher the utilization rate, and the more mature they are used. This MySQL is a very good example.

Swingbench supports so many functions that you can specify multiple data warehouses and generate data of a specified size. The test is based on the order business, and the simulated scenarios are more abundant. What are its disadvantages? Yes, there is.

First of all, the biggest personal feeling is that it only supports Oracle, in fact, based on JDBC is a lightweight interface, can connect to a variety of databases. This is the case with the database tool squirrel. A JDBC can adapt to many databases. If there is a breakthrough on this point, I think there is still great potential.

There is also based on the features of this tool, support for the Oracle platform, it seems that there is still a certain distance from the source community, although this tool is indeed open source, I checked the github has not seen, the current support is maintained through the site, the latest version is 2.6, has supported 12c.

Sysbench

This tool and swingbench have one thing in common, that is, it was also developed by an employee of Oracle, but belongs to MySQL team, and then came to Percona.

The saying that a company should be able to produce two styles of software has an obvious relationship with the database it supports. I'm going to start by talking about how I recently installed and used sysbench.

If you use an earlier version of sysbench, it should be 0.4.12. This version was originally maintained by a separate site and has now been fully transferred to github.

This tool is based on c development and currently supports a wide variety of databases.

# find. -name "drv*.c"

. / drizzle/drv_drizzle.c

. / pgsql/drv_pgsql.c

. / mysql/drv_mysql.c

. / oracle/drv_oracle.c

. / attachsql/drv_attachsql.c in which MySQL, which is native support, is available by default. PostgreSQL and Oracle are also supported, and drizzle, a branch of MySQL, is also supported.

Version 0.4.12 has been in use for many years and has many advantages. It can be tested for memory, CPU,IO,mutext and so on. The supported database stress test is one of them. The advantage of this part of the function based on c is obvious.

However, the 0.4.12 version is still quite limited, for example, it can only be tested based on a table of a database, which is very limited. So the scenarios that can be tested are still very limited.

By version 0. 5, the situation has changed, you can have multiple tables in one library, and you can set the interval parameter to see a real-time change. Because it supports Oracle, I was interested in testing it, and it frustrated me a little bit.

Why, 0.5 version of the installation of Oracle, mainly a dynamic link library configuration should be in place, but after the configuration to open the test, found that the database driver chose oracle, but the test prompted unknown database, with doubt to take a closer look, the original test template did not have Oracle. How to do this do-it-yourself food and clothing, but it is really difficult to write, why, because the template is based on the scripting language Lua, which is another hurdle.

However, there are also many friends in the industry who have written some Lua templates for reference.

Here I complain, that is, the latest version of sysbench is 1.0.3, I think the new version supports Oracle should have done a good job, look at the official prompt, for the Oracle installation also provides a separate README-Oracle.md, but the installation tips are still some different from what I expected.

The first is the installed client, which currently provides a stripped-down version of 12c, which is no problem, but the operating system based on ubuntu 14 is not officially certified for Oracle Enterprise Edition. Oracle of Linux version is officially available, and the supported systems are basically the following, and there will be some changes in the version.

Red Hat Enterprise Linux AS/ES

Oracle Enterprise Linux (OEL)

SUSE Linux Enterprise Server

AsianuxUbuntu is also Linux, but the back of the installation let me have a lot of difficulty, need to install Cuda, and is to use dpkg, this part is very strange, check the original dpkg is the abbreviation of Debian package, specially developed for the "Debian" operating system suite management system, for software installation, update and removal.

I checked to install a set of Cuda environment, and it took a lot of work. At last, I tried and gave up.

So back to version 0.5, the configuration of the dynamic link library, quickly configured, but there is no Lua template, at this time you can refer to a set of customized version provided by osdba, you can support MySQL,Oracle,PostgreSQL, I tried, not bad.

The whole process can be done in minutes with git.

Grab the installation part of sysbench

# git clone https://github.com/osdba/sysbench_bin.git and then grab the Lua script part

# git clone https://github.com/osdba/sysbench_lua then creates a sysbench directory to integrate the two directories crawled.

# mkdir sysbench

# cd sysbench

# cp.. / sysbench_bin/bin/*.

# cp-r. / sysbench_lua/lua. In this way, there are three execution files in the directory, which is basically the same as the command method of using sysbench directly, but with some emphasis.

-rwxr-xr-x 1 root root 3307216 Mar 24 16:09 sysbench_mysql

-rwxr-xr-x 1 root root 3324397 Mar 24 16:09 sysbench_ora

-rwxr-xr-x 1 root root 3253979 Mar 24 16:09 sysbench_pg

After reading this article, I believe you have a certain understanding of "what is the difference between swingbench and sysbench?" if you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.