惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Attack and Defense Labs
Attack and Defense Labs
The GitHub Blog
The GitHub Blog
C
Check Point Blog
博客园_首页
MongoDB | Blog
MongoDB | Blog
N
Netflix TechBlog - Medium
F
Full Disclosure
Microsoft Security Blog
Microsoft Security Blog
爱范儿
爱范儿
Recent Announcements
Recent Announcements
阮一峰的网络日志
阮一峰的网络日志
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
T
Threat Research - Cisco Blogs
C
Cybersecurity and Infrastructure Security Agency CISA
V
Vulnerabilities – Threatpost
K
Kaspersky official blog
博客园 - 司徒正美
S
Schneier on Security
T
The Exploit Database - CXSecurity.com
Project Zero
Project Zero
云风的 BLOG
云风的 BLOG
Cisco Talos Blog
Cisco Talos Blog
Know Your Adversary
Know Your Adversary
雷峰网
雷峰网
V
V2EX - 技术
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Spread Privacy
Spread Privacy
罗磊的独立博客
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
S
Security Affairs
SecWiki News
SecWiki News
Schneier on Security
Schneier on Security
O
OpenAI News
Jina AI
Jina AI
PCI Perspectives
PCI Perspectives
Cyberwarzone
Cyberwarzone
Y
Y Combinator Blog
Apple Machine Learning Research
Apple Machine Learning Research
B
Blog RSS Feed
I
InfoQ
D
Docker
P
Palo Alto Networks Blog
Recorded Future
Recorded Future
M
MIT News - Artificial intelligence
博客园 - Franky
B
Blog
Scott Helme
Scott Helme
博客园 - 叶小钗
D
DataBreaches.Net

博客园 - Mr.Myth

Problems with MMM for mysql(译文) MySQL MMM 双主在Failover时挂起 Steve Loughran:Why not raid 0,its about time and snowflakes!!! How to Clean Up After a Failed 10g or 11.1 Oracle Clusterware Installation [ID 239998.1] MySQL 5.5 外键不能引用分区表主键 MYSQL 登录漏洞,Percona Server说明 基于xtrabackup的Point-In-Time Recovery备份恢复 使用折半查找法删除 五月第二周 合肥之行 ORACLE 10G & patch下载地址大全 - Mr.Myth RED HAT ES 5.4 X64安装ORACLE 10G R2 64bit - Mr.Myth vmware server 安装oracle 10G RAC 实践(三) vmware server 安装oracle 10G RAC 实践(二) - Mr.Myth vmware server 安装oracle 10G RAC 实践(一) - Mr.Myth 内存数据库 Timesten - Mr.Myth IBM 中国研究院 Offer 之感言——能力是一种态度(转) XX项目----记录(一) 10G 更改IP地址或机器名后EM配置
percona server 二进制安装下编译tpcc-mysql的坑
Mr.Myth · 2015-04-23 · via 博客园 - Mr.Myth

出于习惯,percona server的部署都是通过二进制包自动化安装,结果遇到一个硕大无比的坑,编译TPCC-MySQL时出现警告

10:49:36 root@DB-Master:~/tpcc-mysql/src$ make
cc load.o support.o `mysql_config --libs_r` -lrt -L /usr/local/mysql/lib/ -o ../tpcc_load
/usr/bin/ld: warning: libssl.so.6, needed by /usr/local/mysql/lib//libperconaserverclient.so, may conflict with libssl.so.10
/usr/bin/ld: warning: libcrypto.so.6, needed by /usr/local/mysql/lib//libperconaserverclient.so, may conflict with libcrypto.so.10
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c main.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c spt_proc.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c driver.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c sequence.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c rthist.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c neword.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c payment.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c ordstat.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c delivery.c
cc -w -O2 -g -I. `mysql_config --include` -I /usr/local/mysql/include/ -c slev.c
cc main.o spt_proc.o driver.o support.o sequence.o rthist.o neword.o payment.o ordstat.o delivery.o slev.o `mysql_config --libs_r` -lrt -L /usr/local/mysql/lib/ -o ../tpcc_start
/usr/bin/ld: warning: libssl.so.6, needed by /usr/local/mysql/lib//libperconaserverclient.so, may conflict with libssl.so.10
/usr/bin/ld: warning: libcrypto.so.6, needed by /usr/local/mysql/lib//libperconaserverclient.so, may conflict with libcrypto.so.10

无视警告的后果是能load仓库,但是在tpcc_start测试时报segement fault

tail /var/log/message 如下

Apr 23 10:52:03 DB-Master kernel: tpcc_start[31075]: segfault at 0 ip 00007f723392b345 sp 00007f722fba2130 error 6 in libperconaserverclient.so.18.1.0[7f72338c1000+29d000]
Apr 23 11:14:38 DB-Master kernel: tpcc_start[9636]: segfault at 0 ip 00007fd82f5ba345 sp 00007fd82b831130 error 6 in libperconaserverclient.so.18.1.0[7fd82f550000+29d000]

从官网下载Percona-Server-shared-56-5.6.23-rel72.1.el6.x86_64.rpm

安装完毕,把/usr/lib64/目录下libperconaserverclient.so.18.1.0 文件覆盖到$MYSQL_HOME/lib下

cp /usr/lib64/libperconaserverclient.so.18.1.0 /usr/local/mysql/lib/

重新编译成功!

另外在这个场景下还需要修改Makefile文件,制定对应的-I  $MYSQL_HOME/include/ 和 -L $MYSQL_HOME/lib/