![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
qq_34145309
这个作者很懒,什么都没留下…
展开
-
2020-08-15
cmake /tmp/build_mysql/mysql-5.7.27 \-DWITH_BOOST=/tmp/build_mysql/boost_1_59_0 \-DDEFAULT_CHARSET=utf8mb4 \-DDEFAULT_COLLATION=utf8mb4_general_ci \-DENABLED_LOCAL_INFILE=1 \-DCURSES_LIBRARY=/usr/lib64/ncurses6 \-DCURSES_INCLUDE_PATH=/usr/include/ncu原创 2020-08-15 01:00:09 · 107 阅读 · 0 评论 -
c++通过mariadb connector连接mysql8.0
#include#include<mariadb/mysql.h>int main(int argc, char* argv[]) {MYSQL* con = mysql_init(nullptr);MYSQL_RES* res;MYSQL_ROW row;MYSQL_FIELD* fields;int column_count;int i;if (!con){s...原创 2019-11-10 17:24:28 · 925 阅读 · 0 评论 -
suse11.3无法编译mysql8.0
https://stackoverflow.com/questions/30346649/pthread-setname-np-was-not-declared-in-this-scopegetconf GNU_LIBC_VERSION原创 2019-10-24 23:03:04 · 217 阅读 · 0 评论 -
suse11.3源码编译安装mysql5.7.27
准备工作下载gmp mpc mpfr的源码包(源码编译gcc需要)下载gcc4.8.5(支持c++11即可)源码包下载openssl源码包(源码编译cmake需要)下载cmake源码包(suse11.3没有cmake 源码编译mysql需要cmake)下载boost1.59源码包(源码编译mysql需要 必须是1.59版本)下载mysql5.7.27源码包将以上源码包解压后放在一个临时文件夹 比如/tmp/mysql 依次编译原创 2019-08-15 07:55:23 · 249 阅读 · 0 评论 -
mysql主从
生成配置文件cat <<EOF | tee /etc/mysql_330{6,7}.cnf[server]port=3306datadir=/usr/local/mysql/data_3306socket=/usr/local/mysql/data_3306/mysql.sockpid_file=/usr/local/mysql/data_3306/mysql.pide...原创 2019-09-05 00:24:16 · 102 阅读 · 1 评论 -
mysql性能监控
mysqlslap -hlocalhost -uroot -pmysql --socket=/usr/local/mysql/data_3306/mysql.sock --concurrency=100 --auto-generate-sql --auto-generate-sql-load-type=mixed --engine=innodb --auto-generate-sql-ad...原创 2019-09-05 00:51:29 · 98 阅读 · 0 评论