René's URL Explorer Experiment

Title: fullstack-tutorial/notes/MySQL.md at master · giaming/fullstack-tutorial · GitHub

Open Graph Title: fullstack-tutorial/notes/MySQL.md at master · giaming/fullstack-tutorial

X Title: fullstack-tutorial/notes/MySQL.md at master · giaming/fullstack-tutorial

Description: 🚀 fullstack tutorial 2022，后台技术栈/架构师之路/全栈开发社区，春招/秋招/校招/面试 - fullstack-tutorial/notes/MySQL.md at master · giaming/fullstack-tutorial

Open Graph Description: 🚀 fullstack tutorial 2022，后台技术栈/架构师之路/全栈开发社区，春招/秋招/校招/面试 - giaming/fullstack-tutorial

X Description: 🚀 fullstack tutorial 2022，后台技术栈/架构师之路/全栈开发社区，春招/秋招/校招/面试 - giaming/fullstack-tutorial

Opengraph URL: https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md

X: @github

direct link

Domain: github.com

route-pattern	/:user_id/:repository/blob/name(/path)
route-controller	blob
route-action	show
fetch-nonce	v2:23851e9c-460a-e8e5-0adb-c4c33b6b25f0
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	BB88:2F98EE:C993364:10FA1B01:6A5F23F0
html-safe-nonce	5097ddcce2d10126e0c8d6b2d8d7b95272f70ce58a3439aa717487b9d7551949
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQjg4OjJGOThFRTpDOTkzMzY0OjEwRkExQjAxOjZBNUYyM0YwIiwidmlzaXRvcl9pZCI6IjUxMDI0NjUwODI2NTMwOTA4MDAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac	307cb97003197ade9c46b555de02c5c418274adc255d61aa9c237d07acc24a92
hovercard-subject-tag	repository:474326395
github-keyboard-shortcuts	repository,source-code,file-tree,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	///blob/show
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md
twitter:image	https://opengraph.githubassets.com/bc57e38443e3ce0c6eb424bdb3990ec51b088b7fcbec8dfe1b4b150680c08420/giaming/fullstack-tutorial
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/bc57e38443e3ce0c6eb424bdb3990ec51b088b7fcbec8dfe1b4b150680c08420/giaming/fullstack-tutorial
og:image:alt	🚀 fullstack tutorial 2022，后台技术栈/架构师之路/全栈开发社区，春招/秋招/校招/面试 - giaming/fullstack-tutorial
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	af57322612a2efc3d6fee860947245ffbb465e4e3f9eb5dfefc0f770217aa0ca
turbo-cache-control	no-cache
go-import	github.com/giaming/fullstack-tutorial git https://github.com/giaming/fullstack-tutorial.git
octolytics-dimension-user_id	24700003
octolytics-dimension-user_login	giaming
octolytics-dimension-repository_id	474326395
octolytics-dimension-repository_nwo	giaming/fullstack-tutorial
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	true
octolytics-dimension-repository_parent_id	129332826
octolytics-dimension-repository_parent_nwo	frank-lam/fullstack-tutorial
octolytics-dimension-repository_network_root_id	129332826
octolytics-dimension-repository_network_root_nwo	frank-lam/fullstack-tutorial
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	93fabb5edc1b64676979fa226fed14ab56431f54
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgiaming%2Ffullstack-tutorial%2Fblob%2Fmaster%2Fnotes%2FMySQL.md
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
Code QualityEnforce quality at merge	https://github.com/features/code-quality
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/open-source/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/open-source/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/enterprise/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgiaming%2Ffullstack-tutorial%2Fblob%2Fmaster%2Fnotes%2FMySQL.md
Sign up	https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fblob%2Fshow&source=header-repo&source_repo=giaming%2Ffullstack-tutorial
Reload	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md
Reload	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md
Reload	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md
giaming	https://github.com/giaming
fullstack-tutorial	https://github.com/giaming/fullstack-tutorial
frank-lam/fullstack-tutorial	https://github.com/frank-lam/fullstack-tutorial
Notifications	https://github.com/login?return_to=%2Fgiaming%2Ffullstack-tutorial
Fork 0	https://github.com/login?return_to=%2Fgiaming%2Ffullstack-tutorial
Star 0	https://github.com/login?return_to=%2Fgiaming%2Ffullstack-tutorial
Code	https://github.com/giaming/fullstack-tutorial
Pull requests 0	https://github.com/giaming/fullstack-tutorial/pulls
Actions	https://github.com/giaming/fullstack-tutorial/actions
Projects	https://github.com/giaming/fullstack-tutorial/projects
Security and quality 0	https://github.com/giaming/fullstack-tutorial/security
Insights	https://github.com/giaming/fullstack-tutorial/pulse
Code	https://github.com/giaming/fullstack-tutorial
Pull requests	https://github.com/giaming/fullstack-tutorial/pulls
Actions	https://github.com/giaming/fullstack-tutorial/actions
Projects	https://github.com/giaming/fullstack-tutorial/projects
Security and quality	https://github.com/giaming/fullstack-tutorial/security
Insights	https://github.com/giaming/fullstack-tutorial/pulse
	https://github.com/giaming/fullstack-tutorial
fullstack-tutorial	https://github.com/giaming/fullstack-tutorial/tree/master
notes	https://github.com/giaming/fullstack-tutorial/tree/master/notes
History	https://github.com/giaming/fullstack-tutorial/commits/master/notes/MySQL.md
	https://github.com/giaming/fullstack-tutorial/commits/master/notes/MySQL.md
fullstack-tutorial	https://github.com/giaming/fullstack-tutorial/tree/master
notes	https://github.com/giaming/fullstack-tutorial/tree/master/notes
Raw	https://github.com/giaming/fullstack-tutorial/raw/refs/heads/master/notes/MySQL.md
前言	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%89%8D%E8%A8%80
第一部分：MySQL基础	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E7%AC%AC%E4%B8%80%E9%83%A8%E5%88%86mysql%E5%9F%BA%E7%A1%80
MySQL的多存储引擎架构	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#mysql%E7%9A%84%E5%A4%9A%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E6%9E%B6%E6%9E%84
1. 什么是事务	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1
AUTOCOMMIT	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#autocommit
2. 数据库ACID	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%95%B0%E6%8D%AE%E5%BA%93acid
1. 原子性（Atomicity）	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%8E%9F%E5%AD%90%E6%80%A7atomicity
2. 一致性（Consistency）	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E4%B8%80%E8%87%B4%E6%80%A7consistency
3. 隔离性（Isolation）	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E9%9A%94%E7%A6%BB%E6%80%A7isolation
4. 持久性（Durability）	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%8C%81%E4%B9%85%E6%80%A7durability
3. 数据库中的范式	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E7%9A%84%E8%8C%83%E5%BC%8F
1. 第一范式 (1NF)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E7%AC%AC%E4%B8%80%E8%8C%83%E5%BC%8F-1nf
2. 第二范式 (2NF)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E7%AC%AC%E4%BA%8C%E8%8C%83%E5%BC%8F-2nf
3. 第三范式 (3NF)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E7%AC%AC%E4%B8%89%E8%8C%83%E5%BC%8F-3nf
4. 并发一致性问题	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E5%B9%B6%E5%8F%91%E4%B8%80%E8%87%B4%E6%80%A7%E9%97%AE%E9%A2%98
1. 丢失修改	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B8%A2%E5%A4%B1%E4%BF%AE%E6%94%B9
2. 脏读	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E8%84%8F%E8%AF%BB
3. 不可重复读	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E4%B8%8D%E5%8F%AF%E9%87%8D%E5%A4%8D%E8%AF%BB
4. 幻读	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E5%B9%BB%E8%AF%BB
5. 事务隔离级别	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E4%BA%8B%E5%8A%A1%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB
1. 串行化 (Serializable)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B8%B2%E8%A1%8C%E5%8C%96-serializable
2. 可重复读 (Repeated Read)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E5%8F%AF%E9%87%8D%E5%A4%8D%E8%AF%BB-repeated-read
3. 读已提交 (Read Committed)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E8%AF%BB%E5%B7%B2%E6%8F%90%E4%BA%A4-read-committed
4. 读未提交 (Read Uncommitted)	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E8%AF%BB%E6%9C%AA%E6%8F%90%E4%BA%A4-read-uncommitted
6. 存储引擎	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E
简介	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E7%AE%80%E4%BB%8B
1. MyISAM	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-myisam
2. InnoDB	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-innodb
3. CSV	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-csv
4. Archive	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-archive
5. Memory	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-memory
6. Federated	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-federated
问：独立表空间和系统表空间应该如何抉择	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%97%AE%E7%8B%AC%E7%AB%8B%E8%A1%A8%E7%A9%BA%E9%97%B4%E5%92%8C%E7%B3%BB%E7%BB%9F%E8%A1%A8%E7%A9%BA%E9%97%B4%E5%BA%94%E8%AF%A5%E5%A6%82%E4%BD%95%E6%8A%89%E6%8B%A9
问：如何选择存储引擎	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%97%AE%E5%A6%82%E4%BD%95%E9%80%89%E6%8B%A9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E
问：MyISAM和InnoDB引擎的区别	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%97%AEmyisam%E5%92%8Cinnodb%E5%BC%95%E6%93%8E%E7%9A%84%E5%8C%BA%E5%88%AB
问：为什么不建议 InnoDB 使用亿级大表	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%97%AE%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%8D%E5%BB%BA%E8%AE%AE-innodb-%E4%BD%BF%E7%94%A8%E4%BA%BF%E7%BA%A7%E5%A4%A7%E8%A1%A8
7. MySQL数据类型	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-mysql%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B
1. 整型	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E6%95%B4%E5%9E%8B
2. 浮点数	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%B5%AE%E7%82%B9%E6%95%B0
3. 字符串	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%AD%97%E7%AC%A6%E4%B8%B2
4. 时间和日期	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%97%B6%E9%97%B4%E5%92%8C%E6%97%A5%E6%9C%9F
DATETIME	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#datetime
TIMESTAMP	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#timestamp
8. 索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#8-%E7%B4%A2%E5%BC%95
1. 索引使用的场景	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E7%B4%A2%E5%BC%95%E4%BD%BF%E7%94%A8%E7%9A%84%E5%9C%BA%E6%99%AF
2. B Tree 原理	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-b-tree-%E5%8E%9F%E7%90%86
B-Tree	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#b-tree
B+Tree	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#btree
顺序访问指针	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%A1%BA%E5%BA%8F%E8%AE%BF%E9%97%AE%E6%8C%87%E9%92%88
优势	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%BC%98%E5%8A%BF
3. 索引分类	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E7%B4%A2%E5%BC%95%E5%88%86%E7%B1%BB
B+Tree 索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#btree-%E7%B4%A2%E5%BC%95
哈希索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%93%88%E5%B8%8C%E7%B4%A2%E5%BC%95
全文索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%85%A8%E6%96%87%E7%B4%A2%E5%BC%95
空间数据索引（R-Tree）	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E7%A9%BA%E9%97%B4%E6%95%B0%E6%8D%AE%E7%B4%A2%E5%BC%95r-tree
4. 索引的特点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E7%B4%A2%E5%BC%95%E7%9A%84%E7%89%B9%E7%82%B9
5. 索引的优点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BC%98%E7%82%B9
6. 索引的缺点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E7%B4%A2%E5%BC%95%E7%9A%84%E7%BC%BA%E7%82%B9
7. 索引失效	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88
8. 在什么情况下适合建立索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#8-%E5%9C%A8%E4%BB%80%E4%B9%88%E6%83%85%E5%86%B5%E4%B8%8B%E9%80%82%E5%90%88%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95
9. 为什么用B+树做索引而不用B-树或红黑树	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#9-%E4%B8%BA%E4%BB%80%E4%B9%88%E7%94%A8b%E6%A0%91%E5%81%9A%E7%B4%A2%E5%BC%95%E8%80%8C%E4%B8%8D%E7%94%A8b-%E6%A0%91%E6%88%96%E7%BA%A2%E9%BB%91%E6%A0%91
10. 联合索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#10-%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95
1. 什么是联合索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%BB%80%E4%B9%88%E6%98%AF%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95
2. 命名规则	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E5%91%BD%E5%90%8D%E8%A7%84%E5%88%99
3. 创建索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95
4. 索引类型	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E7%B4%A2%E5%BC%95%E7%B1%BB%E5%9E%8B
5. 删除索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E5%88%A0%E9%99%A4%E7%B4%A2%E5%BC%95
6. 什么情况下使用索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E4%BB%80%E4%B9%88%E6%83%85%E5%86%B5%E4%B8%8B%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95
11. 主键、外键和索引的区别	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#11-%E4%B8%BB%E9%94%AE%E5%A4%96%E9%94%AE%E5%92%8C%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB
12. 聚集索引与非聚集索引	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#12-%E8%81%9A%E9%9B%86%E7%B4%A2%E5%BC%95%E4%B8%8E%E9%9D%9E%E8%81%9A%E9%9B%86%E7%B4%A2%E5%BC%95
13. 数据库中的分页查询语句怎么写，如何优化	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#13-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E7%9A%84%E5%88%86%E9%A1%B5%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E6%80%8E%E4%B9%88%E5%86%99%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96
14. 常用的数据库有哪些？Redis用过吗？	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#14-%E5%B8%B8%E7%94%A8%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%89%E5%93%AA%E4%BA%9Bredis%E7%94%A8%E8%BF%87%E5%90%97
15. Redis的数据结构	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#15-redis%E7%9A%84%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84
16. 分库分表	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#16-%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8
1. 垂直切分	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86
垂直切分的优点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86%E7%9A%84%E4%BC%98%E7%82%B9
垂直切分的缺点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86%E7%9A%84%E7%BC%BA%E7%82%B9
2. 水平切分	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86
水平切分的优点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86%E7%9A%84%E4%BC%98%E7%82%B9
水平切分的缺点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86%E7%9A%84%E7%BC%BA%E7%82%B9
垂直切分和水平切分的共同点	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86%E5%92%8C%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86%E7%9A%84%E5%85%B1%E5%90%8C%E7%82%B9
3. Sharding 策略	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-sharding-%E7%AD%96%E7%95%A5
4. Sharding 存在的问题及解决方案	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-sharding-%E5%AD%98%E5%9C%A8%E7%9A%84%E9%97%AE%E9%A2%98%E5%8F%8A%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88
事务问题	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%BA%8B%E5%8A%A1%E9%97%AE%E9%A2%98
JOIN	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#join
ID 唯一性	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#id-%E5%94%AF%E4%B8%80%E6%80%A7
17. 主从复制与读写分离	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#17-%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6%E4%B8%8E%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB
主从复制	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6
读写分离	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB
18. 查询性能优化	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#18-%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96
1. 使用 Explain 进行分析	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%BD%BF%E7%94%A8-explain-%E8%BF%9B%E8%A1%8C%E5%88%86%E6%9E%90
2. 优化数据访问	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E4%BC%98%E5%8C%96%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE
1. 减少请求的数据量	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%87%8F%E5%B0%91%E8%AF%B7%E6%B1%82%E7%9A%84%E6%95%B0%E6%8D%AE%E9%87%8F
2. 减少服务器端扫描的行数	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E5%87%8F%E5%B0%91%E6%9C%8D%E5%8A%A1%E5%99%A8%E7%AB%AF%E6%89%AB%E6%8F%8F%E7%9A%84%E8%A1%8C%E6%95%B0
3. 重构查询方式	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E9%87%8D%E6%9E%84%E6%9F%A5%E8%AF%A2%E6%96%B9%E5%BC%8F
1. 切分大查询	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%88%87%E5%88%86%E5%A4%A7%E6%9F%A5%E8%AF%A2
2. 分解大连接查询	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E5%88%86%E8%A7%A3%E5%A4%A7%E8%BF%9E%E6%8E%A5%E6%9F%A5%E8%AF%A2
19. 锁类型	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#19-%E9%94%81%E7%B1%BB%E5%9E%8B
1. 乐观锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B9%90%E8%A7%82%E9%94%81
2. 悲观锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%82%B2%E8%A7%82%E9%94%81
3. 共享锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%85%B1%E4%BA%AB%E9%94%81
4. 排它锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%8E%92%E5%AE%83%E9%94%81
5. 行锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E8%A1%8C%E9%94%81
6. 表锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E8%A1%A8%E9%94%81
7. 死锁	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-%E6%AD%BB%E9%94%81
第二部分：高性能MySQL实践	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E7%AC%AC%E4%BA%8C%E9%83%A8%E5%88%86%E9%AB%98%E6%80%A7%E8%83%BDmysql%E5%AE%9E%E8%B7%B5
1. 如何解决秒杀的性能问题和超卖的讨论	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%A6%82%E4%BD%95%E8%A7%A3%E5%86%B3%E7%A7%92%E6%9D%80%E7%9A%84%E6%80%A7%E8%83%BD%E9%97%AE%E9%A2%98%E5%92%8C%E8%B6%85%E5%8D%96%E7%9A%84%E8%AE%A8%E8%AE%BA
解决方案1	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%881
解决方案2	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%882
解决方案3	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%883
2. 数据库主从不一致，怎么解	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%BB%E4%BB%8E%E4%B8%8D%E4%B8%80%E8%87%B4%E6%80%8E%E4%B9%88%E8%A7%A3
附录：参考资料	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#%E9%99%84%E5%BD%95%E5%8F%82%E8%80%83%E8%B5%84%E6%96%99
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#前言
CyC2018/Interview-Notebook	https://github.com/CyC2018/Interview-Notebook/blob/master/notes/MySQL.md
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#第一部分mysql基础
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#mysql的多存储引擎架构
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/MySQL.png
MySQL的多存储引擎架构	http://zhaox.github.io/2016/06/24/mysql-architecture
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-什么是事务
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/185b9c49-4c13-4241-a848-fbff85c03a64.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#autocommit
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-数据库acid
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-原子性atomicity
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-一致性consistency
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-隔离性isolation
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-持久性durability
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/a58e294a-615d-4ea0-9fbf-064a6daec4b2-1534474592177.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-数据库中的范式
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/c2d343f7-604c-4856-9a3c-c71d6f67fecc.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-第一范式-1nf
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-第二范式-2nf
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-第三范式-3nf
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-并发一致性问题
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-丢失修改
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/88ff46b3-028a-4dbb-a572-1f062b8b96d3.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-脏读
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/dd782132-d830-4c55-9884-cfac0a541b8e.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-不可重复读
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/c8d18ca9-0b09-441a-9a0c-fb063630d708-1534474726485.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-幻读
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/72fe492e-f1cb-4cfc-92f8-412fb3ae6fec.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-事务隔离级别
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-串行化-serializable
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-可重复读-repeated-read
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-读已提交-read-committed
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-读未提交-read-uncommitted
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-存储引擎
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#简介
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-myisam
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-innodb
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-csv
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-archive
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-memory
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-federated
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#问独立表空间和系统表空间应该如何抉择
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#问如何选择存储引擎
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#问myisam和innodb引擎的区别
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#问为什么不建议-innodb-使用亿级大表
为什么不建议innodb使用亿级大表 \| 峰云就她了	http://xiaorui.cc/2016/12/08/%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%8D%E5%BB%BA%E8%AE%AEinnodb%E4%BD%BF%E7%94%A8%E4%BA%BF%E7%BA%A7%E5%A4%A7%E8%A1%A8/
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-mysql数据类型
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-整型
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-浮点数
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-字符串
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-时间和日期
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#datetime
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#timestamp
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#8-索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-索引使用的场景
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-b-tree-原理
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#b-tree
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/06976908-98ab-46e9-a632-f0c2760ec46c.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#btree
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/7299afd2-9114-44e6-9d5e-4025d0b2a541.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#顺序访问指针
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/061c88c1-572f-424f-b580-9cbce903a3fe.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#优势
MySQL 索引背后的数据结构及算法原理	http://blog.codinglabs.org/articles/theory-of-mysql-index.html
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-索引分类
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#btree-索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/c28c6fbc-2bc1-47d9-9b2e-cf3d4034f877.jpg
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/7ab8ca28-2a41-4adf-9502-cc0a21e63b51.jpg
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#哈希索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#全文索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#空间数据索引r-tree
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-索引的特点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-索引的优点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-索引的缺点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-索引失效
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#8-在什么情况下适合建立索引
MySQL索引背后的数据结构及算法原理	https://www.kancloud.cn/kancloud/theory-of-mysql-index/41846
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#9-为什么用b树做索引而不用b-树或红黑树
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#10-联合索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-什么是联合索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-命名规则
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-创建索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-索引类型
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-删除索引
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-什么情况下使用索引
MySQL-联合索引 - 简书	https://www.jianshu.com/p/f65be52d5e2b
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#11-主键外键和索引的区别
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#12-聚集索引与非聚集索引
https://www.cnblogs.com/s-b-b/p/8334593.html	https://www.cnblogs.com/s-b-b/p/8334593.html
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#13-数据库中的分页查询语句怎么写如何优化
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#14-常用的数据库有哪些redis用过吗
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#15-redis的数据结构
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/pics/redis-data-structure-types.jpeg
Redis	https://github.com/giaming/fullstack-tutorial/blob/master/notes/redis.md
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#16-分库分表
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-垂直切分
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/e130e5b8-b19a-4f1e-b860-223040525cf6.jpg
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分的优点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分的缺点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-水平切分
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/63c2909f-0c5f-496f-9fe5-ee9176b31aba.jpg
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#水平切分的优点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#水平切分的缺点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分和水平切分的共同点
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-sharding-策略
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-sharding-存在的问题及解决方案
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#事务问题
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#join
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#id-唯一性
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#17-主从复制与读写分离
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#主从复制
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/master-slave.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#读写分离
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/assets/master-slave-proxy.png
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#18-查询性能优化
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-使用-explain-进行分析
MySQL 性能优化神器 Explain 使用分析	https://segmentfault.com/a/1190000008131735
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-优化数据访问
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-减少请求的数据量
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-减少服务器端扫描的行数
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-重构查询方式
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-切分大查询
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-分解大连接查询
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#19-锁类型
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-乐观锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-悲观锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#3-共享锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#4-排它锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#5-行锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#6-表锁
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#7-死锁
Mysql锁机制简单了解一下 - Java面试通关手册 - SegmentFault 思否	https://segmentfault.com/a/1190000015219003#articleHeader0
锁概念的理解 - 搜云库 - SegmentFault 思否	https://segmentfault.com/a/1190000015815061#articleHeader7
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#第二部分高性能mysql实践
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#1-如何解决秒杀的性能问题和超卖的讨论
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#解决方案1
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#解决方案2
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#解决方案3
库存扣多了，到底怎么整 \| 架构师之路	https://mp.weixin.qq.com/s/waGRvyhab2z8b-BIw9bJeA
如何解决秒杀的性能问题和超卖的讨论 - CSDN博客	https://blog.csdn.net/zhoudaxia/article/details/38067003
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#2-数据库主从不一致怎么解
数据库主从不一致，怎么解？	https://mp.weixin.qq.com/s/5JYtta9aMGcic7o_ejna-A
	https://github.com/giaming/fullstack-tutorial/blob/master/notes/MySQL.md#附录参考资料
视频：MySQL 事务的隔离级别与锁-极客学院	http://www.jikexueyuan.com/course/1524.html
mysql-tutorial/3.5.md at master · jaywcjlove/mysql-tutorial	https://github.com/jaywcjlove/mysql-tutorial/blob/master/chapter3/3.5.md
大神带你剖析Mysql索引底层数据结构_哔哩哔哩 (゜-゜)つロ干杯~-bilibili	https://www.bilibili.com/video/av17252271?from=search&seid=3701018912873961528
大众点评订单系统分库分表实践	https://tech.meituan.com/dianping_order_db_sharding.html
库存扣减还有这么多方案？ \| 架构师之路	https://mp.weixin.qq.com/s/Lfy7ek-vArVBTaUYfl64Bg
关于分库分表，这有一套大而全的轻量级架构设计思路（蚂蚁金服技术专家）	https://www.toutiao.com/a6545626478447428103/?tt_from=weixin&article_category=stock×tamp=1524029012&app=news_article&iid=26214166927&wxshare_count=1
Java大型互联网架构-快速搞定大型互联网网站分库分表方案_哔哩哔哩 (゜-゜)つロ干杯~-bilibili	https://www.bilibili.com/video/av20966672?from=search&seid=6900253656657206494
MySQL分库分表_ITPUB博客	http://blog.itpub.net/29254281/viewspace-1819422/
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.