<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/jsCPB</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; jsCPB]]></copyright><item><title><![CDATA[【转】tcpdump 抓包mysql网络分析+使用wireshark分析]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/127950555</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/127950555</guid><author>jsCPB</author><pubDate>Sun, 20 Nov 2022 16:28:52 +0800</pubDate><description><![CDATA[mysql使用tcpdump抓包，使用wireshark分析]]></description><category></category></item><item><title><![CDATA[【转】网络TCP的三次握手和四次握手]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/127950345</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/127950345</guid><author>jsCPB</author><pubDate>Sun, 20 Nov 2022 16:15:41 +0800</pubDate><description><![CDATA[tcp三次握手和四次握手]]></description><category></category></item><item><title><![CDATA[【转】SSD、HDD、NVMe区别]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/127903690</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/127903690</guid><author>jsCPB</author><pubDate>Thu, 17 Nov 2022 15:21:20 +0800</pubDate><description><![CDATA[ssd、hdd、nvme区别对比]]></description><category></category></item><item><title><![CDATA[【转】PG集群高可用中对脑裂的防止与恢复]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/127901036</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/127901036</guid><author>jsCPB</author><pubDate>Thu, 17 Nov 2022 11:42:02 +0800</pubDate><description><![CDATA[本文主要探讨了PG流复制集群脑裂问题的影响因素以及避免脑裂的手段，最后也针对脑裂的自动探测和恢复提出了个人的见解，上述各章节中讨论的手段需要有机配才能合达成预防、探测、积极处理，以期能完善PG集群高可用对脑裂这一棘手问题的处理。]]></description><category></category></item><item><title><![CDATA[【mysql案例】mysql5.7第一次登录提示修改密码]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/100750816</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/100750816</guid><author>jsCPB</author><pubDate>Wed, 11 Sep 2019 22:01:30 +0800</pubDate><description><![CDATA[问题：

mysql启动后，第一次登录提示修改密码


mysql&gt; show processlist;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决：


mysql&gt; alter user root...]]></description><category></category></item><item><title><![CDATA[【mysql案例】mysql 5.7日志文件里面时间的时区不对的问题]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/100749127</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/100749127</guid><author>jsCPB</author><pubDate>Wed, 11 Sep 2019 21:39:29 +0800</pubDate><description><![CDATA[问题：

新安装的MySQL5.7.27，发现error log、general log日志里面日志时间的时区不对。

error log


2019-09-11T12:53:23.988658Z 0 [Warning] CA certificate ca.pem is self signed.
2019-09-11T12:53:24.007777Z 0 [Note] Server hostn...]]></description><category></category></item><item><title><![CDATA[【mysql案例】mysql5.6--ERROR 1776 (HY000)-change master to遇到的报错]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/49005087</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/49005087</guid><author>jsCPB</author><pubDate>Fri, 09 Oct 2015 20:09:15 +0800</pubDate><description><![CDATA[ERROR 1776 (HY000): ParametersMASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be setwhen MASTER_AUTO_POSITION is active.]]></description><category></category></item><item><title><![CDATA[【MySQL案例】Zabbix agent导致的Error in accept: Too many open files in system无法访问msyql数据库]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/48621211</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/48621211</guid><author>jsCPB</author><pubDate>Mon, 21 Sep 2015 06:41:03 +0800</pubDate><description><![CDATA[Zabbix agent导致的Error in accept: Too many open files in system无法访问msyql数据库
【环境描述】
Mysql 5.5.21
 
【情况描述】
现象数据库处于运行状态，但是无法创建新的连接，监控报警“Timeout while attempting connection”
 
[root@db11149 ~]# mysql]]></description><category></category></item><item><title><![CDATA[【MySQL案例】MySQL5.7如何配置多源复制Multi-source replication]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/48478737</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/48478737</guid><author>jsCPB</author><pubDate>Tue, 15 Sep 2015 23:36:02 +0800</pubDate><description><![CDATA[MySQL5.7如何配置多源复制Multi-source replication]]></description><category></category></item><item><title><![CDATA[【MySQL案例】tpcc--执行tpcc_load报错error while loading shared libraries: libperconaserverclient.s]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/41544641</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/41544641</guid><author>jsCPB</author><pubDate>Thu, 27 Nov 2014 13:08:35 +0800</pubDate><description><![CDATA[【报错信息】
针对mysql官方社区版进行测试的时候，执行tpcc_load脚本提示缺少libperconaserverclient.so.18库文件：
time ./tpcc_load 127.0.0.1 tpcc1000 root"" 500
./tpcc_load: error while loading sharedlibraries: libperconaserverclient.so.18: cannot open shared object file: Nosuch file or direc]]></description><category></category></item><item><title><![CDATA[【MySQL案例】tpcc测试--执行tpcc_start报错Segmentation fault]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/41543947</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/41543947</guid><author>jsCPB</author><pubDate>Thu, 27 Nov 2014 11:42:11 +0800</pubDate><description><![CDATA[【报错信息】
执行进行tpcc_start测试的时候遇到报错：
tpcc_test.sh: line 12: 24509 Segmentationfault      ./tpcc_start
【报错原因】
是由于重新安装了mysql软件，并且mysql的版本是不一样的，而tpcc是编译安装的，所以导致tpcc调用安装时编译的mysql lib库文件失败。
【解决方法】
重新编译安装tpcc-mysql，需要使用没有执行过make编译的源码包（重新下载）。]]></description><category></category></item><item><title><![CDATA[【Linux案例】mount: Structure needs cleaning]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38497623</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38497623</guid><author>jsCPB</author><pubDate>Mon, 11 Aug 2014 20:00:39 +0800</pubDate><description><![CDATA[解决方法
     可以使用xfs_repair来修复，但是要注意 xfs_repair修复的分区中的文件都会丢失，即使是du能正常显示的文件也会丢失。
      处理步骤：
                   umount /home
                  xfs_repair  /home
                  mount /home]]></description><category></category></item><item><title><![CDATA[【MySQL案例】ERROR 1418]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38371519</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38371519</guid><author>jsCPB</author><pubDate>Mon, 04 Aug 2014 16:34:57 +0800</pubDate><description><![CDATA[By default, for a CREATE FUNCTION statement to be accepted, at least one of DETERMINISTIC, NOSQL, or READS SQL DATA must be specified explicitly.
Otherwise an error occurs:
ERROR1418 (HY000): This function has none of DETERMINISTIC, NO SQL,or READSSQL DATA]]></description><category></category></item><item><title><![CDATA[【Linux知识】服务器性能测试--UnixBench]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38309079</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38309079</guid><author>jsCPB</author><pubDate>Thu, 31 Jul 2014 00:07:42 +0800</pubDate><description><![CDATA[dell r720和dell r610的unixbench性能测试]]></description><category></category></item><item><title><![CDATA[【MySQL案例】show processlist显示SQL线程运行时间time是负数]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38307203</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38307203</guid><author>jsCPB</author><pubDate>Wed, 30 Jul 2014 21:21:16 +0800</pubDate><description><![CDATA[引用链接地址： http://www.fosiul.com/mysql-server-processlist-shows-negative-value-in-connect-column-for-system-user/



原文：

Mysql Server processlist shows negative value(-) in connect column for syst]]></description><category></category></item><item><title><![CDATA[【MySQL案例】]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38306955</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38306955</guid><author>jsCPB</author><pubDate>Wed, 30 Jul 2014 21:01:51 +0800</pubDate><description><![CDATA[引用链接地址： http://www.fosiul.com/mysql-server-processlist-shows-negative-value-in-connect-column-for-system-user/



原文：

Mysql Server processlist shows negative value(-) in connect column for syst]]></description><category></category></item><item><title><![CDATA[【MySQL案例】mysql本机登录-S失效]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/38119623</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/38119623</guid><author>jsCPB</author><pubDate>Fri, 25 Jul 2014 15:43:47 +0800</pubDate><description><![CDATA[mysql客户端连接mysql数据库的时候，如果同时指定了socket和host的时候，mysql会采用TCP/IP协议登录，此时socket会被忽略，默认情况下访问3306端口。]]></description><category></category></item><item><title><![CDATA[【MySQL案例】error.log的Warning：If a crash happens thisconfiguration does not guarantee that the relay lo]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/36422121</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/36422121</guid><author>jsCPB</author><pubDate>Wed, 02 Jul 2014 15:31:50 +0800</pubDate><description><![CDATA[Slave crash-safe replication
mysql的slave启动时，error.log中出现Warning警告：
[Warning] Slave SQL: If a crash happensthis configuration does not guarantee that the relay log info will beconsistent, Error_code: 0]]></description><category></category></item><item><title><![CDATA[【MySQL案例】HA: GTID_MODE配置不一致]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/36422039</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/36422039</guid><author>jsCPB</author><pubDate>Wed, 02 Jul 2014 15:28:32 +0800</pubDate><description><![CDATA[Last_IO_Error: The slave IO thread stopsbecause the master has @@GLOBAL.GTID_MODE OFF and this server has@@GLOBAL.GTID_MODE ON]]></description><category></category></item><item><title><![CDATA[【MySQL案例】ERROR 1786 (HY000)]]></title><link>https://blog.youkuaiyun.com/jsCPB/article/details/36241259</link><guid>https://blog.youkuaiyun.com/jsCPB/article/details/36241259</guid><author>jsCPB</author><pubDate>Tue, 01 Jul 2014 23:49:02 +0800</pubDate><description><![CDATA[create tablelgmnr_bak select * from lgmnr;  
ERROR 1786 (HY000): CREATE TABLE ... SELECTis forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1]]></description><category></category></item></channel></rss>