From patchwork Mon Mar 22 07:18:03 2021 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 3957 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4F3m7345vgz40Qq for ; Mon, 22 Mar 2021 07:18:07 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "R3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4F3m731MwBz1Vk; Mon, 22 Mar 2021 07:18:07 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4F3m730lwVz2ycj; Mon, 22 Mar 2021 07:18:07 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4F3m723LcKz2x9X for ; Mon, 22 Mar 2021 07:18:06 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id 4F3m715clyzsN; Mon, 22 Mar 2021 07:18:05 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1616397485; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding; bh=Zn1tRhm159vKRWWtgdbkaG/vKZqiQElkx+5HPtfUOnE=; b=PJSevwZ8A7GUZwX7ZcGQ5ghNammP94gW3L7hYATmi4QBnHAGXzyuPO/y15kDGPSiD3wJjt r60I5ZKqHzy1dQBQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1616397485; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding; bh=Zn1tRhm159vKRWWtgdbkaG/vKZqiQElkx+5HPtfUOnE=; b=covlFO0bEvcBYyGTRvi0wPDVK3LhMJ/a8hxSf1pGw3c7vZg5Zd78Dg4NuOVepdGTu86NuN mPKMFGHRzVcl/ZrvkOcInmiAEoULoNMHXakS+cTQyUhRJZrONbJF9ev/9stlnNmGGAjBIL 1oCSlgxJuK1XWCnk5cIwpbnMR8vSMoMYbnRVGj9aPp5iCk1w19UAW+28Dq3aEs+ZYB1y2n edjsOWyRaVwHyjoI8P6iWDyLBdmPL2bibfRJaWlRsKBJq4AMS2tQdNc51rtdgT8h2WsLz0 xqcMaDB8CxdbrJIYwtRclPEyV+IYvjfHjW8pCj+0d2NOt771DcZmwtutKuY2OQ== From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sysbench: Update to 1.0.20 Date: Mon, 22 Mar 2021 08:18:03 +0100 Message-Id: <20210322071803.858-1-adolf.belka@ipfire.org> MIME-Version: 1.0 X-BeenThere: development@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: IPFire development talk List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: development-bounces@lists.ipfire.org Sender: "Development" - Update from 0.4.12 to 1.0.20 - Updated rootfile - Changelog 2020-04-24 Alexey Kopytov * version 1.0.20 * build/CI/packaging: Add arm64 to Travis CI matrix (#358) * build/CI/packaging: add Ubuntu Focal * build/CI/packaging: remove Fedora Rawhide from CI matrix * build/CI/packaging: fix regression tests to work with MySQL 8.0.19+ * build/CI/packaging: fix macOS builds in Travis * build/CI/packaging: remove Ubuntu Disco (EOL) 2019-12-08 Alexey Kopytov * version 1.0.19 * build/CI/packaging: fix Ubuntu packaging for Bionic and later versions * regression tests: compatibility fix for PostgreSQL 12 * build/CI/packaging: fix macOs builds in Travis * build/CI/packaging: add Fedora 31. 2019-10-21 Alexey Kopytov * version 1.0.18 * build/CI/packaging: add Ubuntu Eoan. * build/CI/packaging: remove Ubuntu Cosmic (EOL). * build/CI/packaging: add CentOS 8. * build/CI/packaging: add Ubuntu Disco. * build/CI/packaging: remove Ubuntu Trusty (EOL). * build/CI/packaging: remove Fedora 28 (EOL). * build/CI/packaging: add Fedora 30. * build/CI/packaging: cherry-pick fix for LuaJIT/LuaJIT#484 to fix builds on macOS Mojave. * build/CI/packaging: add Debian Buster 2019-03-15 Alexey Kopytov * version 1.0.17 * build/CI/packaging: update RPM spec to support RHEL8-beta (thanks to Alexey Bychko for the patch) * regression tests: remove unnecessary error leading to opt_rate.t instability. * --rate mode: return a non-zero exit code on event queue overflow. * --rate mode: fix a bogus error about eventgen thread termination 2018-12-16 Alexey Kopytov * version 1.0.16 * build/CI/packaging: add Ubuntu Cosmic. * build/CI/packaging: add Fedora 29. * build/CI/packaging: remove Fedora 27 (EOL). * SQL API: fix GH-282 (Mysql's fetch_row() is broken) * --rate mode: fix latency stats skew on low rates * Lua: Add /usr/share/lua/5.1 to LUA_PATH and /usr/lib/lua/5.1 to LUA_CPATH. * build/CI/packaging: add -Wvla to default compiler flags. * build/CI/packaging: fix debian/changelog format * build/CI/packaging: fix buildpack.sh to not push multiple file types to packagecloud. * build/CI/packaging: add libaio-dev to Debian/Ubuntu build dependencies. 2018-07-03 Alexey Kopytov * version 1.0.15 * CI/build/packaging: add Fedora 28 * CI/build/packaging: add Ubuntu Bionic * CI/build/packaging: remove Fedora 26 (EOL) * CI/build/packaging: remove Debian Wheezy (EOL) * fileio: fix GH-229 (--file-fsync-freq=0 seems to prevent fsync() at the end of the test) * command line: improve parsing of boolean command line options * tests: fix GH-220 (Testsuite api_sql_mysql.t failed ...) * tests: fix GH-223 (test failure on ppc64) * tests: fix opt_help.t to pass when the binary is not configured with MySQL support * MySQL driver: use it by default in DB benchmarks 2018-04-01 Alexey Kopytov * version 1.0.14 * reports: fix JSON stats reporter to produce valid JSON (GH-195) * Lua SQL API: don't crash when query_row() is called with a SELECT returning empty result set * Lua SQL API: don't crash when bulk insert API calls are used out of order * regression tests: make PostgreSQL tests compatible with the new dump format introduced in 10.3 * regression tests: minor stability and coverage improvements 2018-02-17 Alexey Kopytov * version 1.0.13 * remove Ubuntu Zesty from CI/build/packaging matrices (EOL) * minor cleanups in build scripts * improve report formatting for long latency values * fileio: --file-extra-flags now accepts a list of flags rather than just a single value * OLTP: re-prepare prepared statements after reconnects, i.e. in cases when a server connection is lost and sysbench is configured to ignore such errors 2018-01-17 Alexey Kopytov * version 1.0.12 * improve --rate mode precision for high argument values * add Fedora Rawhide and Debian Sid to CI matrix * fix compile-time architecture detection for some Broadwell CPUs which were incorrectly identified as Core 2. * remove build dependency on xxd (and vim-minimal package) * fix Lua API to correctly stop the benchmark when event() returns a value other than nil or false (thanks to caojiafeng for the patch) * fix the fileio benchmark when the specified file size is not a multiple of block size * fix the fileio benchmark to throw a descriptive error when the specified file size does not match the size of files created by 'prepare' * remove Fedora 25 from CI/build/packaging matrices (EOL) * minor improvements in tests and documentation. 2017-12-09 Alexey Kopytov * version 1.0.11 * add Debian Stretch to CI/build/packaging matrices * add Fedora 27 to CI/build/packaging matrices * make statistic counters usable from Lua scripts * fix the PostgreSQL driver to be compatible with CockroachDB (GH-180) * fix oltp_insert.lua to work correctly when both --tables and --threads are greater than 1 (GH-178) * fix FreeBSD builds by adding -rdynamic to the default linker flags (GH-174) * minor documentation updates 2017-10-25 Alexey Kopytov * version 1.0.10 * fixed PK conflicts in oltp_insert.lua by creating empty tables on 'prepare' * made sysbench.opt available to init()/done() by exporting it to the global Lua state * added Fedora 26 (both x86_64 and AArch64) to the list of supported and tested distributions * fixed GH-172: sysbench 1.0.9 doesn't build with mariadb 10.2.8 * add the /usr/local LuaRocks root directory to default LUA_PATH and LUA_CPATH * removed Fedora 24, Ubuntu Precise, Yakkety from default build matrices * added Ubuntu Artful to default build matrices 2017-09-05 Alexey Kopytov * version 1.0.9 * fixed oltp_delete.lua to not use INSERT statements for consistency with other oltp_* benchmarks (GH-168) * added a workaround for MySQL bug #87337 "8.0.2 reintroduces my_bool to client API" * fixed building on on Debian GNU/kFreeBSD (GH-161) * fixed building against MariaDB 10.2 (thanks to Xavier Bachelot for the patch, GH-160) 2017-07-04 Alexey Kopytov * version 1.0.8 * fixed api_report test for slow machines (thanks to @jcfp) * fileio: suggest to run prepare step on missing files (thanks to Heinrich Schuchardt) * JSON reports: removed an erroneous trailing comma (GH-139) * added events per second to the CPU benchmark report (GH-140) * fixed db_connect() in legacy SQL API to use the default value for --db-driver (GH-146) * removed busy-wait in the bounded event generation mode (--rate) to avoid CPU hogging 2017-05-15 Alexey Kopytov * version 1.0.7 * Ubuntu Zesty added to package build matrix * fixed GH-130: Mutex Benchmark Documentation * fixed latency reports in the --rate mode * fixed compiler warnings when building against MySQL 8.0 client libraries 2017-04-13 Alexey Kopytov * version 1.0.6 * no functional changes * many build- and packaging-related improvements * Linux packages are now automatically built using Travis CI and packpack, hosted by packagecloud.io 2017-04-02 Alexey Kopytov * version 1.0.5 * various build-related documentation updates * benchmark can now be specified by a module name on the command line * memory benchmark: performance and scalability improvements * fix ARMv6 builds with system ConcurrencyKit * fix GH-123: Table already exists error on prepare * fix GH-121: make buildhost cpudetection optional 2017-03-13 Alexey Kopytov * version 1.0.4 * fixed a number of compilation errors and warnings that were specific to 32-bit platforms * bundle cram (regression tests framework) and use it by default in 'make test' * bundled ConcurrencyKit updated to 0.6.0 2017-02-26 Alexey Kopytov * version 1.0.3 * LuaJIT scalability improvements for non-x86 architectures * performance optimizations in oltp_read_write.lua to avoid Lua string management * fixed Illumos builds (thanks to Dillon Amburgey) 2017-02-17 Alexey Kopytov * version 1.0.2 * improved scalability for --report-checkpoints mode * fix builds on CentoOS 6 and autoconf 2.63 * support for Snap (http://snapcraft.io) packages 2017-02-05 Alexey Kopytov * version 1.0.1 * fix clock_gettime runtime failure built with macOS 10.11 and Xcode 8.x 2017-02-04 Aleksei Kopytov * version 1.0.0 * too much time and too many changes since the previous formal release, so briefly: * Lua scripts instead of hard-coded C tests for database ("oltp") benchmarks + ability to create custom workloads * much better single-threaded performance * much better scalability * improvements and cleanups in command line syntax and options * latency histograms in cumulative statistic reports * report hooks to print statistics in custom formats (CSV/JSON/XML/etc.) * Dropped Windows support * Dropped support for Oracle, Drizzle and libattachsql drivers Signed-off-by: Adolf Belka --- config/rootfiles/packages/sysbench | 87 ++++++++++++++++++++++++++++++ lfs/sysbench | 6 +-- 2 files changed, 90 insertions(+), 3 deletions(-) diff --git a/config/rootfiles/packages/sysbench b/config/rootfiles/packages/sysbench index 31642561b..d38ecba1f 100644 --- a/config/rootfiles/packages/sysbench +++ b/config/rootfiles/packages/sysbench @@ -1 +1,88 @@ usr/bin/sysbench +#usr/share/sysbench +usr/share/sysbench/bulk_insert.lua +usr/share/sysbench/oltp_common.lua +usr/share/sysbench/oltp_delete.lua +usr/share/sysbench/oltp_insert.lua +usr/share/sysbench/oltp_point_select.lua +usr/share/sysbench/oltp_read_only.lua +usr/share/sysbench/oltp_read_write.lua +usr/share/sysbench/oltp_update_index.lua +usr/share/sysbench/oltp_update_non_index.lua +usr/share/sysbench/oltp_write_only.lua +usr/share/sysbench/select_random_points.lua +usr/share/sysbench/select_random_ranges.lua +#usr/share/sysbench/tests +#usr/share/sysbench/tests/include +usr/share/sysbench/tests/include/api_sql_common.sh +usr/share/sysbench/tests/include/config.sh +usr/share/sysbench/tests/include/drv_common.sh +usr/share/sysbench/tests/include/inspect.lua +usr/share/sysbench/tests/include/mysql_common.sh +#usr/share/sysbench/tests/include/oltp_legacy +usr/share/sysbench/tests/include/oltp_legacy/bulk_insert.lua +usr/share/sysbench/tests/include/oltp_legacy/common.lua +usr/share/sysbench/tests/include/oltp_legacy/delete.lua +usr/share/sysbench/tests/include/oltp_legacy/insert.lua +usr/share/sysbench/tests/include/oltp_legacy/oltp.lua +usr/share/sysbench/tests/include/oltp_legacy/oltp_simple.lua +usr/share/sysbench/tests/include/oltp_legacy/parallel_prepare.lua +usr/share/sysbench/tests/include/oltp_legacy/select.lua +usr/share/sysbench/tests/include/oltp_legacy/select_random_points.lua +usr/share/sysbench/tests/include/oltp_legacy/select_random_ranges.lua +usr/share/sysbench/tests/include/oltp_legacy/update_index.lua +usr/share/sysbench/tests/include/oltp_legacy/update_non_index.lua +usr/share/sysbench/tests/include/pgsql_common.sh +usr/share/sysbench/tests/include/script_bulk_insert_common.sh +usr/share/sysbench/tests/include/script_oltp_common.sh +usr/share/sysbench/tests/include/script_oltp_legacy_common.sh +usr/share/sysbench/tests/include/script_select_random_common.sh +usr/share/sysbench/tests/include/script_select_random_legacy_common.sh +#usr/share/sysbench/tests/t +usr/share/sysbench/tests/t/1st.t +usr/share/sysbench/tests/t/api_basic.t +usr/share/sysbench/tests/t/api_histogram.t +usr/share/sysbench/tests/t/api_legacy_basic.t +usr/share/sysbench/tests/t/api_legacy_rand.t +usr/share/sysbench/tests/t/api_legacy_sql.t +usr/share/sysbench/tests/t/api_rand.t +usr/share/sysbench/tests/t/api_reports.t +usr/share/sysbench/tests/t/api_sql_mysql.t +usr/share/sysbench/tests/t/api_sql_pgsql.t +usr/share/sysbench/tests/t/cmd_cleanup.t +usr/share/sysbench/tests/t/cmd_help.t +usr/share/sysbench/tests/t/cmd_prepare.t +usr/share/sysbench/tests/t/cmd_run.t +usr/share/sysbench/tests/t/cmdline.t +usr/share/sysbench/tests/t/commands.t +usr/share/sysbench/tests/t/drivers.t +usr/share/sysbench/tests/t/drv_mysql.t +usr/share/sysbench/tests/t/drv_pgsql.t +usr/share/sysbench/tests/t/help_drv_mysql.t +usr/share/sysbench/tests/t/help_drv_pgsql.t +usr/share/sysbench/tests/t/opt_help.t +usr/share/sysbench/tests/t/opt_histogram.t +usr/share/sysbench/tests/t/opt_rate.t +usr/share/sysbench/tests/t/opt_report_checkpoints.t +usr/share/sysbench/tests/t/opt_report_interval.t +usr/share/sysbench/tests/t/opt_version.t +usr/share/sysbench/tests/t/script_bulk_insert_mysql.t +usr/share/sysbench/tests/t/script_bulk_insert_pgsql.t +usr/share/sysbench/tests/t/script_oltp_delete_mysql.t +usr/share/sysbench/tests/t/script_oltp_delete_pgsql.t +usr/share/sysbench/tests/t/script_oltp_help.t +usr/share/sysbench/tests/t/script_oltp_insert_mysql.t +usr/share/sysbench/tests/t/script_oltp_insert_pgsql.t +usr/share/sysbench/tests/t/script_oltp_point_select_mysql.t +usr/share/sysbench/tests/t/script_oltp_point_select_pgsql.t +usr/share/sysbench/tests/t/script_oltp_read_write_mysql.t +usr/share/sysbench/tests/t/script_oltp_read_write_pgsql.t +usr/share/sysbench/tests/t/script_select_random_mysql.t +usr/share/sysbench/tests/t/script_select_random_pgsql.t +usr/share/sysbench/tests/t/test_cpu.t +usr/share/sysbench/tests/t/test_fileio.t +usr/share/sysbench/tests/t/test_memory.t +usr/share/sysbench/tests/t/test_mutex.t +usr/share/sysbench/tests/t/test_threads.t +usr/share/sysbench/tests/t/tests.t +usr/share/sysbench/tests/test_run.sh diff --git a/lfs/sysbench b/lfs/sysbench index 557c00ee3..ff9478d28 100644 --- a/lfs/sysbench +++ b/lfs/sysbench @@ -9,7 +9,7 @@ include Config -VER = 0.4.12 +VER = 1.0.20 THISAPP = sysbench-$(VER) DL_FILE = $(THISAPP).tar.gz @@ -17,7 +17,7 @@ DL_FROM = $(URL_IPFIRE) DIR_APP = $(DIR_SRC)/$(THISAPP) TARGET = $(DIR_INFO)/$(THISAPP) PROG = sysbench -PAK_VER = 1 +PAK_VER = 2 DEPS = @@ -29,7 +29,7 @@ objects = $(DL_FILE) $(DL_FILE) = $(DL_FROM)/$(DL_FILE) -$(DL_FILE)_MD5 = 3a6d54fdd3fe002328e4458206392b9d +$(DL_FILE)_MD5 = 756381c6fc4e16af1e0831b5e6a3dcb3 install : $(TARGET)