<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a510196774的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a510196774</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a510196774]]></copyright><item><title><![CDATA[Query Rewrite Plugins]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995213</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995213</guid><author>a510196774</author><pubDate>Thu, 26 Apr 2018 14:01:00 +0800</pubDate><description><![CDATA[[root@ZST1 ~] mysql --login-path=3306 &lt;/usr/local/mysql/share/install_rewriter.sql

mydba@192.168.85.132,3306 [(none)]&gt; create database qrp_drop;
Query OK, 1 row affected (0.00 sec)
...]]></description><category></category></item><item><title><![CDATA[Identifying a Blocking Query After the Issuing Session Becomes Idle]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995214</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995214</guid><author>a510196774</author><pubDate>Thu, 26 Apr 2018 11:55:00 +0800</pubDate><description><![CDATA[Identifying a Blocking Query After the Issuing Session Becomes Idle

#查看阻塞信息
select * from sys.innodb_lock_waits\G
#根据blocking_pid得到源头会话的最后一个SQL
select a.*,c.thread_id,c.sql_text blocking_...]]></description><category></category></item><item><title><![CDATA[MySQL二进制包安装及启动问题排查]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995212</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995212</guid><author>a510196774</author><pubDate>Fri, 01 Sep 2017 18:09:00 +0800</pubDate><description><![CDATA[环境部署：VMware10.0+CentOS6.9(64位)+MySQL5.7.19(64位)一、操作系统调整


# 更改时区
1、先查看时区
[root@localhost ~]# date -R
Tue, 29 Aug 2017 20:13:00 -0700
2、将Asia/shanghai-上海时区写入当前时区
[root@localhost ~]# cp -f ...]]></description><category></category></item><item><title><![CDATA[数据库、数据表信息]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995210</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995210</guid><author>a510196774</author><pubDate>Tue, 22 Aug 2017 17:38:00 +0800</pubDate><description><![CDATA[# 数据库信息
select s.schema_name,t.dbsize_mb,s.default_character_set_name,s.default_collation_name
from information_schema.schemata s
inner join(
select table_schema,round(sum((data_length+inde...]]></description><category></category></item><item><title><![CDATA[通过key_len分析联合索引的使用]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995211</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995211</guid><author>a510196774</author><pubDate>Mon, 21 Aug 2017 17:02:00 +0800</pubDate><description><![CDATA[The key_len column indicates the length of the key that MySQL decided to use. The length is NULL if the key column says NULL. Note that the value of key_len enables you to determine how many part...]]></description><category></category></item><item><title><![CDATA[ERROR 1839 (HY000): @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995209</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995209</guid><author>a510196774</author><pubDate>Fri, 21 Jul 2017 16:50:00 +0800</pubDate><description><![CDATA[从cdb上dump一个库结构，准备与本地结构做对比(可以直接compare，但速度贼慢)。使用dump脚本在本地创建的时候报错


-- 导出指定库的结构
shell&gt; mysqldump -hxxx.cdb.myqcloud.com -P123456 -uuser -ppassword -d db_12312&gt;F:\JTJF\ER\db_12312_yun.sql...]]></description><category></category></item><item><title><![CDATA[stop slave->reset slave->start slave 复制从哪个位置开始？reset slave all呢？]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995207</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995207</guid><author>a510196774</author><pubDate>Wed, 19 Jul 2017 17:28:00 +0800</pubDate><description><![CDATA[reset slave首先来看下当前master-slave情况


mysql&gt; prompt \u@\h,\p:\d&gt;\_
PROMPT set to '\u@\h,\p:\d&gt;\_'

# master
mydba@192.168.85.129,3306:test&gt; show master status;
+-----------------...]]></description><category></category></item><item><title><![CDATA[用户管理模块之mysql.user]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995206</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995206</guid><author>a510196774</author><pubDate>Sat, 15 Jul 2017 16:58:00 +0800</pubDate><description><![CDATA[不使用-h参数来指定登录host，默认会连接localhost，仅当mysql.user表中有一条对应的localhost访问授权(username@%不对任何主机做限制也不行)时登录才成功，否则登录会被拒绝。虚拟机VMUest上安装两个MySQL实例，两个实例搭建了Master(端口3306)-Slave(端口3307)，主从数据完全一致。


mysql&gt; select ...]]></description><category></category></item><item><title><![CDATA[压测：mysqlslap]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995180</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995180</guid><author>a510196774</author><pubDate>Wed, 24 May 2017 18:12:00 +0800</pubDate><description><![CDATA[MySQL从5.1.4版开始带有一个压力测试工具mysqlslap，通过模拟多个并发客户端访问mysql来执行测试，使用起来非常简单，通过mysqlslap –help可以获得可用的选项。这里列一些主要的参数，更详细的说明参考官方手册。


-a, --auto-generate-sql
自动生成测试表和数据
--auto-generate-sql-load-type=name...]]></description><category></category></item><item><title><![CDATA[ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot exec...]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995181</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995181</guid><author>a510196774</author><pubDate>Wed, 24 May 2017 11:47:00 +0800</pubDate><description><![CDATA[使用load data导入数据时


mysql&gt; load data infile '/myshare/area_info.txt' into table area_info;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot ex...]]></description><category></category></item><item><title><![CDATA[binlog2sql]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995205</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995205</guid><author>a510196774</author><pubDate>Tue, 23 May 2017 18:22:00 +0800</pubDate><description><![CDATA[看到使用binlog2sql恢复数据，测试玩玩~环境：CentOS6.5源码安装多个MySQL实例及复制搭建由于原先的复制采用binlog-format=mixed，先将其修改为binlog-format=row


/******** 测试环境，步骤简化 ********/
#Master上操作
[root@VMUest ~]# mysqldump -uroot -p -P3...]]></description><category></category></item><item><title><![CDATA[Win7下SQLServer访问虚拟机上的MySQL]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995204</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995204</guid><author>a510196774</author><pubDate>Mon, 22 May 2017 13:56:00 +0800</pubDate><description><![CDATA[一、确保Win7能telnet通MySQL端口，防火墙设置可参考http://www.cnblogs.com/ShanFish/p/6519950.html二、配置系统DSN1、在Win7上安装MySQL ODBC驱动2、管理工具-&gt;ODBC数据源-&gt;系统DSN-&gt;添加-&gt;选择[MySQL ODBC 5.3 Unicode Driver]-&gt;完成-&gt;配...]]></description><category></category></item><item><title><![CDATA[Percona Toolkit]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995202</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995202</guid><author>a510196774</author><pubDate>Sat, 01 Apr 2017 15:55:00 +0800</pubDate><description><![CDATA[前两天折腾了mysqlsla，今天才发现hackmysql.com中的工具已沦为历史产物，建议使用Percona Toolkit代替。一、下载安装

[root@VMUest tools]# wget https://www.percona.com/downloads/percona-toolkit/3.0.2/binary/tarball/percona-toolkit-3.0.2...]]></description><category></category></item><item><title><![CDATA[Starting MySQL ** mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995201</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995201</guid><author>a510196774</author><pubDate>Fri, 31 Mar 2017 16:45:00 +0800</pubDate><description><![CDATA[本地虚拟机(CentOS6.8)启动MySQL(MySQL5.6.35)服务失败

[root@VMUest ~]# service mysql status
 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
[root@VMUest ~]# rm -f /var/lock/su...]]></description><category></category></item><item><title><![CDATA[慢日志：mysqlsla]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995198</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995198</guid><author>a510196774</author><pubDate>Thu, 30 Mar 2017 16:14:00 +0800</pubDate><description><![CDATA[Linux服务器收集到的慢日志文件拿到本地(Windows7)的虚拟机(CentOS6.5)中去分析。首先使用Samba工具配置CentOS和Windows文件共享，然后使用mysqlsla分析慢查询日志。环境：CentOS6.5源码安装多个MySQL实例及复制搭建
一、CentOS和Windows文件共享1.1、安装Samba

[root@VMUest ~]# yum inst...]]></description><category></category></item><item><title><![CDATA[抓包：MySQL Sniffer]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995200</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995200</guid><author>a510196774</author><pubDate>Tue, 28 Mar 2017 22:01:00 +0800</pubDate><description><![CDATA[1、依赖文件安装

依赖glib2-devel、libpcap-devel、libnet-devel
[root@VMUest ~]# yum install cmake
[root@VMUest ~]# yum install libpcap-devel
[root@VMUest ~]# yum install glib2-devel
[root@VMUest ~]# yu...]]></description><category></category></item><item><title><![CDATA[Percona XtraBackup]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995196</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995196</guid><author>a510196774</author><pubDate>Tue, 28 Mar 2017 18:17:00 +0800</pubDate><description><![CDATA[本文主要参考xtrabackup 详解和马哥linux干货分享使用Xtrabackup进行MySQL备份一、安装

[root@VMUest tools]# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.6/binary/tarball/percona-xtrabackup-2.4.6...]]></description><category></category></item><item><title><![CDATA[MySQL-Utilities：mysqldbcompare及跳过复制错误]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995197</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995197</guid><author>a510196774</author><pubDate>Wed, 15 Mar 2017 12:58:00 +0800</pubDate><description><![CDATA[mysqldbcompare也是MySQL-Utilities工具集的一个脚本。mysqldbcompare从两个数据库比较对象和数据的不同。数据库中的对象包括：表、视图、触发器、存储过程、函数和事件。每一个对象类型计数可以使用-vv选项显示。通过一系列步骤检查进行测试，默认情况下，一旦测试失败就终止检测。可以指定--run-all-tests选项来进行所有的测试。环境：CentOS6....]]></description><category></category></item><item><title><![CDATA[CentOS6.5下源码安装多个MySQL实例及复制搭建]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995193</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995193</guid><author>a510196774</author><pubDate>Tue, 14 Mar 2017 17:13:00 +0800</pubDate><description><![CDATA[多实例安装本节是在CentOS6.5下源码安装MySQL5.6.35的基础上，在同一台机器增加一个MySQL实例。参考Centos中安装多个mysql数据的配置实例，安装目录为/usr/local/mysql3307/

6、目录创建(-p父目录不存在则创建此目录)
[root@VMUest ~]# cd mysql-5.6.35
[root@VMUest mysql-5.6.3...]]></description><category></category></item><item><title><![CDATA[MySQL Server Logs]]></title><link>https://blog.youkuaiyun.com/a510196774/article/details/101995194</link><guid>https://blog.youkuaiyun.com/a510196774/article/details/101995194</guid><author>a510196774</author><pubDate>Mon, 13 Mar 2017 15:17:00 +0800</pubDate><description><![CDATA[日志记录存储方式

#日志记录存储方式
mysql&gt; show variables like 'log_output';
mysql&gt; set global log_output='FILE,TABLE';

1、错误日志

#1、错误日志
mysql&gt; show variables like 'log_error';
+--------------...]]></description><category></category></item></channel></rss>