René's URL Explorer Experiment

Title: JavaGuide-Interview/docs/database/mysql.md at master · SuiJavaStudy/JavaGuide-Interview · GitHub

Open Graph Title: JavaGuide-Interview/docs/database/mysql.md at master · SuiJavaStudy/JavaGuide-Interview

X Title: JavaGuide-Interview/docs/database/mysql.md at master · SuiJavaStudy/JavaGuide-Interview

Description: JavaGuide面试突击版，Java 学习&面试突击（Go、Python 后端面试通用,计算机基础面试总结） - JavaGuide-Interview/docs/database/mysql.md at master · SuiJavaStudy/JavaGuide-Interview

Open Graph Description: JavaGuide面试突击版，Java 学习&面试突击（Go、Python 后端面试通用,计算机基础面试总结） - SuiJavaStudy/JavaGuide-Interview

X Description: JavaGuide面试突击版，Java 学习&面试突击（Go、Python 后端面试通用,计算机基础面试总结） - SuiJavaStudy/JavaGuide-Interview

Opengraph URL: https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/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:adc26118-d994-7444-da77-24705bf4ddf5
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	CAB2:33509B:1C7C2B:280951:6A59D4CB
html-safe-nonce	509dc0c3e62ebae368be75edb850bf87e9d1f56a4c21363e6656b200c1d7c965
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDQUIyOjMzNTA5QjoxQzdDMkI6MjgwOTUxOjZBNTlENENCIiwidmlzaXRvcl9pZCI6Ijc1OTQyNjM4MjQ4NDI3NDA5MzkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac	85e7099a39489f45916977e0154c3be954841c03f408019870f2ceceba9ca5ef
hovercard-subject-tag	repository:1190193765
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/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md
twitter:image	https://opengraph.githubassets.com/3479cf8af25411c04752e3f121709d9918cd6be2cc5cbc0cb2184423ce4f3e17/SuiJavaStudy/JavaGuide-Interview
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/3479cf8af25411c04752e3f121709d9918cd6be2cc5cbc0cb2184423ce4f3e17/SuiJavaStudy/JavaGuide-Interview
og:image:alt	JavaGuide面试突击版，Java 学习&面试突击（Go、Python 后端面试通用,计算机基础面试总结） - SuiJavaStudy/JavaGuide-Interview
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	ba3976babb66479b1c943a8edc0777d96157da48fadc0161f9ddb219deee8353
turbo-cache-control	no-cache
go-import	github.com/SuiJavaStudy/JavaGuide-Interview git https://github.com/SuiJavaStudy/JavaGuide-Interview.git
octolytics-dimension-user_id	270532064
octolytics-dimension-user_login	SuiJavaStudy
octolytics-dimension-repository_id	1190193765
octolytics-dimension-repository_nwo	SuiJavaStudy/JavaGuide-Interview
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	true
octolytics-dimension-repository_parent_id	251061141
octolytics-dimension-repository_parent_nwo	Snailclimb/JavaGuide-Interview
octolytics-dimension-repository_network_root_id	251061141
octolytics-dimension-repository_network_root_nwo	Snailclimb/JavaGuide-Interview
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	bfacf98c3b7ad151665d6ddd216469389872b251
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FSuiJavaStudy%2FJavaGuide-Interview%2Fblob%2Fmaster%2Fdocs%2Fdatabase%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
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%2FSuiJavaStudy%2FJavaGuide-Interview%2Fblob%2Fmaster%2Fdocs%2Fdatabase%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=SuiJavaStudy%2FJavaGuide-Interview
Reload	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md
Reload	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md
Reload	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md
Please reload this page	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md
SuiJavaStudy	https://github.com/SuiJavaStudy
JavaGuide-Interview	https://github.com/SuiJavaStudy/JavaGuide-Interview
Snailclimb/JavaGuide-Interview	https://github.com/Snailclimb/JavaGuide-Interview
Notifications	https://github.com/login?return_to=%2FSuiJavaStudy%2FJavaGuide-Interview
Fork 0	https://github.com/login?return_to=%2FSuiJavaStudy%2FJavaGuide-Interview
Star 0	https://github.com/login?return_to=%2FSuiJavaStudy%2FJavaGuide-Interview
Code	https://github.com/SuiJavaStudy/JavaGuide-Interview
Pull requests 0	https://github.com/SuiJavaStudy/JavaGuide-Interview/pulls
Actions	https://github.com/SuiJavaStudy/JavaGuide-Interview/actions
Projects	https://github.com/SuiJavaStudy/JavaGuide-Interview/projects
Security and quality 0	https://github.com/SuiJavaStudy/JavaGuide-Interview/security
Insights	https://github.com/SuiJavaStudy/JavaGuide-Interview/pulse
Code	https://github.com/SuiJavaStudy/JavaGuide-Interview
Pull requests	https://github.com/SuiJavaStudy/JavaGuide-Interview/pulls
Actions	https://github.com/SuiJavaStudy/JavaGuide-Interview/actions
Projects	https://github.com/SuiJavaStudy/JavaGuide-Interview/projects
Security and quality	https://github.com/SuiJavaStudy/JavaGuide-Interview/security
Insights	https://github.com/SuiJavaStudy/JavaGuide-Interview/pulse
	https://github.com/SuiJavaStudy/JavaGuide-Interview
JavaGuide-Interview	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master
docs	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master/docs
database	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master/docs/database
History	https://github.com/SuiJavaStudy/JavaGuide-Interview/commits/master/docs/database/mysql.md
	https://github.com/SuiJavaStudy/JavaGuide-Interview/commits/master/docs/database/mysql.md
JavaGuide-Interview	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master
docs	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master/docs
database	https://github.com/SuiJavaStudy/JavaGuide-Interview/tree/master/docs/database
Raw	https://github.com/SuiJavaStudy/JavaGuide-Interview/raw/refs/heads/master/docs/database/mysql.md
JavaGuide	https://javaguide.cn/
MySQL 常见面试题总结	https://javaguide.cn/database/mysql/mysql-questions-01.html
MySQL 索引详解	https://javaguide.cn/database/mysql/mysql-index.html
MySQL 三大日志(binlog、redo log 和 undo log)详解	https://javaguide.cn/database/mysql/mysql-logs.html
MySQL 事务隔离级别详解	https://javaguide.cn/database/mysql/transaction-isolation-level.html
InnoDB 存储引擎对 MVCC 的实现	https://javaguide.cn/database/mysql/innodb-implementation-of-mvcc.html
SQL 语句在 MySQL 中的执行过程	https://javaguide.cn/database/mysql/how-sql-executed-in-mysql.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-基础
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是关系型数据库
	https://camo.githubusercontent.com/c615c5ec3f41430c94fca9f744a77dc2dd9d0557352439af1009c3ae0afbe5e3/68747470733a2f2f6f73732e6a61766167756964652e636e2f6a6176612d67756964652d626c6f672f3565336331613731373234613338323435616134336230325f39396266373064343663633234376265383738646539643361383866306334342e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是-sql
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是-mysql
	https://camo.githubusercontent.com/f90ccf65868d645544f15ded6366f30384473c3e98fd47d08778a6dfbd236a3a/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6373646e2f32303231303332373134333335313832332e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-有什么优点
MySQL 事务隔离级别详解	https://javaguide.cn/database/mysql/transaction-isolation-level.html
MySQL 被干成老二了？	https://mp.weixin.qq.com/s/APWD-PzTcTqGUuibAw7GGw
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-字段类型
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️整数类型的-unsigned-属性有什么用
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#char-和-varchar-的区别是什么
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#varchar100和-varchar10的区别是什么
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#为什么不推荐使用-text-和-blob
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️datetime-和-timestamp-的区别是什么如何选择
MySQL 时间类型数据存储建议	https://javaguide.cn/database/mysql/some-thoughts-on-database-storage-time.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#null-和--的区别是什么
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️boolean-类型如何表示
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️手机号存储用-int-还是-varchar
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-存储引擎
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-支持哪些存储引擎默认使用哪个
	https://camo.githubusercontent.com/f3ad3e3c6a855bde0f767074e3987d778f2add97b2ac35623f9acb4fa7951d65/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f696d6167652d32303232303531303130353430383730332e706e67
https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html	https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html	https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
	https://camo.githubusercontent.com/2a9d60ab4cea2be1d203c441a90b759abc1450c9e07dd5ab76eb25a23c19c078/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f696d6167652d32303232303531303135353134333435382e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-存储引擎架构了解吗
	https://camo.githubusercontent.com/b460202a6981ba40b5455bcad41da878e106889e269503fb5ca9f03b64101ecc/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f6d7973716c2d6172636869746563747572652e706e67
https://dev.mysql.com/doc/internals/en/custom-engine.html	https://dev.mysql.com/doc/internals/en/custom-engine.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️myisam-和-innodb-有什么区别
MySQL 事务隔离级别详解	https://javaguide.cn/database/mysql/transaction-isolation-level.html
	https://camo.githubusercontent.com/715653086c6a60c2f7f289bef86fb98b76e1f08c7ad9eea15c1de0c0db792a99/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f696d6167652d32303232303531303039303330393432372e706e67
MySQL 索引详解	https://javaguide.cn/database/mysql/mysql-index.html
	https://camo.githubusercontent.com/0fdaa514a38fd757e04bec459e5746be3ed53b0dd8dc84dcea07a965e962b593/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f696e6e6f64622d6d796973616d2d706572666f726d616e63652d636f6d70617269736f6e2e706e67
	https://camo.githubusercontent.com/02825b6df677edca377c56fb65d91253d017b2a34428c9a5887c3790ad14048c/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f636f6d70617269736f6e2d6f662d636f6d6d6f6e2d6d7973716c2d73746f726167652d656e67696e65732e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#myisam-和-innodb-如何选择
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-索引
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#索引是什么
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#索引为什么快
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-索引底层数据结构是什么
MySQL 索引详解	https://javaguide.cn/database/mysql/mysql-index.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#为什么-innodb-没有使用哈希作为索引的数据结构
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#为什么-innodb-没有使用-b-树作为索引的数据结构
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是覆盖索引
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#请解释一下-mysql-的联合索引及其最左前缀原则
联合索引的最左匹配原则全网都在说的一个错误结论	https://mp.weixin.qq.com/s/8qemhRg5MgXs1So5YCv0fQ
	https://camo.githubusercontent.com/4a1853dd7a456fd2763cc29ed15c6c2e68f2f02c28b7629a05967d2eb8bbae83/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f64617461626173652f6d7973716c2f6c6566746d6f73742d7072656669782d6d61746368696e672d72756c652e706e67
Bug #109145 Using index for skip scan cause incorrect result	https://bugs.mysql.com/bug.php?id=109145
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#select--会导致索引失效吗
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#哪些字段适合创建索引
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#索引失效的原因有哪些
隐式转换	https://javaguide.cn/database/mysql/index-invalidation-caused-by-implicit-conversion.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-日志
《Java 面试指北》(付费，点击链接领取优惠卷)	https://javaguide.cn/zhuanlan/java-mian-shi-zhi-bei.html
	https://camo.githubusercontent.com/9eb2b493c8ef628ab17a1fd17474255efa143881ece458e30557d3066f3613c4/68747470733a2f2f6f73732e6a61766167756964652e636e2f6a6176616d69616e7368697a68696265692f746563686e6963616c2d696e746572766965772d7175657374696f6e732e706e67
https://www.yuque.com/snailclimb/mf2z3k/zr4kfk	https://www.yuque.com/snailclimb/mf2z3k/zr4kfk
https://t.zsxq.com/avfM0	https://t.zsxq.com/avfM0
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-事务
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是事务
	https://camo.githubusercontent.com/24d0498f6afecce6a5c69cab1887abd09c317ea9055abb38f249efc7d0c661aa/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f2545342542412538422545352538412541312545372541342542412545362538342538462545352539422542452e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#什么是数据库事务
	https://camo.githubusercontent.com/0b8e206b4d7cf5e793145df5ce9cd4aca422839e936da4bec765468113db0e80/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f2545362539352542302545362538442541452545352542412539332545342542412538422545352538412541312545372541342542412545362538342538462545352539422542452e706e67
	https://camo.githubusercontent.com/578c3a10ff49fbc504bf8acc2090118417e8da5b547745d8192db60305079eb5/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f414349442e706e67
《周志明的软件架构课》	https://time.geekbang.org/opencourse/intro/100064201
	https://camo.githubusercontent.com/3564a19eb358316fb617d76461f4e4b983749588e206e147ec9875deaae07028/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f4149442d253345432e706e67
《Designing Data-Intensive Application（数据密集型应用系统设计）》	https://book.douban.com/subject/30329536/
https://github.com/Vonng/ddia	https://github.com/Vonng/ddia
	https://camo.githubusercontent.com/1b2e8676ae32b71fb73e7a9e146e11af88ef20854c5884d8a8dfd019f89f1e4c/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f626f6f6b732f646469612e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#并发事务带来了哪些问题
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#脏读dirty-read
	https://camo.githubusercontent.com/a9c202b73c61085b95497be219b56afc5618dc34404e494d4cc1bade1e236a3d/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f64617461626173652f6d7973716c2f636f6e63757272656e63792d636f6e73697374656e63792d6973737565732d64697274792d72656164696e672e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#丢失修改lost-to-modify
	https://camo.githubusercontent.com/dfc9da6d8ae23a9816cd3353ebc14bbeb2fffb4e943f1900a54a254fcfd98eec/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f64617461626173652f6d7973716c2f636f6e63757272656e63792d636f6e73697374656e63792d6973737565732d6d697373696e672d6d6f64696669636174696f6e732e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#不可重复读unrepeatable-read
	https://camo.githubusercontent.com/c39d30d655ee85eec5563bc8a779b49652d8e19059e55cc0b1a64f636e5faecb/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f64617461626173652f6d7973716c2f636f6e63757272656e63792d636f6e73697374656e63792d6973737565732d756e72657065617461626c652d726561642e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#幻读phantom-read
	https://camo.githubusercontent.com/e76e5d818b4f29db2b368e03ce0a8f1bb9e08e5db717e0ddd50e6f9189deeaf5/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f64617461626173652f6d7973716c2f636f6e63757272656e63792d636f6e73697374656e63792d6973737565732d7068616e746f6d2d726561642e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#不可重复读和幻读有什么区别
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#并发事务的控制方式有哪些
InnoDB 存储引擎对 MVCC 的实现	https://javaguide.cn/database/mysql/innodb-implementation-of-mvcc.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#sql-标准定义了哪些事务隔离级别
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-的默认隔离级别是什么
MySQL 事务隔离级别详解	https://javaguide.cn/database/mysql/transaction-isolation-level.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-的隔离级别是基于锁实现的吗
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-锁
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#表级锁和行级锁了解吗有什么区别
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#行级锁的使用有什么注意事项
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#innodb-有哪几类行锁
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#共享锁和排他锁呢
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#意向锁有什么作用
	https://camo.githubusercontent.com/97981d2cfc45d50dd2021acb114352549bc4ceb5e9b6967a9588fb48aad5424e/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f696d6167652d32303232303531313137313431393038312e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#当前读和快照读有什么区别
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#️mysql-性能优化
MySQL 高性能优化规范建议总结	https://javaguide.cn/database/mysql/mysql-high-performance-optimization-specification-recommendations.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#能用-mysql-直接存储文件比如图片吗
	https://camo.githubusercontent.com/9df0e4494371947b093709cb7f203e8140d4345d2cf1cd7a12516842255fa3a3/68747470733a2f2f6f73732e6a61766167756964652e636e2f6769746875622f6a61766167756964652f6d7973716c2f6f73732d7365617263682e706e67
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-如何存储-ip-地址
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#有哪些常见的-sql-优化手段
《Java 面试指北》(付费)	https://javaguide.cn/zhuanlan/java-mian-shi-zhi-bei.html
	https://camo.githubusercontent.com/144b5f53bc1f3dd1eb5c47a3087387334b3f9ce47f8b620b1c442777df94de3d/68747470733a2f2f6f73732e6a61766167756964652e636e2f6a6176616d69616e7368697a68696265692f6a6176616d69616e7368697a68696265692d73716c2d6f7074696d697a6174696f6e2e706e67
https://www.yuque.com/snailclimb/mf2z3k/abc2sv	https://www.yuque.com/snailclimb/mf2z3k/abc2sv
https://t.zsxq.com/avfM0	https://t.zsxq.com/avfM0
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#如何分析-sql-的性能
SQL 的执行计划	https://javaguide.cn/database/mysql/mysql-query-execution-plan.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#读写分离和分库分表了解吗
读写分离和分库分表详解	https://javaguide.cn/high-performance/read-and-write-separation-and-library-subtable.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#深度分页如何优化
深度分页介绍及优化建议	https://javaguide.cn/high-performance/deep-pagination-optimization.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#数据冷热分离如何做
数据冷热分离详解	https://javaguide.cn/high-performance/data-cold-hot-separation.html
	https://github.com/SuiJavaStudy/JavaGuide-Interview/blob/master/docs/database/mysql.md#mysql-性能怎么优化
	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.