Giter Site home page Giter Site logo

alibaba / alisql Goto Github PK

View Code? Open in Web Editor NEW
4.7K 487.0 844.0 407.24 MB

AliSQL is a MySQL branch originated from Alibaba Group. Fetch document from Release Notes at bottom.

License: GNU General Public License v2.0

Shell 0.70% CMake 0.52% C 44.23% C++ 46.59% Perl 5.36% Makefile 0.72% M4 0.13% XSLT 0.01% Batchfile 0.08% Pascal 0.13% Python 0.09% Assembly 0.47% HTML 0.12% PHP 0.04% SourcePawn 0.01% DTrace 0.02% POV-Ray SDL 0.01% Objective-C 0.33% Yacc 0.46% Lex 0.01%
database mysql alisql tokudb

alisql's Introduction

AliSQL

AliSQL is a MySQL branch originated from Alibaba Group. It is based on the MySQL official release and has many feature and performance enhancements. AliSQL has proven to be very stable and efficient in production environment. It can be used as a free, fully compatible, enhanced and open source drop-in replacement for MySQL.

AliSQL has been an open source project since August 2016. It is being actively developed by engineers from Alibaba Group. Moreover, it includes patches from Percona, WebScaleSQL, and MariaDB. AliSQL is a fruit of community effort. Everyone is welcomed to get involved.

AliSQL Release Notes

Repository AliSQL 8.0

Changes in AliSQL 5.6.32 (2018-05-01)
Changes in AliSQL 5.6.32 (2018-01-24)
Changes in AliSQL 5.6.32 (2017-10-10)
Changes in AliSQL 5.6.32 (2017-07-16)
Changes in AliSQL 5.6.32 (2017-05-04)
Changes in AliSQL 5.6.32 (2017-02-14)
Changes in AliSQL 5.6.32 (2016-12-25)
Changes in AliSQL 5.6.32 (2016-11-11)
Changes in AliSQL 5.6.32 (2016-10-14)
Changes in AliSQL 5.6.32 (2016-09-15)

AliSQL Compiler Guide

AliSQL-Compiler-Guide

AliSQL benchmark

Performance benchmark
Performance benchmark for inventory

AliSQL wiki

Wiki

AliSQLBackup

AliSQLBackup
AliSQLBackup.wiki

AliSQL Sequence Engine

AliSQL-Sequence-Doc

alisql's People

Contributors

agopi avatar alfranio avatar bjornmu avatar bkandasa avatar blaudden avatar frazerclement avatar gkodinov avatar glebshchepa avatar gopshank avatar gurusami avatar harinvadodaria avatar hramilison avatar jhauglid avatar karenlang avatar kboortz avatar marcalff avatar mithuncy avatar mydanny avatar nacarvalho avatar nryeng avatar phulakun avatar roylyseng avatar satya461 avatar snarkedi avatar sreedhars avatar stewartsmith avatar thayumanavar77 avatar thirunarayanan avatar vaintroub avatar vasild avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

alisql's Issues

编译tokudb出错

如题,相同环境下能编译percona和mariadb的tokudb
执行语句如下:

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/alisql
-DMYSQL_DATADIR=/data/mysql/8306/data
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_TOKUDB_STORAGE_ENGINE=1
-DSYSCONFDIR=/data/mysql/8306
-DWITH_SSL=yes
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci

报错如下:

RegularExpression::compile(): Nested *?+.
RegularExpression::compile(): Error in compile.
CMake Error at scripts/CMakeLists.txt:287 (IF):
if given arguments:

"NOT" "lib" "STREQUAL" "general" "AND" "NOT" "LIBS" "MATCHES" "-lstdc++ "

Regular expression "-lstdc++ " cannot compile
Call Stack (most recent call first):
scripts/CMakeLists.txt:307 (EXTRACT_LINK_LIBRARIES)

-- Configuring incomplete, errors occurred!

cmake version: 2.8.12.2
gcc version: gcc (GCC) 5.2.1 20150902

Two Error. How to do?

Linking CXX static library libsql.a
[ 93%] Built target sql
make: *** [all] Error 2

make[2]: *** [libmysqld/CMakeFiles/sql_embedded.dir/__/sql/semisync_slave.cc.o] Error 1
make[1]: *** [libmysqld/CMakeFiles/sql_embedded.dir/all] Error 2
make: *** [all] Error 2

ERROR 1146 (42S02): Table 'mysql.TABLE_STATISTICS' doesn't exist

我编译安装了AliSQL 5.6.32 (2017 02 14), 但是在使用table/index statistics特性的时候报错了。

以下是复现过程:

# /opt/alisql/bin/mysql --version
/opt/alisql/bin/mysql  Ver 14.14 Distrib 5.6.32, for Linux (x86_64) using  EditLine wrapper

# /opt/alisql/bin/mysql -uroot -P 3360

mysql> use mysql;
mysql> SELECT * FROM TABLE_STATISTICS;
ERROR 1146 (42S02): Table 'mysql.TABLE_STATISTICS' doesn't exist

请大神拨云见日...

大神们 这个怎么处理

[ 45%] Building CXX object storage/innobase/CMakeFiles/innobase.dir/row/row0ins.cc.o
[ 45%] Building CXX object storage/innobase/CMakeFiles/innobase.dir/row/row0merge.cc.o
[ 45%] Building CXX object storage/innobase/CMakeFiles/innobase.dir/row/row0mysql.cc.o
/home/qiangchen4/AliSQL-master/storage/innobase/row/row0mysql.cc:69:19: error: zutil.h: No such file or directory
/home/qiangchen4/AliSQL-master/storage/innobase/row/row0mysql.cc: In function ‘unsigned char* row_compress_column(const unsigned char*, ulint*, ulint, row_prebuilt_t*)’:
/home/qiangchen4/AliSQL-master/storage/innobase/row/row0mysql.cc:358: error: ‘DEF_MEM_LEVEL’ was not declared in this scope
make[2]: *** [storage/innobase/CMakeFiles/innobase.dir/row/row0mysql.cc.o] Error 1
make[1]: *** [storage/innobase/CMakeFiles/innobase.dir/all] Error 2

cmake tokudb报错

cmake命令

  cmake . \
  -DCMAKE_INSTALL_PREFIX=/database/mysql3007 \
  -DMYSQL_TCP_PORT=3007 \
  -DMYSQL_DATADIR=/database/mysql3007/data \
  -DSYSCONFDIR=/etc \
  -DWITH_INNOBASE_STORAGE_ENGINE=1 \
  -DWITH_PARTITION_STORAGE_ENGINE=1 \
  -DWITH_FEDERATED_STORAGE_ENGINE=1 \
  -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
  -DWITH_TOKUDB_STORAGE_ENGINE=1 \
  -DWITH_MYISAM_STORAGE_ENGINE=1 \
  -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
  -DWITH_EMBEDDED_SERVER=0 \
  -DENABLE_DTRACE=0 \
  -DENABLED_LOCAL_INFILE=1 \
  -DDEFAULT_CHARSET=utf8mb4 \
  -DDEFAULT_COLLATION=utf8mb4_general_ci \
  -DCMAKE_EXE_LINKER_FLAGS="-ljemalloc" \
  -DWITH_SAFEMALLOC=OFF \
  -DEXTRA_CHARSETS=all

执行以上cmake命令出错,在Performing Test TOKUDB_OK步骤失败
错误日志:

Run Build Command:/usr/bin/gmake "cmTryCompileExec1917338609/fast"
/usr/bin/gmake -f CMakeFiles/cmTryCompileExec1917338609.dir/build.make CMakeFiles/cmTryCompileExec1917338609.dir/build
gmake[1]: Entering directory `/root/AliSQL-master/CMakeFiles/CMakeTmp'
/usr/bin/cmake -E cmake_progress_report /root/AliSQL-master/CMakeFiles/CMakeTmp/CMakeFiles 1
Building CXX object CMakeFiles/cmTryCompileExec1917338609.dir/src.cxx.o
/usr/bin/c++   -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -D_LARGE_FILES -D__STDC_CONSTANT_MACROS -D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter -DTOKUDB_OK   -o CMakeFiles/cmTryCompileExec1917338609.dir/src.cxx.o -c /root/AliSQL-master/CMakeFiles/CMakeTmp/src.cxx
/root/AliSQL-master/CMakeFiles/CMakeTmp/src.cxx:3: 错误:expected primary-expression before ‘.’ token
/root/AliSQL-master/CMakeFiles/CMakeTmp/src.cxx:3: 错误:expected primary-expression before ‘.’ token
gmake[1]: Leaving directory `/root/AliSQL-master/CMakeFiles/CMakeTmp'
gmake[1]: *** [CMakeFiles/cmTryCompileExec1917338609.dir/src.cxx.o] 错误 1
gmake: *** [cmTryCompileExec1917338609/fast] 错误 2

Source file was:

struct a {int b; int c; };
struct a d = { .b=1, .c=2 };
int main() { return 0; }

uname -a

Linux iZ1hj9esnmZ 2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

cmake 版本2.8.12.2

AliSQL 5.6.32 (2017-02-14) 编译出错

出错版本:AliSQL 5.6.32 (2017-02-14)

AliSQL 5.6.32 (2016-12-25) 可正常编译,AliSQL 5.6.32 (2017-02-14) 编译失败。

gcc --version

gcc (GCC) 5.3.1 20160406 (Red Hat 5.3.1-6)

报错信息:

[ 88%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sp_head.cc.o
cd /builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/libmysqld && /usr/lib64/ccache/c++   -DEMBEDDED_LIBRARY -DHAVE_CONFIG_H -DHAVE_OPENSSL -DMYSQL_SERVER -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/include -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/libmysql -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/libmysqld -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/regex -I/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/backup  -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC  -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter -DNDEBUG -DDBUG_OFF   -fPIC -o CMakeFiles/sql_embedded.dir/__/sql/sp_head.cc.o -c /builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/sp_head.cc
In file included from /builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:18:0:
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:87:18: error: 'Master_info' has not been declared
   int slaveReply(Master_info* mi);
                  ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:88:18: error: 'Master_info' has not been declared
   int slaveStart(Master_info *mi);
                  ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:89:17: error: 'Master_info' has not been declared
   int slaveStop(Master_info *mi);
                 ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:90:23: error: 'Master_info' has not been declared
   int requestTransmit(Master_info*);
                       ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:92:18: error: 'Master_info' has not been declared
   int resetSlave(Master_info *mi);
                  ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:35: error: 'int ReplSemiSyncSlave::slaveStart' is not a static data member of 'class ReplSemiSyncSlave'
 int ReplSemiSyncSlave::slaveStart(Master_info *mi)
                                   ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:35: error: 'Master_info' was not declared in this scope
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:48: error: 'mi' was not declared in this scope
 int ReplSemiSyncSlave::slaveStart(Master_info *mi)
                                                ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:86:1: error: expected ',' or ';' before '{' token
 {
 ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:34: error: 'int ReplSemiSyncSlave::slaveStop' is not a static data member of 'class ReplSemiSyncSlave'
 int ReplSemiSyncSlave::slaveStop(Master_info *mi)
                                  ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:34: error: 'Master_info' was not declared in this scope
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:47: error: 'mi' was not declared in this scope
 int ReplSemiSyncSlave::slaveStop(Master_info *mi)
                                               ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:105:1: error: expected ',' or ';' before '{' token
 {
 ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:35: error: 'int ReplSemiSyncSlave::resetSlave' is not a static data member of 'class ReplSemiSyncSlave'
 int ReplSemiSyncSlave::resetSlave(Master_info *mi)
                                   ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:35: error: 'Master_info' was not declared in this scope
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:48: error: 'mi' was not declared in this scope
 int ReplSemiSyncSlave::resetSlave(Master_info *mi)
                                                ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:114:1: error: expected ',' or ';' before '{' token
 {
 ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:40: error: 'int ReplSemiSyncSlave::requestTransmit' is not a static data member of 'class ReplSemiSyncSlave'
 int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
                                        ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:40: error: 'Master_info' was not declared in this scope
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:53: error: 'mi' was not declared in this scope
 int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
                                                     ^
/builddir/build/BUILD/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:148:1: error: expected ',' or ';' before '{' token
 {
 ^
make[2]: *** [libmysqld/CMakeFiles/sql_embedded.dir/__/sql/semisync_slave.cc.o] Error 1
make[2]: *** Waiting for unfinished jobs....

大神们,loose开头的参数都找不到,是因为tokudb引擎没装么?

2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_rds-anonymous-in-gtid-out-enable=1'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_opt_rds_enable_show_slave_lag=on'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_innodb_rds_buffer_pool_file_del=ON'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_cache_size=1639M'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_opt_rds_enable_set_default_engine=OFF'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_innodb_rds_autoinc_persistent_interval=1'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_implicit_primary_key=1'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_rds_binlog_group_commit_sync_no_delay_count=0'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_checkpointing_period=60'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_thread_pool_stall_limit=30'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_thread_pool_oversubscribe=10'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_max_statement_time=0'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_commit_sync=ON'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_support_xa=ON'
2016-12-01 22:53:03 4028 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose_rds_slave_minor_log=OFF'

alisql/sql/semisync_slave.h:88:18: 错误:‘Master_info’未声明

1、
gcc -v
使用内建 specs。
COLLECT_GCC=gcc
COLLECT_LTO_WRAPPER=/usr/local/gcc-6.3.0/libexec/gcc/x86_64-pc-linux-gnu/6.3.0/lto-wrapper
目标:x86_64-pc-linux-gnu
配置为:./configure --prefix=/usr/local/gcc-6.3.0/ -enable-threads=posix --disable-checking --disable-multilib --enable-languages=c,c++ --with-gmp=/usr/local/gmp-6.1.0/ --with-mpfr=/usr/local/mpfr-3.1.4/ --with-mpc=/usr/local/mpc-1.0.3/
线程模型:posix
gcc 版本 6.3.0 (GCC)

2、
home/OOOO/alisql/sql/semisync_slave.h:88:18: 错误:‘Master_info’未声明
int slaveReply(Master_info* mi);
^~~~~~~~~~~

编译出错

CMake Error at storage/tokudb/CMakeLists.txt:16 (MESSAGE):
Building TokuDB ERROR, please check cmake>=2.8.9 and x86-64

-- Configuring incomplete, errors occurred!
See also "/home/mysql/AliSQL-master/CMakeFiles/CMakeOutput.log".
See also "/home/mysql/AliSQL-master/CMakeFiles/CMakeError.log".

不支持block_format

下载了alisql编译成功,在测试block_format时发现说语法不支持,
是因为这个版本就不带这个功能,还是说在cmake阶段需要指定什么参数来开启透明加密的功能呢?

编译安装成功后,支持的引擎里没有tokudb?

root@localhost : (none) 16:54:47> show engines \G
*************************** 1. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 2. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MyISAM
Support: YES
Comment: MyISAM storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 6. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 9. row ***************************
Engine: PERFORMANCE_SCHEMA
Support: YES
Comment: Performance Schema
Transactions: NO
XA: NO
Savepoints: NO
9 rows in set (0.00 sec)

而且,官方的mysql好想也是9个数据引擎吧。不应该是有多出的数据引擎吗?

编译在这个地方老是报错,试过了好几遍

[ 99%] Building C object libmysqld/CMakeFiles/mysqlserver.dir/mysqlserver_depends.c.o
Linking C static library libmysqld.a
/bin/ar: creating /tmp/mysql-alisql-5.6.32/libmysqld/libmysqld.a
[ 99%] Built target mysqlserver
Scanning dependencies of target mysql_client_test_embedded
[100%] Building C object libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir///tests/mysql_client_test.c.o
Linking CXX executable mysql_client_test_embedded
../libmysqld.a(lib_sql.cc.o): In function `clean_up':

/tmp/mysql-alisql-5.6.32/libmysqld/../sql/mysqld.cc:1930: undefined reference to `free_global_table_stats()'

/tmp/mysql-alisql-5.6.32/libmysqld/../sql/mysqld.cc:1931: undefined reference to `free_global_index_stats()'

../libmysqld.a(lib_sql.cc.o): In function `init_server_components':

/tmp/mysql-alisql-5.6.32/libmysqld/../sql/mysqld.cc:4745: undefined reference to `init_global_table_stats()'

/tmp/mysql-alisql-5.6.32/libmysqld/../sql/mysqld.cc:4746: undefined reference to `init_global_index_stats()'

collect2: error: ld returned 1 exit status
make[2]: *** [libmysqld/examples/mysql_client_test_embedded] Error 1
make[1]: *** [libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir/all] Error 2
make: *** [all] Error 2

alisql安全问题

介绍里说:严防脱库,源码级防火墙,阻断SQL注入。但是我没看到相关的源码,请问可以指导下吗?

压测alisql时qps上不去

我压测alisql,qps只能到180qps,硬件环境是8C-16G,disk是ssd。压测程序是自己写的。是哪个过程不对嘛,有群可以交流的吗

编译出错?semisync_slave.h:87:18: error: ?.aster_info?.has not been declared

In file included from /root/Downloads/AliSQL-master/sql/semisync_slave.cc:18:0:
/root/Downloads/AliSQL-master/sql/semisync_slave.h:87:18: error: ?.aster_info?.has not been declared
int slaveReply(Master_info* mi);
^
/root/Downloads/AliSQL-master/sql/semisync_slave.h:88:18: error: ?.aster_info?.has not been declared
int slaveStart(Master_info *mi);
^
/root/Downloads/AliSQL-master/sql/semisync_slave.h:89:17: error: ?.aster_info?.has not been declared
int slaveStop(Master_info mi);
^
/root/Downloads/AliSQL-master/sql/semisync_slave.h:90:23: error: ?.aster_info?.has not been declared
int requestTransmit(Master_info
);
^
/root/Downloads/AliSQL-master/sql/semisync_slave.h:92:18: error: ?.aster_info?.has not been declared
int resetSlave(Master_info *mi);
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:85:35: error: ?.nt ReplSemiSyncSlave::slaveStart?.is not a static data member of ?.lass ReplSemiSyncSlave?
int ReplSemiSyncSlave::slaveStart(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:85:35: error: ?.aster_info?.was not declared in this scope
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:85:48: error: ?.i?.was not declared in this scope
int ReplSemiSyncSlave::slaveStart(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:86:1: error: expected ?.?.or ?.?.before ?.?.token
{
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:104:34: error: ?.nt ReplSemiSyncSlave::slaveStop?.is not a static data member of ?.lass ReplSemiSyncSlave?
int ReplSemiSyncSlave::slaveStop(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:104:34: error: ?.aster_info?.was not declared in this scope
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:104:47: error: ?.i?.was not declared in this scope
int ReplSemiSyncSlave::slaveStop(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:105:1: error: expected ?.?.or ?.?.before ?.?.token
{
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:113:35: error: ?.nt ReplSemiSyncSlave::resetSlave?.is not a static data member of ?.lass ReplSemiSyncSlave?
int ReplSemiSyncSlave::resetSlave(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:113:35: error: ?.aster_info?.was not declared in this scope
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:113:48: error: ?.i?.was not declared in this scope
int ReplSemiSyncSlave::resetSlave(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:114:1: error: expected ?.?.or ?.?.before ?.?.token
{
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:147:40: error: ?.nt ReplSemiSyncSlave::requestTransmit?.is not a static data member of ?.lass ReplSemiSyncSlav?
int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:147:40: error: ?.aster_info?.was not declared in this scope
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:147:53: error: ?.i?.was not declared in this scope
int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
^
/root/Downloads/AliSQL-master/sql/semisync_slave.cc:148:1: error: expected ?.?.or ?.?.before ?.?.token
{
^
make[2]: *** [libmysqld/CMakeFiles/sql_embedded.dir/__/sql/semisync_slave.cc.o] Error 1
make[2]: *** Waiting for unfinished jobs....
make[1]: *** [libmysqld/CMakeFiles/sql_embedded.dir/all] Error 2
make: *** [all] Error 2

Table 'mysql.plugin' doesn't exist,why?

2017-02-21 22:50:21 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.32) starting as process 1338 ...
2017-02-21 22:50:21 1338 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
2017-02-21 22:50:21 1338 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled
2017-02-21 22:50:21 1338 [ERROR] TokuDB: Huge pages are enabled, disable them before continuing

2017-02-21 22:50:21 1338 [ERROR] ************************************************************
2017-02-21 22:50:21 1338 [ERROR]
2017-02-21 22:50:21 1338 [ERROR] @@@@@@@@@@@
2017-02-21 22:50:21 1338 [ERROR] @@' '@@
2017-02-21 22:50:21 1338 [ERROR] @@ _ _ @@
2017-02-21 22:50:21 1338 [ERROR] | (.) (.) |
2017-02-21 22:50:21 1338 [ERROR] | ` |
2017-02-21 22:50:21 1338 [ERROR] | > ' |
2017-02-21 22:50:21 1338 [ERROR] | .----. |
2017-02-21 22:50:21 1338 [ERROR] .. |.----.| ..
2017-02-21 22:50:21 1338 [ERROR] .. ' ' ..
2017-02-21 22:50:21 1338 [ERROR] .._______,.
2017-02-21 22:50:21 1338 [ERROR]
2017-02-21 22:50:21 1338 [ERROR] TokuDB will not run with transparent huge pages enabled.
2017-02-21 22:50:21 1338 [ERROR] Please disable them to continue.
2017-02-21 22:50:21 1338 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled)
2017-02-21 22:50:21 1338 [ERROR]
2017-02-21 22:50:21 1338 [ERROR] ************************************************************
2017-02-21 22:50:21 1338 [ERROR] Plugin 'TokuDB' init function returned error.
2017-02-21 22:50:21 1338 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.

make编译出错

make,又报如下错:
Linking CXX static library libinnobase.a
[ 38%] Built target innobase
Scanning dependencies of target tokuportability_static_conv
[ 38%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/huge_page_detection.cc.o
[ 38%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/file.cc.o
[ 38%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/memory.cc.o
[ 38%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/os_malloc.cc.o
[ 38%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/portability.cc.o
[ 39%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/toku_assert.cc.o
[ 39%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/toku_crash.cc.o
[ 39%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/toku_path.cc.o
[ 39%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/toku_pthread.cc.o
[ 39%] Building CXX object storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/toku_time.cc.o
Linking CXX static library libtokuportability_static_conv.a
/opt/rh/devtoolset-3/root/usr/libexec/gcc/x86_64-redhat-linux/4.9.2/ar terminated with signal 11 [Segmentation fault], core dumped
make[2]: *** [storage/tokudb/ft-index/portability/libtokuportability_static_conv.a] 错误 1
make[1]: *** [storage/tokudb/ft-index/portability/CMakeFiles/tokuportability_static_conv.dir/all] 错误 2
make: *** [all] 错误 2

tokudb编译错误

alisql编译过程中增加tokudb,编译器使用的4.7.4,cmake用的2.8.12,ld版本2.25,系统是rhel6.4。
编译报错:
[ 29%] Built target tokuportability_static
[ 29%] Building CXX object storage/tokudb/ft-index/ft/CMakeFiles/logformat.dir/logger/logformat.cc.o
Linking CXX executable logformat
c++: error: -fuse-linker-plugin is not supported in this configuration
make[2]: *** [storage/tokudb/ft-index/ft/logformat] Error 1
make[1]: *** [storage/tokudb/ft-index/ft/CMakeFiles/logformat.dir/all] Error 2
make: *** [all] Error 2

各应用场景下的配置问题

对于不同的应用场景,如电商业务和金融业务,有没有区别优化的配置?还是说按照官方贴出的不同机型的标准配置,就以上两种场景都适合?

配置参数错误,按照8c-16.cnf

2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds-anonymous-in-gtid-out-enable=1'
522 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_cache_size=13108M'
523 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_opt_rds_enable_set_default_engine=OFF'
524 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_innodb_rds_autoinc_persistent_interval=1'
525 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_implicit_primary_key=1'
526 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_checkpointing_period=60'
527 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_thread_pool_stall_limit=30'
528 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_thread_pool_oversubscribe=10'
529 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_max_statement_time=0'
530 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_commit_sync=ON'
531 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_support_xa=ON'
532 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds_set_connection_id_enabled=ON'
533 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_innodb_rds_log_checksum_algorithm=INNODB'
534 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds_check_core_file_enabled=ON'
535 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_rpl_lookup_rows=OFF'
536 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_fs_reserve_percent=5'
537 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_buffer_pool_ratio=0'
538 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_innodb_rds_autoinc_persistent=ON'
539 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds_enable_log_global_var_update=ON'
540 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_opt_rds_last_error_gtid=ON'
541 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_rpl_unique_checks=OFF'
542 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_directio=OFF'
543 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_fsync_log_period=0'
544 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_tokudb_row_format=tokudb_zlib'
545 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds_expand_fast_index_creation=ON'
546 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rds_slave_read_no_lock=ON'
547 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_slave_trace_level=1'
548 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_master_timeout=1000'
549 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_master_trace_level=1'
550 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_slave_enabled=OFF'
551 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_master_enabled=OFF'
552 2016-10-16 01:21:07 17103 [Warning] /opt/local/mysql/bin/mysqld: unknown variable 'loose_rpl_semi_sync_master_wait_no_slave=ON'

make 编译出错 In file included from /root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:18:0: /root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:87:18: 错误:‘Master_info’未声明

[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir//sql/procedure.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/
/sql/protocol.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir//sql/records.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/
/sql/rpl_handler.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir//sql/scheduler.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/
/sql/set_var.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir//sql/signal_handler.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/
/sql/semisync.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir//sql/semisync_master.cc.o
[ 93%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/
/sql/semisync_slave.cc.o
In file included from /root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:18:0:
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:87:18: 错误:‘Master_info’未声明
int slaveReply(Master_info* mi);
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:88:18: 错误:‘Master_info’未声明
int slaveStart(Master_info *mi);
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:89:17: 错误:‘Master_info’未声明
int slaveStop(Master_info mi);
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:90:23: 错误:‘Master_info’未声明
int requestTransmit(Master_info
);
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.h:92:18: 错误:‘Master_info’未声明
int resetSlave(Master_info *mi);
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:35: 错误:‘int ReplSemiSyncSlave::slaveStart’不是‘class ReplSemiSyncSlav ’的静态成员 int ReplSemiSyncSlave::slaveStart(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:35: 错误:‘Master_info’在此作用域中尚未声明
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:85:48: 错误:‘mi’在此作用域中尚未声明
int ReplSemiSyncSlave::slaveStart(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:86:1: 错误:expected ‘,’ or ‘;’ before ‘{’ token
{
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:34: 错误:‘int ReplSemiSyncSlave::slaveStop’不是‘class ReplSemiSyncSlav ’的静态成员 int ReplSemiSyncSlave::slaveStop(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:34: 错误:‘Master_info’在此作用域中尚未声明
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:104:47: 错误:‘mi’在此作用域中尚未声明
int ReplSemiSyncSlave::slaveStop(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:105:1: 错误:expected ‘,’ or ‘;’ before ‘{’ token
{
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:35: 错误:‘int ReplSemiSyncSlave::resetSlave’不是‘class ReplSemiSyncSlav ve’的静态成员
int ReplSemiSyncSlave::resetSlave(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:35: 错误:‘Master_info’在此作用域中尚未声明
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:113:48: 错误:‘mi’在此作用域中尚未声明
int ReplSemiSyncSlave::resetSlave(Master_info *mi)
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:114:1: 错误:expected ‘,’ or ‘;’ before ‘{’ token
{
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:40: 错误:‘int ReplSemiSyncSlave::requestTransmit’不是‘class ReplSemiSyn ncSlave’的静态成员
int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:40: 错误:‘Master_info’在此作用域中尚未声明
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:147:53: 错误:‘mi’在此作用域中尚未声明
int ReplSemiSyncSlave::requestTransmit(Master_info *mi)
^
/root/AliSQL-AliSQL-5.6.32-4/sql/semisync_slave.cc:148:1: 错误:expected ‘,’ or ‘;’ before ‘{’ token
{
^
make[2]: *** [libmysqld/CMakeFiles/sql_embedded.dir/__/sql/semisync_slave.cc.o] 错误 1
make[1]: *** [libmysqld/CMakeFiles/sql_embedded.dir/all] 错误 2
make: *** [all] 错误 2

centos 7
gcc 版本 4.8.5 20150623 (Red Hat 4.8.5-11) (GCC)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.