| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /:user_id/:repository/blob/*name(/*path) |
| route-controller | blob |
| route-action | show |
| fetch-nonce | v2:b20b9fd9-edf5-1d1b-0f90-85d69a66c757 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | DDA8:13BB3C:637A:86D0:6AFC339C |
| html-safe-nonce | 3b77724a500c6eb66d264a1c3a1567d41dcd697969dc01c500c98b9899de8db1 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEREE4OjEzQkIzQzo2MzdBOjg2RDA6NkFGQzMzOUMiLCJ2aXNpdG9yX2lkIjoiOTE1MjA5MDA3Mjc1NTc0NTY5MiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | cccc46d774a2826b972679936ddba0a92d30744caf0bea5380f3e3274f82893d |
| hovercard-subject-tag | repository:193357074 |
| 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/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md |
| twitter:image | https://opengraph.githubassets.com/a7469a550cf9d44328511e26ac8ca65bd0bef3b1cab4704bcfeddff6117d9791/linux2Java/fullstack-tutorial |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/a7469a550cf9d44328511e26ac8ca65bd0bef3b1cab4704bcfeddff6117d9791/linux2Java/fullstack-tutorial |
| og:image:alt | 🚀 fullstack tutorial 2019,后台技术栈/架构师之路/全栈开发社区,春招/秋招/校招/面试 - linux2Java/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 | 827c173ddffda68083b3bbc60a422453d9b103f564de9815e7e007718070b32a |
| turbo-cache-control | no-cache |
| go-import | github.com/linux2Java/fullstack-tutorial git https://github.com/linux2Java/fullstack-tutorial.git |
| octolytics-dimension-user_id | 12537916 |
| octolytics-dimension-user_login | linux2Java |
| octolytics-dimension-repository_id | 193357074 |
| octolytics-dimension-repository_nwo | linux2Java/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 | bbd7037d92866948160421691ed44052c13ec4e5 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#start-of-content |
| https://redirect.github.com/ |
| Sign in | https://redirect.github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flinux2Java%2Ffullstack-tutorial%2Fblob%2Ffront-end%2Fnotes%2FMySQL.md |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| 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 |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | 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 |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://redirect.github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flinux2Java%2Ffullstack-tutorial%2Fblob%2Ffront-end%2Fnotes%2FMySQL.md |
| Sign up | https://redirect.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=linux2Java%2Ffullstack-tutorial |
| Reload | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md |
| Reload | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md |
| Reload | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md |
| linux2Java | https://redirect.github.com/linux2Java |
| fullstack-tutorial | https://redirect.github.com/linux2Java/fullstack-tutorial |
| Code | https://redirect.github.com/linux2Java/fullstack-tutorial |
| Pull requests | https://redirect.github.com/linux2Java/fullstack-tutorial/pulls |
| Actions | https://redirect.github.com/linux2Java/fullstack-tutorial/actions |
| Projects | https://redirect.github.com/linux2Java/fullstack-tutorial/projects |
| Security and quality | https://redirect.github.com/linux2Java/fullstack-tutorial/security |
| Insights | https://redirect.github.com/linux2Java/fullstack-tutorial/pulse |
| https://redirect.github.com/linux2Java/fullstack-tutorial |
| fullstack-tutorial | https://redirect.github.com/linux2Java/fullstack-tutorial/tree/front-end |
| notes | https://redirect.github.com/linux2Java/fullstack-tutorial/tree/front-end/notes |
| History | https://redirect.github.com/linux2Java/fullstack-tutorial/commits/front-end/notes/MySQL.md |
| https://redirect.github.com/linux2Java/fullstack-tutorial/commits/front-end/notes/MySQL.md |
| fullstack-tutorial | https://redirect.github.com/linux2Java/fullstack-tutorial/tree/front-end |
| notes | https://redirect.github.com/linux2Java/fullstack-tutorial/tree/front-end/notes |
| Raw | https://github.com/linux2Java/fullstack-tutorial/raw/refs/heads/front-end/notes/MySQL.md |
| 前言 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E5%89%8D%E8%A8%80 |
| 第一部分:MySQL基础 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E7%AC%AC%E4%B8%80%E9%83%A8%E5%88%86mysql%E5%9F%BA%E7%A1%80 |
| MySQL的多存储引擎架构 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1 |
| AUTOCOMMIT | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#autocommit |
| 2. 数据库ACID | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E6%95%B0%E6%8D%AE%E5%BA%93acid |
| 1. 原子性(Atomicity) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E5%8E%9F%E5%AD%90%E6%80%A7atomicity |
| 2. 一致性(Consistency) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E4%B8%80%E8%87%B4%E6%80%A7consistency |
| 3. 隔离性(Isolation) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E9%9A%94%E7%A6%BB%E6%80%A7isolation |
| 4. 持久性(Durability) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E6%8C%81%E4%B9%85%E6%80%A7durability |
| 3. 数据库中的范式 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E7%AC%AC%E4%B8%80%E8%8C%83%E5%BC%8F-1nf |
| 2. 第二范式 (2NF) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E7%AC%AC%E4%BA%8C%E8%8C%83%E5%BC%8F-2nf |
| 3. 第三范式 (3NF) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E7%AC%AC%E4%B8%89%E8%8C%83%E5%BC%8F-3nf |
| 4. 并发一致性问题 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E4%B8%A2%E5%A4%B1%E4%BF%AE%E6%94%B9 |
| 2. 脏读 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E8%84%8F%E8%AF%BB |
| 3. 不可重复读 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E4%B8%8D%E5%8F%AF%E9%87%8D%E5%A4%8D%E8%AF%BB |
| 4. 幻读 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E5%B9%BB%E8%AF%BB |
| 5. 事务隔离级别 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E4%B8%B2%E8%A1%8C%E5%8C%96-serializable |
| 2. 可重复读 (Repeated Read) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E5%8F%AF%E9%87%8D%E5%A4%8D%E8%AF%BB-repeated-read |
| 3. 读已提交 (Read Committed) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E8%AF%BB%E5%B7%B2%E6%8F%90%E4%BA%A4-read-committed |
| 4. 读未提交 (Read Uncommitted) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E8%AF%BB%E6%9C%AA%E6%8F%90%E4%BA%A4-read-uncommitted |
| 6. 存储引擎 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E |
| 简介 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E7%AE%80%E4%BB%8B |
| 1. MyISAM | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-myisam |
| 2. InnoDB | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-innodb |
| 3. CSV | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-csv |
| 4. Archive | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-archive |
| 5. Memory | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-memory |
| 6. Federated | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-federated |
| 问:独立表空间和系统表空间应该如何抉择 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-mysql%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B |
| 1. 整型 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E6%95%B4%E5%9E%8B |
| 2. 浮点数 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E6%B5%AE%E7%82%B9%E6%95%B0 |
| 3. 字符串 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E5%AD%97%E7%AC%A6%E4%B8%B2 |
| 4. 时间和日期 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E6%97%B6%E9%97%B4%E5%92%8C%E6%97%A5%E6%9C%9F |
| DATATIME | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#datatime |
| TIMESTAMP | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#timestamp |
| 8. 索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#8-%E7%B4%A2%E5%BC%95 |
| 1. 索引使用的场景 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-b-tree-%E5%8E%9F%E7%90%86 |
| B-Tree | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#b-tree |
| B+Tree | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#btree |
| 顺序访问指针 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E9%A1%BA%E5%BA%8F%E8%AE%BF%E9%97%AE%E6%8C%87%E9%92%88 |
| 优势 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E4%BC%98%E5%8A%BF |
| 3. 索引分类 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E7%B4%A2%E5%BC%95%E5%88%86%E7%B1%BB |
| B+Tree 索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#btree-%E7%B4%A2%E5%BC%95 |
| 哈希索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E5%93%88%E5%B8%8C%E7%B4%A2%E5%BC%95 |
| 全文索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E5%85%A8%E6%96%87%E7%B4%A2%E5%BC%95 |
| 空间数据索引(R-Tree) | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E7%A9%BA%E9%97%B4%E6%95%B0%E6%8D%AE%E7%B4%A2%E5%BC%95r-tree |
| 4. 索引的特点 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E7%B4%A2%E5%BC%95%E7%9A%84%E7%89%B9%E7%82%B9 |
| 5. 索引的优点 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BC%98%E7%82%B9 |
| 6. 索引的缺点 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-%E7%B4%A2%E5%BC%95%E7%9A%84%E7%BC%BA%E7%82%B9 |
| 7. 索引失效 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88 |
| 8. 在什么情况下适合建立索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#10-%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95 |
| 1. 什么是联合索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E5%91%BD%E5%90%8D%E8%A7%84%E5%88%99 |
| 3. 创建索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95 |
| 4. 索引类型 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E7%B4%A2%E5%BC%95%E7%B1%BB%E5%9E%8B |
| 5. 删除索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-%E5%88%A0%E9%99%A4%E7%B4%A2%E5%BC%95 |
| 6. 什么情况下使用索引 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#15-redis%E7%9A%84%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84 |
| 16. 分库分表 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#16-%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8 |
| 1. 垂直切分 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E5%9E%82%E7%9B%B4%E5%88%87%E5%88%86 |
| 垂直切分的优点 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E6%B0%B4%E5%B9%B3%E5%88%87%E5%88%86 |
| 水平切分的优点 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-sharding-%E7%AD%96%E7%95%A5 |
| 4. Sharding 存在的问题及解决方案 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E4%BA%8B%E5%8A%A1%E9%97%AE%E9%A2%98 |
| JOIN | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#join |
| ID 唯一性 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#id-%E5%94%AF%E4%B8%80%E6%80%A7 |
| 17. 主从复制与读写分离 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6 |
| 读写分离 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB |
| 18. 查询性能优化 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E4%BC%98%E5%8C%96%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE |
| 1. 减少请求的数据量 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E9%87%8D%E6%9E%84%E6%9F%A5%E8%AF%A2%E6%96%B9%E5%BC%8F |
| 1. 切分大查询 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E5%88%87%E5%88%86%E5%A4%A7%E6%9F%A5%E8%AF%A2 |
| 2. 分解大连接查询 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#19-%E9%94%81%E7%B1%BB%E5%9E%8B |
| 1. 乐观锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-%E4%B9%90%E8%A7%82%E9%94%81 |
| 2. 悲观锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-%E6%82%B2%E8%A7%82%E9%94%81 |
| 3. 共享锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-%E5%85%B1%E4%BA%AB%E9%94%81 |
| 4. 排它锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-%E6%8E%92%E5%AE%83%E9%94%81 |
| 5. 行锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-%E8%A1%8C%E9%94%81 |
| 6. 表锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-%E8%A1%A8%E9%94%81 |
| 7. 死锁 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-%E6%AD%BB%E9%94%81 |
| 第二部分:高性能MySQL实践 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%881 |
| 解决方案2 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%882 |
| 解决方案3 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%883 |
| 2. 数据库主从不一致,怎么解 | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#%E9%99%84%E5%BD%95%E5%8F%82%E8%80%83%E8%B5%84%E6%96%99 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#前言 |
| CyC2018/Interview-Notebook | https://github.com/CyC2018/Interview-Notebook/blob/master/notes/MySQL.md |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#第一部分mysql基础 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#mysql的多存储引擎架构 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/MySQL.png |
| MySQL的多存储引擎架构 | http://zhaox.github.io/2016/06/24/mysql-architecture |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-什么是事务 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/185b9c49-4c13-4241-a848-fbff85c03a64.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#autocommit |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-数据库acid |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-原子性atomicity |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-一致性consistency |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-隔离性isolation |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-持久性durability |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/a58e294a-615d-4ea0-9fbf-064a6daec4b2-1534474592177.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-数据库中的范式 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/c2d343f7-604c-4856-9a3c-c71d6f67fecc.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-第一范式-1nf |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-第二范式-2nf |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-第三范式-3nf |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-并发一致性问题 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-丢失修改 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/88ff46b3-028a-4dbb-a572-1f062b8b96d3.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-脏读 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/dd782132-d830-4c55-9884-cfac0a541b8e.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-不可重复读 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/c8d18ca9-0b09-441a-9a0c-fb063630d708-1534474726485.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-幻读 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/72fe492e-f1cb-4cfc-92f8-412fb3ae6fec.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-事务隔离级别 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-串行化-serializable |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-可重复读-repeated-read |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-读已提交-read-committed |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-读未提交-read-uncommitted |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-存储引擎 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#简介 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-myisam |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-innodb |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-csv |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-archive |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-memory |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-federated |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#问独立表空间和系统表空间应该如何抉择 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#问如何选择存储引擎 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#问myisam和innodb引擎的区别 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-mysql数据类型 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-整型 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-浮点数 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-字符串 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-时间和日期 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#datatime |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#timestamp |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#8-索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-索引使用的场景 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-b-tree-原理 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#b-tree |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/06976908-98ab-46e9-a632-f0c2760ec46c.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#btree |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/7299afd2-9114-44e6-9d5e-4025d0b2a541.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#顺序访问指针 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/061c88c1-572f-424f-b580-9cbce903a3fe.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#优势 |
| MySQL 索引背后的数据结构及算法原理 | http://blog.codinglabs.org/articles/theory-of-mysql-index.html |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-索引分类 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#btree-索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/c28c6fbc-2bc1-47d9-9b2e-cf3d4034f877.jpg |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/7ab8ca28-2a41-4adf-9502-cc0a21e63b51.jpg |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#哈希索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#全文索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#空间数据索引r-tree |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-索引的特点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-索引的优点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-索引的缺点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-索引失效 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#8-在什么情况下适合建立索引 |
| MySQL索引背后的数据结构及算法原理 | https://www.kancloud.cn/kancloud/theory-of-mysql-index/41846 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#9-为什么用b树做索引而不用b-树或红黑树 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#10-联合索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-什么是联合索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-命名规则 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-创建索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-索引类型 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-删除索引 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-什么情况下使用索引 |
| MySQL-联合索引 - 简书 | https://www.jianshu.com/p/f65be52d5e2b |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#11-主键外键和索引的区别 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#13-数据库中的分页查询语句怎么写如何优化 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#14-常用的数据库有哪些redis用过吗 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#15-redis的数据结构 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/pics/redis-data-structure-types.jpeg |
| Redis | https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/redis.md |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#16-分库分表 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-垂直切分 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/e130e5b8-b19a-4f1e-b860-223040525cf6.jpg |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#垂直切分的优点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#垂直切分的缺点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-水平切分 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/63c2909f-0c5f-496f-9fe5-ee9176b31aba.jpg |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#水平切分的优点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#水平切分的缺点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#垂直切分和水平切分的共同点 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-sharding-策略 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-sharding-存在的问题及解决方案 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#事务问题 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#join |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#id-唯一性 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#17-主从复制与读写分离 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#主从复制 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/master-slave.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#读写分离 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/assets/master-slave-proxy.png |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#18-查询性能优化 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-使用-explain-进行分析 |
| MySQL 性能优化神器 Explain 使用分析 | https://segmentfault.com/a/1190000008131735 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-优化数据访问 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-减少请求的数据量 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-减少服务器端扫描的行数 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-重构查询方式 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-切分大查询 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-分解大连接查询 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#19-锁类型 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-乐观锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-悲观锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#3-共享锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#4-排它锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#5-行锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#6-表锁 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#7-死锁 |
| Mysql锁机制简单了解一下 - Java面试通关手册 - SegmentFault 思否 | https://segmentfault.com/a/1190000015219003#articleHeader0 |
| 锁概念的理解 - 搜云库 - SegmentFault 思否 | https://segmentfault.com/a/1190000015815061#articleHeader7 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#第二部分高性能mysql实践 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#1-如何解决秒杀的性能问题和超卖的讨论 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#解决方案1 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#解决方案2 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#解决方案3 |
| 库存扣多了,到底怎么整 | 架构师之路 | https://mp.weixin.qq.com/s/waGRvyhab2z8b-BIw9bJeA |
| 如何解决秒杀的性能问题和超卖的讨论 - CSDN博客 | https://blog.csdn.net/zhoudaxia/article/details/38067003 |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/notes/MySQL.md#2-数据库主从不一致怎么解 |
| 数据库主从不一致,怎么解? | https://mp.weixin.qq.com/s/5JYtta9aMGcic7o_ejna-A |
| https://redirect.github.com/linux2Java/fullstack-tutorial/blob/front-end/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 |