[PATCH v2 lkp-tests] pkg: add mysql - Compass-ci

17 Nov 2020

sysbench-mysql need to test with mysql8.0.17
Signed-off-by: Lin Jiaxin ljx.joe@qq.com
Signed-off-by: Zhang Yu 2134782174@qq.com
---
 ...00-mysql-add-fstack-protector-strong.patch | 20 ++++++
 pkg/mysql/PKGBUILD                            | 50 ++++++++++++++
 pkg/mysql/my.cnf                              | 67 +++++++++++++++++++
 3 files changed, 137 insertions(+)
 create mode 100644 pkg/mysql/0000-mysql-add-fstack-protector-strong.patch
 create mode 100644 pkg/mysql/PKGBUILD
 create mode 100644 pkg/mysql/my.cnf

diff --git a/pkg/mysql/0000-mysql-add-fstack-protector-strong.patch b/pkg/mysql/0000-mysql-add-fstack-protector-strong.patch
new file mode 100644
index 00000000..23c07c87
--- /dev/null
+++ b/pkg/mysql/0000-mysql-add-fstack-protector-strong.patch
@@ -0,0 +1,20 @@
+diff --git a/cmake/build_configurations/compiler_options.cmake b/cmake/build_configurations/compiler_options.cmake
+index fecf2a2..f3e012f 100644
+--- a/cmake/build_configurations/compiler_options.cmake
++++ b/cmake/build_configurations/compiler_options.cmake
+@@ -43,6 +43,7 @@ IF(UNIX)
+   # Default GCC flags
+   IF(CMAKE_COMPILER_IS_GNUCC)
+     SET(COMMON_C_FLAGS               "-fno-omit-frame-pointer")
++    SET(COMMON_C_FLAGS               "-fstack-protector-strong")
+     # Disable inline optimizations for valgrind testing to avoid false positives
+     IF(WITH_VALGRIND)
+       STRING_PREPEND(COMMON_C_FLAGS  "-fno-inline ")
+@@ -57,6 +58,7 @@ IF(UNIX)
+   ENDIF()
+   IF(CMAKE_COMPILER_IS_GNUCXX)
+     SET(COMMON_CXX_FLAGS               "-std=c++14 -fno-omit-frame-pointer")
++    SET(COMMON_CXX_FLAGS               "-fstack-protector-strong")
+     # Disable inline optimizations for valgrind testing to avoid false positives
+     IF(WITH_VALGRIND)
+       STRING_PREPEND(COMMON_CXX_FLAGS  "-fno-inline ")
diff --git a/pkg/mysql/PKGBUILD b/pkg/mysql/PKGBUILD
new file mode 100644
index 00000000..2fd32ead
--- /dev/null
+++ b/pkg/mysql/PKGBUILD
@@ -0,0 +1,50 @@
+pkgname=mysql
+pkgver=8.0.17
+pkgrel=3
+arch=('aarch64' 'x86_64')
+url="http://www.mysql.com"
+license=('GPLv2')
+source=("https://cdn.mysql.com/archives/mysql-8.0/mysql-boost-$pkgver.tar.gz"
+	"0000-mysql-add-fstack-protector-strong.patch"
+	"https://mirrors.huaweicloud.com/kunpeng/archive/openEuler/patch/database/mys..."
+	"my.cnf")
+md5sums=('7472a25d91973cbba5d8a8f176a3080b' '6e853850efbd6f887ac3e13b1bf99cc4' 'f13eb11de53616017f7428cc06d4e242' '7bb0372ec4e9281813a9afc67c6cfc20')
+
+prepare()
+{
+	cd $srcdir/$pkgname-$pkgver
+	patch -p1 < ../0000-mysql-add-fstack-protector-strong.patch
+}
+
+build()
+{
+	cd $srcdir/$pkgname-$pkgver
+
+	CMAKE=cmake
+	grep -sqF "CentOS Linux release 7" /etc/centos-release && CMAKE=cmake3
+
+	$CMAKE . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc \
+                -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 \
+                -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 \
+                -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci \
+                -DWITH_EMBEDDED_SERVER=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=./boost -DFORCE_INSOURCE_BUILD=1
+	make -j8
+
+	cd $srcdir
+	tar -zxvf getcpu.tgz
+
+	cd getcpu || exit
+	make
+}
+
+package()
+{
+	mkdir -p $pkgdir/getcpu
+	cp getcpu/getcpu-hi.ko $pkgdir/getcpu/
+
+	mkdir -p $pkgdir/etc
+	cp my.cnf $pkgdir/etc/
+
+	cd $srcdir/$pkgname-$pkgver
+	make DESTDIR=$pkgdir install
+}
diff --git a/pkg/mysql/my.cnf b/pkg/mysql/my.cnf
new file mode 100644
index 00000000..9732af40
--- /dev/null
+++ b/pkg/mysql/my.cnf
@@ -0,0 +1,67 @@
+[mysqld_safe]
+log-error=/data/mysql/log/mysql.log
+pid-file=/data/mysql/run/mysqld.pid
+[mysqldump]
+quick
+[mysql]
+[client]
+default-character-set=utf8mb4
+socket=/data/mysql/run/mysql.sock
+
+[mysqld]
+socket=/data/mysql/run/mysql.sock
+tmpdir=/data/mysql/tmp
+datadir=/data/mysql/data
+default_authentication_plugin=mysql_native_password
+port=3309
+user=mysql
+memlock=on
+bind-address=0.0.0.0
+skip-grant-tables
+
+lc-messages=en_US
+lc-messages-dir=/usr/local/mysql/share
+
+innodb_page_size=64k
+max_connections=4000
+back_log=2048
+performance_schema=OFF
+max_prepared_stmt_count=128000
+
+#file
+innodb_file_per_table
+innodb_log_file_size=2048M
+innodb_log_files_in_group=32
+innodb_open_files=10000
+table_open_cache_instances=64
+
+#buffers
+innodb_buffer_pool_size=128G
+innodb_buffer_pool_instances=64
+innodb_log_buffer_size=2048M
+
+#tune
+sync_binlog=0
+innodb_flush_log_at_trx_commit=0
+innodb_use_native_aio=1
+innodb_spin_wait_delay=160
+innodb_sync_spin_loops=20
+innodb_flush_method=O_DIRECT
+innodb_io_capacity=30000
+innodb_io_capacity_max=40000
+innodb_lru_scan_depth=9000
+innodb_page_cleaners=1
+innodb_spin_wait_pause_multiplier=25
+
+#perf special
+innodb_flush_neighbors=0
+innodb_write_io_threads=1
+innodb_read_io_threads=1
+innodb_purge_threads=1
+
+sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL_TABLES
+
+#skop_log_bin
+ssl=0
+
+table_open_cache=15000
-- 
2.23.0

    