<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>深蓝的blog &#187; Mysql</title>
	<atom:link href="http://www.lanxinbase.com/?feed=rss2&#038;tag=mysql" rel="self" type="application/rss+xml" />
	<link>http://www.lanxinbase.com</link>
	<description>记录日常生活</description>
	<lastBuildDate>Sat, 07 Feb 2026 10:59:52 +0000</lastBuildDate>
	<language>zh-CN</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=4.2.3</generator>
	<item>
		<title>Mysql 8.0 关闭binlog日志</title>
		<link>http://www.lanxinbase.com/?p=2866</link>
		<comments>http://www.lanxinbase.com/?p=2866#comments</comments>
		<pubDate>Thu, 18 Jan 2024 02:36:30 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[1.服务端语言]]></category>
		<category><![CDATA[2.运维相关]]></category>
		<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[binlog]]></category>
		<category><![CDATA[Mysql]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2866</guid>
		<description><![CDATA[Mysql8.0默认开启binlog记录功能，导致磁盘空间占用很大，8.0关闭的方式跟之前5.x的不太一样。  [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2866</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>分布式锁的三种实现方式</title>
		<link>http://www.lanxinbase.com/?p=2669</link>
		<comments>http://www.lanxinbase.com/?p=2669#comments</comments>
		<pubDate>Wed, 17 Nov 2021 08:21:47 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[1.服务端语言]]></category>
		<category><![CDATA[Curator]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[redis]]></category>
		<category><![CDATA[zookeeper]]></category>
		<category><![CDATA[分布式锁]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2669</guid>
		<description><![CDATA[分布式锁三种实现方式： 基于数据库实现分布式锁； 基于缓存（Redis等）实现分布式锁； 基于Zookeepe [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2669</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL参数 · innodb_additional_mem_pool_size</title>
		<link>http://www.lanxinbase.com/?p=2602</link>
		<comments>http://www.lanxinbase.com/?p=2602#comments</comments>
		<pubDate>Wed, 27 Jan 2021 07:59:23 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[innodb_additional_mem_pool_size]]></category>
		<category><![CDATA[Mysql]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2602</guid>
		<description><![CDATA[参数简介 innodb_additional_mem_pool_size 是 InnoDB 用来保存数据字典信 [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2602</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL的四种事务隔离级别</title>
		<link>http://www.lanxinbase.com/?p=2544</link>
		<comments>http://www.lanxinbase.com/?p=2544#comments</comments>
		<pubDate>Fri, 05 Jun 2020 02:07:08 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[1.服务端语言]]></category>
		<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[事务]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2544</guid>
		<description><![CDATA[一、事务的基本要素（ACID） 1、原子性（Atomicity）：事务开始后所有操作，要么全部做完，要么全部不 [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2544</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>CentOS 7x安装Mysql8.0.x</title>
		<link>http://www.lanxinbase.com/?p=2493</link>
		<comments>http://www.lanxinbase.com/?p=2493#comments</comments>
		<pubDate>Fri, 03 Jan 2020 11:44:24 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[2.运维相关]]></category>
		<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[CentOS]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[MySQL8.0]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2493</guid>
		<description><![CDATA[其实官网有教程的，我这里记录下来，是因为要写一个自动化安装脚本，虽然不经常用到，但是还是写出来比较好。 Mys [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2493</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>mysql频繁访问、读写配置</title>
		<link>http://www.lanxinbase.com/?p=2491</link>
		<comments>http://www.lanxinbase.com/?p=2491#comments</comments>
		<pubDate>Thu, 02 Jan 2020 06:07:01 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[2.运维相关]]></category>
		<category><![CDATA[Mysql]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2491</guid>
		<description><![CDATA[#BEGIN CONFIG INFO #DESCR: 4GB RAM, InnoDB only, ACID,  [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2491</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>mysql主从复制选项和变量</title>
		<link>http://www.lanxinbase.com/?p=2465</link>
		<comments>http://www.lanxinbase.com/?p=2465#comments</comments>
		<pubDate>Thu, 28 Nov 2019 02:45:51 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[auto_increment_increment]]></category>
		<category><![CDATA[auto_increment_offset]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[Replication Master]]></category>
		<category><![CDATA[主从复制]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2465</guid>
		<description><![CDATA[在主服务器和每个从服务器上，必须设置 server_id系统变量以建立唯一的复制ID。对于每个服务器，应选择一 [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2465</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>mysql执行delete大数据时建议的方法</title>
		<link>http://www.lanxinbase.com/?p=2454</link>
		<comments>http://www.lanxinbase.com/?p=2454#comments</comments>
		<pubDate>Thu, 21 Nov 2019 06:36:43 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[TRUNCATE]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2454</guid>
		<description><![CDATA[一张表可以存10几亿条的数据，特别是硬件上报的日志，特别多，而且还很多没有什么用的，某些数据库（本人试验mys [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2454</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>mysql utf8_unicode_ci与utf8_general_ci的区别</title>
		<link>http://www.lanxinbase.com/?p=2436</link>
		<comments>http://www.lanxinbase.com/?p=2436#comments</comments>
		<pubDate>Wed, 30 Oct 2019 01:15:25 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[utf8_general_ci]]></category>
		<category><![CDATA[utf8_unicode_ci]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2436</guid>
		<description><![CDATA[utf8_unicode_ci和utf8_general_ci对中、英文来说没有实质的差别。 utf8_gen [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2436</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL索引和查询优化</title>
		<link>http://www.lanxinbase.com/?p=2123</link>
		<comments>http://www.lanxinbase.com/?p=2123#comments</comments>
		<pubDate>Wed, 20 Mar 2019 02:45:33 +0000</pubDate>
		<dc:creator><![CDATA[Alan]]></dc:creator>
				<category><![CDATA[3.数据库相关]]></category>
		<category><![CDATA[Mysql]]></category>
		<category><![CDATA[索引]]></category>

		<guid isPermaLink="false">http://www.lanxinbase.com/?p=2123</guid>
		<description><![CDATA[索引相关 索引基数 基数是数据列所包含的不同值的数量，例如，某个数据列包含值 1、3、7、4、7、3，那么它的 [&#8230;]]]></description>
		<wfw:commentRss>http://www.lanxinbase.com/?feed=rss2&#038;p=2123</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
