René's URL Explorer Experiment


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

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

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

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

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

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

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

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/blob/*name(/*path)
route-controllerblob
route-actionshow
fetch-noncev2:9a594311-d722-c2c4-f730-d3a812cce077
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id8E64:26C182:5FB789E:7EA689B:6A5DC590
html-safe-nonce3ba010aa83bad83e1c9933419a63ee743c0ec3636c755b346cfc7da324cf6c81
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4RTY0OjI2QzE4Mjo1RkI3ODlFOjdFQTY4OUI6NkE1REM1OTAiLCJ2aXNpdG9yX2lkIjoiMzA1NjgzNTY1NjM2NDcwNTE2OCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac34e376c83bd3aa412d6d00f8c4a67297d97924e2c21db17f1fe4291971925366
hovercard-subject-tagrepository:183015234
github-keyboard-shortcutsrepository,source-code,file-tree,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///blob/show
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md
twitter:imagehttps://opengraph.githubassets.com/8d8b75ce8f1caccfa2189048c4c5302f1f1232290436cd885d180c47db7e5f66/Tiberiusjhh/fullstack-tutorial
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/8d8b75ce8f1caccfa2189048c4c5302f1f1232290436cd885d180c47db7e5f66/Tiberiusjhh/fullstack-tutorial
og:image:alt🚀 fullstack tutorial 2019，后台技术栈/架构师之路/全栈开发社区，春招/秋招/校招/面试 - Tiberiusjhh/fullstack-tutorial
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None5290d7e14309ad1e76106a9c4237bd1041517e83ea182c8ab756752cb0c6940b
turbo-cache-controlno-cache
go-importgithub.com/Tiberiusjhh/fullstack-tutorial git https://github.com/Tiberiusjhh/fullstack-tutorial.git
octolytics-dimension-user_id30586303
octolytics-dimension-user_loginTiberiusjhh
octolytics-dimension-repository_id183015234
octolytics-dimension-repository_nwoTiberiusjhh/fullstack-tutorial
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id129332826
octolytics-dimension-repository_parent_nwofrank-lam/fullstack-tutorial
octolytics-dimension-repository_network_root_id129332826
octolytics-dimension-repository_network_root_nwofrank-lam/fullstack-tutorial
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release9c975978430e9ad293956f2bbdaf153b1bd84a99
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/Tiberiusjhh/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%2FTiberiusjhh%2Ffullstack-tutorial%2Fblob%2Fmaster%2Fnotes%2FMySQL.md
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/open-source/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/open-source/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://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%2FTiberiusjhh%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=Tiberiusjhh%2Ffullstack-tutorial
Reloadhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md
Reloadhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md
Reloadhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md
Tiberiusjhh https://github.com/Tiberiusjhh
fullstack-tutorialhttps://github.com/Tiberiusjhh/fullstack-tutorial
frank-lam/fullstack-tutorialhttps://github.com/frank-lam/fullstack-tutorial
Notifications https://github.com/login?return_to=%2FTiberiusjhh%2Ffullstack-tutorial
Fork 0 https://github.com/login?return_to=%2FTiberiusjhh%2Ffullstack-tutorial
Star 1 https://github.com/login?return_to=%2FTiberiusjhh%2Ffullstack-tutorial
Code https://github.com/Tiberiusjhh/fullstack-tutorial
Pull requests 0 https://github.com/Tiberiusjhh/fullstack-tutorial/pulls
Actions https://github.com/Tiberiusjhh/fullstack-tutorial/actions
Projects https://github.com/Tiberiusjhh/fullstack-tutorial/projects
Security and quality 0 https://github.com/Tiberiusjhh/fullstack-tutorial/security
Insights https://github.com/Tiberiusjhh/fullstack-tutorial/pulse
Code https://github.com/Tiberiusjhh/fullstack-tutorial
Pull requests https://github.com/Tiberiusjhh/fullstack-tutorial/pulls
Actions https://github.com/Tiberiusjhh/fullstack-tutorial/actions
Projects https://github.com/Tiberiusjhh/fullstack-tutorial/projects
Security and quality https://github.com/Tiberiusjhh/fullstack-tutorial/security
Insights https://github.com/Tiberiusjhh/fullstack-tutorial/pulse
https://github.com/Tiberiusjhh/fullstack-tutorial
fullstack-tutorialhttps://github.com/Tiberiusjhh/fullstack-tutorial/tree/master
noteshttps://github.com/Tiberiusjhh/fullstack-tutorial/tree/master/notes
Historyhttps://github.com/Tiberiusjhh/fullstack-tutorial/commits/master/notes/MySQL.md
https://github.com/Tiberiusjhh/fullstack-tutorial/commits/master/notes/MySQL.md
fullstack-tutorialhttps://github.com/Tiberiusjhh/fullstack-tutorial/tree/master
noteshttps://github.com/Tiberiusjhh/fullstack-tutorial/tree/master/notes
Rawhttps://github.com/Tiberiusjhh/fullstack-tutorial/raw/refs/heads/master/notes/MySQL.md
前言https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%89%8D%E8%A8%80
第一部分：MySQL基础https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1
AUTOCOMMIThttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#autocommit
2. 数据库ACIDhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%95%B0%E6%8D%AE%E5%BA%93acid
1. 原子性（Atomicity）https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%8E%9F%E5%AD%90%E6%80%A7atomicity
2. 一致性（Consistency）https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E4%B8%80%E8%87%B4%E6%80%A7consistency
3. 隔离性（Isolation）https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E9%9A%94%E7%A6%BB%E6%80%A7isolation
4. 持久性（Durability）https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%8C%81%E4%B9%85%E6%80%A7durability
3. 数据库中的范式https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B8%A2%E5%A4%B1%E4%BF%AE%E6%94%B9
2. 脏读https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E8%84%8F%E8%AF%BB
3. 不可重复读https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E5%B9%BB%E8%AF%BB
5. 事务隔离级别https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B8%B2%E8%A1%8C%E5%8C%96-serializable
2. 可重复读 (Repeated Read)https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E
简介https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E7%AE%80%E4%BB%8B
1. MyISAMhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-myisam
2. InnoDBhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-innodb
3. CSVhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-csv
4. Archivehttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-archive
5. Memoryhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-memory
6. Federatedhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-federated
问：独立表空间和系统表空间应该如何抉择https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E6%95%B4%E5%9E%8B
2. 浮点数https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%B5%AE%E7%82%B9%E6%95%B0
3. 字符串https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%AD%97%E7%AC%A6%E4%B8%B2
4. 时间和日期https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%97%B6%E9%97%B4%E5%92%8C%E6%97%A5%E6%9C%9F
DATATIMEhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#datatime
TIMESTAMPhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#timestamp
8. 索引https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#8-%E7%B4%A2%E5%BC%95
1. 索引使用的场景https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-b-tree-%E5%8E%9F%E7%90%86
B-Treehttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#b-tree
B+Treehttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#btree
顺序访问指针https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%BC%98%E5%8A%BF
3. 索引分类https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#btree-%E7%B4%A2%E5%BC%95
哈希索引https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%93%88%E5%B8%8C%E7%B4%A2%E5%BC%95
全文索引https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E5%85%A8%E6%96%87%E7%B4%A2%E5%BC%95
空间数据索引（R-Tree）https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#7-%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88
8. 在什么情况下适合建立索引https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#10-%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95
1. 什么是联合索引https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E5%91%BD%E5%90%8D%E8%A7%84%E5%88%99
3. 创建索引https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95
4. 索引类型https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E7%B4%A2%E5%BC%95%E7%B1%BB%E5%9E%8B
5. 删除索引https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E5%88%A0%E9%99%A4%E7%B4%A2%E5%BC%95
6. 什么情况下使用索引https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#16-%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8
1. 垂直切分https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86
垂直切分的优点https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86
水平切分的优点https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-sharding-%E7%AD%96%E7%95%A5
4. Sharding 存在的问题及解决方案https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%BA%8B%E5%8A%A1%E9%97%AE%E9%A2%98
JOINhttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#join
ID 唯一性https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#id-%E5%94%AF%E4%B8%80%E6%80%A7
17. 主从复制与读写分离https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6
读写分离https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB
18. 查询性能优化https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#19-%E9%94%81%E7%B1%BB%E5%9E%8B
1. 乐观锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-%E4%B9%90%E8%A7%82%E9%94%81
2. 悲观锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-%E6%82%B2%E8%A7%82%E9%94%81
3. 共享锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-%E5%85%B1%E4%BA%AB%E9%94%81
4. 排它锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-%E6%8E%92%E5%AE%83%E9%94%81
5. 行锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-%E8%A1%8C%E9%94%81
6. 表锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-%E8%A1%A8%E9%94%81
7. 死锁https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#7-%E6%AD%BB%E9%94%81
第二部分：高性能MySQL实践https://github.com/Tiberiusjhh/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/Tiberiusjhh/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
解决方案1https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%881
解决方案2https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%882
解决方案3https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%883
2. 数据库主从不一致，怎么解https://github.com/Tiberiusjhh/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/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#前言
CyC2018/Interview-Notebookhttps://github.com/CyC2018/Interview-Notebook/blob/master/notes/MySQL.md
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#第一部分mysql基础
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#mysql的多存储引擎架构
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/MySQL.png
MySQL的多存储引擎架构http://zhaox.github.io/2016/06/24/mysql-architecture
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-什么是事务
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/185b9c49-4c13-4241-a848-fbff85c03a64.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#autocommit
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-数据库acid
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-原子性atomicity
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-一致性consistency
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-隔离性isolation
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-持久性durability
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/a58e294a-615d-4ea0-9fbf-064a6daec4b2-1534474592177.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-数据库中的范式
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/c2d343f7-604c-4856-9a3c-c71d6f67fecc.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-第一范式-1nf
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-第二范式-2nf
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-第三范式-3nf
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-并发一致性问题
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-丢失修改
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/88ff46b3-028a-4dbb-a572-1f062b8b96d3.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-脏读
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/dd782132-d830-4c55-9884-cfac0a541b8e.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-不可重复读
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/c8d18ca9-0b09-441a-9a0c-fb063630d708-1534474726485.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-幻读
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/72fe492e-f1cb-4cfc-92f8-412fb3ae6fec.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-事务隔离级别
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-串行化-serializable
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-可重复读-repeated-read
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-读已提交-read-committed
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-读未提交-read-uncommitted
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-存储引擎
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#简介
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-myisam
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-innodb
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-csv
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-archive
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-memory
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-federated
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#问独立表空间和系统表空间应该如何抉择
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#问如何选择存储引擎
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#问myisam和innodb引擎的区别
https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#7-mysql数据类型
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-整型
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-浮点数
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-字符串
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-时间和日期
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#datatime
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#timestamp
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#8-索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-索引使用的场景
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-b-tree-原理
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#b-tree
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/06976908-98ab-46e9-a632-f0c2760ec46c.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#btree
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/7299afd2-9114-44e6-9d5e-4025d0b2a541.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#顺序访问指针
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/061c88c1-572f-424f-b580-9cbce903a3fe.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#优势
MySQL 索引背后的数据结构及算法原理http://blog.codinglabs.org/articles/theory-of-mysql-index.html
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-索引分类
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#btree-索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/c28c6fbc-2bc1-47d9-9b2e-cf3d4034f877.jpg
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/7ab8ca28-2a41-4adf-9502-cc0a21e63b51.jpg
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#哈希索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#全文索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#空间数据索引r-tree
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-索引的特点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-索引的优点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-索引的缺点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#7-索引失效
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#8-在什么情况下适合建立索引
MySQL索引背后的数据结构及算法原理https://www.kancloud.cn/kancloud/theory-of-mysql-index/41846
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#9-为什么用b树做索引而不用b-树或红黑树
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#10-联合索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-什么是联合索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-命名规则
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-创建索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-索引类型
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-删除索引
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-什么情况下使用索引
MySQL-联合索引 - 简书https://www.jianshu.com/p/f65be52d5e2b
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#11-主键外键和索引的区别
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#12-聚集索引与非聚集索引
https://www.cnblogs.com/s-b-b/p/8334593.htmlhttps://www.cnblogs.com/s-b-b/p/8334593.html
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#13-数据库中的分页查询语句怎么写如何优化
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#14-常用的数据库有哪些redis用过吗
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#15-redis的数据结构
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/pics/redis-data-structure-types.jpeg
Redishttps://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/redis.md
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#16-分库分表
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-垂直切分
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/e130e5b8-b19a-4f1e-b860-223040525cf6.jpg
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分的优点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分的缺点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-水平切分
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/63c2909f-0c5f-496f-9fe5-ee9176b31aba.jpg
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#水平切分的优点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#水平切分的缺点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#垂直切分和水平切分的共同点
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-sharding-策略
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-sharding-存在的问题及解决方案
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#事务问题
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#join
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#id-唯一性
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#17-主从复制与读写分离
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#主从复制
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/master-slave.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#读写分离
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/assets/master-slave-proxy.png
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#18-查询性能优化
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-使用-explain-进行分析
MySQL 性能优化神器 Explain 使用分析https://segmentfault.com/a/1190000008131735
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-优化数据访问
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-减少请求的数据量
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-减少服务器端扫描的行数
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-重构查询方式
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-切分大查询
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-分解大连接查询
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#19-锁类型
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-乐观锁
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-悲观锁
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#3-共享锁
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#4-排它锁
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#5-行锁
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#6-表锁
https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#第二部分高性能mysql实践
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#1-如何解决秒杀的性能问题和超卖的讨论
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#解决方案1
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#解决方案2
https://github.com/Tiberiusjhh/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/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#2-数据库主从不一致怎么解
数据库主从不一致，怎么解？https://mp.weixin.qq.com/s/5JYtta9aMGcic7o_ejna-A
https://github.com/Tiberiusjhh/fullstack-tutorial/blob/master/notes/MySQL.md#附录参考资料
视频：MySQL 事务的隔离级别与锁-极客学院http://www.jikexueyuan.com/course/1524.html
mysql-tutorial/3.5.md at master · jaywcjlove/mysql-tutorialhttps://github.com/jaywcjlove/mysql-tutorial/blob/master/chapter3/3.5.md
大神带你剖析Mysql索引底层数据结构_哔哩哔哩 (゜-゜)つロ 干杯~-bilibilihttps://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大型互联网架构-快速搞定大型互联网网站分库分表方案_哔哩哔哩 (゜-゜)つロ 干杯~-bilibilihttps://www.bilibili.com/video/av20966672?from=search&seid=6900253656657206494
MySQL分库分表_ITPUB博客http://blog.itpub.net/29254281/viewspace-1819422/
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.