pls ignore this mail
On Fri, Apr 23, 2021 at 09:46:26AM +0800, Luan Shengde wrote:
Signed-off-by: Luan Shengde shdluan@163.com
pkg/mysql-8-0-20/PKGBUILD | 79 +++++++++++++++++++++++++++++++++++++++ pkg/mysql-8-0-20/my.cnf | 69 ++++++++++++++++++++++++++++++++++ 2 files changed, 148 insertions(+) create mode 100644 pkg/mysql-8-0-20/PKGBUILD create mode 100644 pkg/mysql-8-0-20/my.cnf
diff --git a/pkg/mysql-8-0-20/PKGBUILD b/pkg/mysql-8-0-20/PKGBUILD new file mode 100644 index 000000000..154f936cf --- /dev/null +++ b/pkg/mysql-8-0-20/PKGBUILD @@ -0,0 +1,79 @@ +pkgname=mysql-server-mysql +pkgver=8.0.20 +gccdir=gcc +pkgrel=1 +arch=('aarch64' 'x86_64') +url="http://www.mysql.com" +license=('GPLv2') +source=("https://gitee.com/li-yancheng/my-sql_with_boostkit_patch.git"
"https://gitee.com/li-yancheng/gcc.git""my.cnf")+md5sums=('SKIP' 'SKIP' '99c4965aa870c475000993f52a0dee66')
+build() +{
# build_gccbuild_mysql+}
+build_gcc() +{
mkdir -p $HOME/rpmbuild/SOURCES/ && {cd $srcdir/gcc && cp -r * $HOME/rpmbuild/SOURCES/}cd $HOME/rpmbuild/SOURCES/ && {rpmbuild -bp gcc.spec}cd $HOME/rpmbuild/BUILD/gcc-9.3.0 && {./configure --prefix=/usr/ \--enable-shared \--enable-threads=posix \--enable-checking=release \--with-system-zlib \--enable-__cxa_atexit \--disable-libunwind-exceptions \--enable-gnu-unique-object \--enable-linker-build-id \--with-linker-hash-style=gnu \--enable-languages=c,c++,objc,obj-c++,fortran,lto \--enable-plugin \--enable-initfini-array \--disable-libgcj \--without-isl \--without-cloog \--enable-gnu-indirect-function \--with-stage1-ldflags='-Wl,-z,relro,-z,now' \--with-boot-ldflags='-Wl,-z,relro,-z,now' \--with-multilib-list=lp64make -j96make install}+}
+build_mysql() +{
unset CPPFLAGSunset CFLAGSunset CXXFLAGScd $srcdir/my-sql_with_boostkit_patch/$pkgname-$pkgverCMAKE=cmakegrep -sqF "CentOS Linux release 7" /etc/centos-release && CMAKE=cmake3mkdir -p buildcd build && {$CMAKE .. -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_BOOST=../boost/boost_1_70_0/make -j96}+}
+package() +{
cp my.cnf /etc/cd $srcdir/my-sql_with_boostkit_patch/$pkgname-$pkgver/build && {make install- }
+} diff --git a/pkg/mysql-8-0-20/my.cnf b/pkg/mysql-8-0-20/my.cnf new file mode 100644 index 000000000..49e5bc3df --- /dev/null +++ b/pkg/mysql-8-0-20/my.cnf @@ -0,0 +1,69 @@ +[mysqld_safe] +log-error=/data/mysql/log/mysql.log +pid-file=/data/mysql/run/mysqld.pid +[mysqldump] +quick +[mysql] +[client] +# default-character-set=utf8mb4 +default-character-set=utf8 +socket=/data/mysql/run/mysql.sock
+[mysqld] +socket=/data/mysql/run/mysql.sock +tmpdir=/data/mysql/tmp +datadir=/data/mysql/data +basedir=/usr/local/mysql +default_authentication_plugin=mysql_native_password +user=mysql +memlock=on +bind-address=0.0.0.0 +skip-name-resolve +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