René's URL Explorer Experiment


Title: JavaInterview-1/interviewDoc/Java/database/MySQL.md at master · github-esme/JavaInterview-1 · GitHub

Open Graph Title: JavaInterview-1/interviewDoc/Java/database/MySQL.md at master · github-esme/JavaInterview-1

X Title: JavaInterview-1/interviewDoc/Java/database/MySQL.md at master · github-esme/JavaInterview-1

Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - JavaInterview-1/interviewDoc/Java/database/MySQL.md at master · github-esme/JavaInterview-1

Open Graph Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - github-esme/JavaInterview-1

X Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - github-esme/JavaInterview-1

Opengraph URL: https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/blob/*name(/*path)
route-controllerblob
route-actionshow
fetch-noncev2:9bf42363-50a0-569a-d716-e717bf50c635
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id9F94:294F1D:8940C:C16FC:6A59BC45
html-safe-nonce4084cfa9280a7034251a45fb3ae28b95fcf5afa80c70ec6cfb6ab4be898c7a57
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5Rjk0OjI5NEYxRDo4OTQwQzpDMTZGQzo2QTU5QkM0NSIsInZpc2l0b3JfaWQiOiI3Njg2NDgwNDAxOTM1MjE5NzgxIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac8b4d7690f860129fd43c740309980f4d96849c786963043a492880a558e42069
hovercard-subject-tagrepository:439043208
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/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md
twitter:imagehttps://opengraph.githubassets.com/99ce89b1687f6890a0ceeebc2b1e113c2974126afc254e1b987c5c71b84310c2/github-esme/JavaInterview-1
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/99ce89b1687f6890a0ceeebc2b1e113c2974126afc254e1b987c5c71b84310c2/github-esme/JavaInterview-1
og:image:altJava面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - github-esme/JavaInterview-1
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneba3976babb66479b1c943a8edc0777d96157da48fadc0161f9ddb219deee8353
turbo-cache-controlno-cache
go-importgithub.com/github-esme/JavaInterview-1 git https://github.com/github-esme/JavaInterview-1.git
octolytics-dimension-user_id50765448
octolytics-dimension-user_logingithub-esme
octolytics-dimension-repository_id439043208
octolytics-dimension-repository_nwogithub-esme/JavaInterview-1
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id245599072
octolytics-dimension-repository_parent_nwogsjqwyl/JavaInterview
octolytics-dimension-repository_network_root_id245599072
octolytics-dimension-repository_network_root_nwogsjqwyl/JavaInterview
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
releaseab680789ae4a316cdaf0d5a292a1760140931cc4
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgithub-esme%2FJavaInterview-1%2Fblob%2Fmaster%2FinterviewDoc%2FJava%2Fdatabase%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%2Fgithub-esme%2FJavaInterview-1%2Fblob%2Fmaster%2FinterviewDoc%2FJava%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=github-esme%2FJavaInterview-1
Reloadhttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md
Reloadhttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md
Reloadhttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md
github-esme https://github.com/github-esme
JavaInterview-1https://github.com/github-esme/JavaInterview-1
gsjqwyl/JavaInterviewhttps://github.com/gsjqwyl/JavaInterview
Notifications https://github.com/login?return_to=%2Fgithub-esme%2FJavaInterview-1
Fork 0 https://github.com/login?return_to=%2Fgithub-esme%2FJavaInterview-1
Star 0 https://github.com/login?return_to=%2Fgithub-esme%2FJavaInterview-1
Code https://github.com/github-esme/JavaInterview-1
Pull requests 0 https://github.com/github-esme/JavaInterview-1/pulls
Actions https://github.com/github-esme/JavaInterview-1/actions
Projects https://github.com/github-esme/JavaInterview-1/projects
Security and quality 0 https://github.com/github-esme/JavaInterview-1/security
Insights https://github.com/github-esme/JavaInterview-1/pulse
Code https://github.com/github-esme/JavaInterview-1
Pull requests https://github.com/github-esme/JavaInterview-1/pulls
Actions https://github.com/github-esme/JavaInterview-1/actions
Projects https://github.com/github-esme/JavaInterview-1/projects
Security and quality https://github.com/github-esme/JavaInterview-1/security
Insights https://github.com/github-esme/JavaInterview-1/pulse
https://github.com/github-esme/JavaInterview-1
JavaInterview-1https://github.com/github-esme/JavaInterview-1/tree/master
interviewDochttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc
Javahttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc/Java
databasehttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc/Java/database
Historyhttps://github.com/github-esme/JavaInterview-1/commits/master/interviewDoc/Java/database/MySQL.md
https://github.com/github-esme/JavaInterview-1/commits/master/interviewDoc/Java/database/MySQL.md
JavaInterview-1https://github.com/github-esme/JavaInterview-1/tree/master
interviewDochttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc
Javahttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc/Java
databasehttps://github.com/github-esme/JavaInterview-1/tree/master/interviewDoc/Java/database
Rawhttps://github.com/github-esme/JavaInterview-1/raw/refs/heads/master/interviewDoc/Java/database/MySQL.md
Java面试整理高清PDF下载https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
Java面试整理高清PDF下载https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
Java面试整理高清PDF下载https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
MySQL中的varchar和char有什么区别.https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%AD%E7%9A%84varchar%E5%92%8Cchar%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
varchar(10)和int(10)代表什么含义?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#varchar10%E5%92%8Cint10%E4%BB%A3%E8%A1%A8%E4%BB%80%E4%B9%88%E5%90%AB%E4%B9%89
MySQL中varchar与char的区别以及varchar(50)中的50代表的涵义https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%ADvarchar%E4%B8%8Echar%E7%9A%84%E5%8C%BA%E5%88%AB%E4%BB%A5%E5%8F%8Avarchar50%E4%B8%AD%E7%9A%8450%E4%BB%A3%E8%A1%A8%E7%9A%84%E6%B6%B5%E4%B9%89
请说明varchar和text的区别https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B7%E8%AF%B4%E6%98%8Evarchar%E5%92%8Ctext%E7%9A%84%E5%8C%BA%E5%88%AB
FLOAT和DOUBLE的区别是什么？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#float%E5%92%8Cdouble%E7%9A%84%E5%8C%BA%E5%88%AB%E6%98%AF%E4%BB%80%E4%B9%88
如何在MySQL种获取当前日期？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E4%BD%95%E5%9C%A8mysql%E7%A7%8D%E8%8E%B7%E5%8F%96%E5%BD%93%E5%89%8D%E6%97%A5%E6%9C%9F
MySQL中varchar与char的区别以及varchar(50)中的50代表的涵义https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%ADvarchar%E4%B8%8Echar%E7%9A%84%E5%8C%BA%E5%88%AB%E4%BB%A5%E5%8F%8Avarchar50%E4%B8%AD%E7%9A%8450%E4%BB%A3%E8%A1%A8%E7%9A%84%E6%B6%B5%E4%B9%89
innodb的事务与日志的实现方式https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E7%9A%84%E4%BA%8B%E5%8A%A1%E4%B8%8E%E6%97%A5%E5%BF%97%E7%9A%84%E5%AE%9E%E7%8E%B0%E6%96%B9%E5%BC%8F
MySQL的binlog有有几种录入格式?分别有什么区别?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%9A%84binlog%E6%9C%89%E6%9C%89%E5%87%A0%E7%A7%8D%E5%BD%95%E5%85%A5%E6%A0%BC%E5%BC%8F%E5%88%86%E5%88%AB%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
MySQL数据库cpu飙升怎么处理？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E6%95%B0%E6%8D%AE%E5%BA%93cpu%E9%A3%99%E5%8D%87%E6%80%8E%E4%B9%88%E5%A4%84%E7%90%86
超大分页怎么处理?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%B6%85%E5%A4%A7%E5%88%86%E9%A1%B5%E6%80%8E%E4%B9%88%E5%A4%84%E7%90%86
关心过业务系统里面的sql耗时吗?统计过慢查询吗?对慢查询都怎么优化过?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%B3%E5%BF%83%E8%BF%87%E4%B8%9A%E5%8A%A1%E7%B3%BB%E7%BB%9F%E9%87%8C%E9%9D%A2%E7%9A%84sql%E8%80%97%E6%97%B6%E5%90%97%E7%BB%9F%E8%AE%A1%E8%BF%87%E6%85%A2%E6%9F%A5%E8%AF%A2%E5%90%97%E5%AF%B9%E6%85%A2%E6%9F%A5%E8%AF%A2%E9%83%BD%E6%80%8E%E4%B9%88%E4%BC%98%E5%8C%96%E8%BF%87
横向分表和纵向分表,可以分别举一个适合他们的例子吗?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E6%A8%AA%E5%90%91%E5%88%86%E8%A1%A8%E5%92%8C%E7%BA%B5%E5%90%91%E5%88%86%E8%A1%A8%E5%8F%AF%E4%BB%A5%E5%88%86%E5%88%AB%E4%B8%BE%E4%B8%80%E4%B8%AA%E9%80%82%E5%90%88%E4%BB%96%E4%BB%AC%E7%9A%84%E4%BE%8B%E5%AD%90%E5%90%97
什么是存储过程？有哪些优缺点？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E6%9C%89%E5%93%AA%E4%BA%9B%E4%BC%98%E7%BC%BA%E7%82%B9
说一说三个范式https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B4%E4%B8%80%E8%AF%B4%E4%B8%89%E4%B8%AA%E8%8C%83%E5%BC%8F
MySQL的复制原理以及流程https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%9A%84%E5%A4%8D%E5%88%B6%E5%8E%9F%E7%90%86%E4%BB%A5%E5%8F%8A%E6%B5%81%E7%A8%8B
六种关联查询https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%AD%E7%A7%8D%E5%85%B3%E8%81%94%E6%9F%A5%E8%AF%A2
内连接分为三类https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%86%85%E8%BF%9E%E6%8E%A5%E5%88%86%E4%B8%BA%E4%B8%89%E7%B1%BB
外连接（LEFT JOIN/RIGHT JOIN）https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A4%96%E8%BF%9E%E6%8E%A5left-joinright-join
联合查询（UNION与UNION ALL）https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%81%94%E5%90%88%E6%9F%A5%E8%AF%A2union%E4%B8%8Eunion-all
全连接（FULL JOIN）https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%A8%E8%BF%9E%E6%8E%A5full-join
UNION与UNION ALL的区别？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#union%E4%B8%8Eunion-all%E7%9A%84%E5%8C%BA%E5%88%AB
SQL语句优化的一些方法？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#sql%E8%AF%AD%E5%8F%A5%E4%BC%98%E5%8C%96%E7%9A%84%E4%B8%80%E4%BA%9B%E6%96%B9%E6%B3%95
MySQL由哪些部分组成, 分别用来做什么https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%94%B1%E5%93%AA%E4%BA%9B%E9%83%A8%E5%88%86%E7%BB%84%E6%88%90-%E5%88%86%E5%88%AB%E7%94%A8%E6%9D%A5%E5%81%9A%E4%BB%80%E4%B9%88
如果一个表有一列定义为TIMESTAMP，将发生什么？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E6%9E%9C%E4%B8%80%E4%B8%AA%E8%A1%A8%E6%9C%89%E4%B8%80%E5%88%97%E5%AE%9A%E4%B9%89%E4%B8%BAtimestamp%E5%B0%86%E5%8F%91%E7%94%9F%E4%BB%80%E4%B9%88
MySQL 里记录货币用什么字段类型好https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E9%87%8C%E8%AE%B0%E5%BD%95%E8%B4%A7%E5%B8%81%E7%94%A8%E4%BB%80%E4%B9%88%E5%AD%97%E6%AE%B5%E7%B1%BB%E5%9E%8B%E5%A5%BD
你们数据库是否支持emoji表情，如果不支持，如何操作？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BD%A0%E4%BB%AC%E6%95%B0%E6%8D%AE%E5%BA%93%E6%98%AF%E5%90%A6%E6%94%AF%E6%8C%81emoji%E8%A1%A8%E6%83%85%E5%A6%82%E6%9E%9C%E4%B8%8D%E6%94%AF%E6%8C%81%E5%A6%82%E4%BD%95%E6%93%8D%E4%BD%9C
MySQL 数据库作发布系统的存储，一天五万条以上的增量， 预计运维三年,怎么优化？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BD%9C%E5%8F%91%E5%B8%83%E7%B3%BB%E7%BB%9F%E7%9A%84%E5%AD%98%E5%82%A8%E4%B8%80%E5%A4%A9%E4%BA%94%E4%B8%87%E6%9D%A1%E4%BB%A5%E4%B8%8A%E7%9A%84%E5%A2%9E%E9%87%8F-%E9%A2%84%E8%AE%A1%E8%BF%90%E7%BB%B4%E4%B8%89%E5%B9%B4%E6%80%8E%E4%B9%88%E4%BC%98%E5%8C%96
一个6亿的表a，一个3亿的表b，通过外间tid关联，你如何最快的查询出满足条件的第50000到第50200中的这200条数据记录。https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%80%E4%B8%AA6%E4%BA%BF%E7%9A%84%E8%A1%A8a%E4%B8%80%E4%B8%AA3%E4%BA%BF%E7%9A%84%E8%A1%A8b%E9%80%9A%E8%BF%87%E5%A4%96%E9%97%B4tid%E5%85%B3%E8%81%94%E4%BD%A0%E5%A6%82%E4%BD%95%E6%9C%80%E5%BF%AB%E7%9A%84%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%BB%A1%E8%B6%B3%E6%9D%A1%E4%BB%B6%E7%9A%84%E7%AC%AC50000%E5%88%B0%E7%AC%AC50200%E4%B8%AD%E7%9A%84%E8%BF%99200%E6%9D%A1%E6%95%B0%E6%8D%AE%E8%AE%B0%E5%BD%95
优化数据库的方法https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BC%98%E5%8C%96%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%96%B9%E6%B3%95
简单描述 MySQL 中，索引，主键，唯一索引，联合索引的区别，对数据库的性能有什么影响（从读写两方面）https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%AE%80%E5%8D%95%E6%8F%8F%E8%BF%B0-mysql-%E4%B8%AD%E7%B4%A2%E5%BC%95%E4%B8%BB%E9%94%AE%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB%E5%AF%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%80%A7%E8%83%BD%E6%9C%89%E4%BB%80%E4%B9%88%E5%BD%B1%E5%93%8D%E4%BB%8E%E8%AF%BB%E5%86%99%E4%B8%A4%E6%96%B9%E9%9D%A2
SQL 注入漏洞产生的原因？如何防止？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#sql-%E6%B3%A8%E5%85%A5%E6%BC%8F%E6%B4%9E%E4%BA%A7%E7%94%9F%E7%9A%84%E5%8E%9F%E5%9B%A0%E5%A6%82%E4%BD%95%E9%98%B2%E6%AD%A2
存储时期https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%98%E5%82%A8%E6%97%B6%E6%9C%9F
解释 MySQL 外连接、内连接与自连接的区别https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%A7%A3%E9%87%8A-mysql-%E5%A4%96%E8%BF%9E%E6%8E%A5%E5%86%85%E8%BF%9E%E6%8E%A5%E4%B8%8E%E8%87%AA%E8%BF%9E%E6%8E%A5%E7%9A%84%E5%8C%BA%E5%88%AB
存储引擎常用命令https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4
MySQL支持哪些存储引擎?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E6%94%AF%E6%8C%81%E5%93%AA%E4%BA%9B%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E
请说明InnoDB和MyISAM的区别https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B7%E8%AF%B4%E6%98%8Einnodb%E5%92%8Cmyisam%E7%9A%84%E5%8C%BA%E5%88%AB
innodb引擎的特性https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E5%BC%95%E6%93%8E%E7%9A%84%E7%89%B9%E6%80%A7
什么是触发器，MySQL中都有哪些触发器？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E8%A7%A6%E5%8F%91%E5%99%A8mysql%E4%B8%AD%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E8%A7%A6%E5%8F%91%E5%99%A8
InnoDB和MyISAM有什么区别?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E5%92%8Cmyisam%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
myisamchk 是用来做什么的？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisamchk-%E6%98%AF%E7%94%A8%E6%9D%A5%E5%81%9A%E4%BB%80%E4%B9%88%E7%9A%84
为什么要尽量设定一个主键?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E5%B0%BD%E9%87%8F%E8%AE%BE%E5%AE%9A%E4%B8%80%E4%B8%AA%E4%B8%BB%E9%94%AE
主键使用自增ID还是UUID?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BB%E9%94%AE%E4%BD%BF%E7%94%A8%E8%87%AA%E5%A2%9Eid%E8%BF%98%E6%98%AFuuid
字段为什么要求定义为not null?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%97%E6%AE%B5%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E6%B1%82%E5%AE%9A%E4%B9%89%E4%B8%BAnot-null
如果要存储用户的密码散列,应该使用什么字段进行存储?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E6%9E%9C%E8%A6%81%E5%AD%98%E5%82%A8%E7%94%A8%E6%88%B7%E7%9A%84%E5%AF%86%E7%A0%81%E6%95%A3%E5%88%97%E5%BA%94%E8%AF%A5%E4%BD%BF%E7%94%A8%E4%BB%80%E4%B9%88%E5%AD%97%E6%AE%B5%E8%BF%9B%E8%A1%8C%E5%AD%98%E5%82%A8
索引是个什么样的数据结构呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E6%98%AF%E4%B8%AA%E4%BB%80%E4%B9%88%E6%A0%B7%E7%9A%84%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84%E5%91%A2
唯一索引比普通索引快吗, 为什么https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95%E6%AF%94%E6%99%AE%E9%80%9A%E7%B4%A2%E5%BC%95%E5%BF%AB%E5%90%97-%E4%B8%BA%E4%BB%80%E4%B9%88
索引的优缺点https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BC%98%E7%BC%BA%E7%82%B9
做过哪些MySQL索引相关优化https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%81%9A%E8%BF%87%E5%93%AA%E4%BA%9Bmysql%E7%B4%A2%E5%BC%95%E7%9B%B8%E5%85%B3%E4%BC%98%E5%8C%96
怎么看到为表格定义的所有索引？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E6%80%8E%E4%B9%88%E7%9C%8B%E5%88%B0%E4%B8%BA%E8%A1%A8%E6%A0%BC%E5%AE%9A%E4%B9%89%E7%9A%84%E6%89%80%E6%9C%89%E7%B4%A2%E5%BC%95
索引的基础https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%9F%BA%E7%A1%80
创建索引的语法https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95%E7%9A%84%E8%AF%AD%E6%B3%95
索引对性能的影响：https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E5%AF%B9%E6%80%A7%E8%83%BD%E7%9A%84%E5%BD%B1%E5%93%8D
索引的类型https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E7%B1%BB%E5%9E%8B
索引的区别https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB
MySQL索引的创建原则https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%9B%E5%BB%BA%E5%8E%9F%E5%88%99
索引的使用场景https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BD%BF%E7%94%A8%E5%9C%BA%E6%99%AF
索引分类https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E5%88%86%E7%B1%BB
MySQL索引的注意事项https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9
MySQL索引的原理https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8E%9F%E7%90%86
解题方法https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%A7%A3%E9%A2%98%E6%96%B9%E6%B3%95
创建MySQL联合索引应该注意什么？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BAmysql%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E5%BA%94%E8%AF%A5%E6%B3%A8%E6%84%8F%E4%BB%80%E4%B9%88
列值为NULL时，查询是否会用到索引？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%97%E5%80%BC%E4%B8%BAnull%E6%97%B6%E6%9F%A5%E8%AF%A2%E6%98%AF%E5%90%A6%E4%BC%9A%E7%94%A8%E5%88%B0%E7%B4%A2%E5%BC%95
以下语句是否会应用索引：SELECT FROM users WHERE YEAR(adddate) < 2007;https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%A5%E4%B8%8B%E8%AF%AD%E5%8F%A5%E6%98%AF%E5%90%A6%E4%BC%9A%E5%BA%94%E7%94%A8%E7%B4%A2%E5%BC%95select-from-users-where-yearadddate--2007
MyISAM索引实现？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisam%E7%B4%A2%E5%BC%95%E5%AE%9E%E7%8E%B0
MyISAM索引与InnoDB索引的区别？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisam%E7%B4%A2%E5%BC%95%E4%B8%8Einnodb%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB
使用索引查询一定能提高查询的性能吗？为什么https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2%E4%B8%80%E5%AE%9A%E8%83%BD%E6%8F%90%E9%AB%98%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%80%A7%E8%83%BD%E5%90%97%E4%B8%BA%E4%BB%80%E4%B9%88
什么情况下设置了索引但无法使用https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%83%85%E5%86%B5%E4%B8%8B%E8%AE%BE%E7%BD%AE%E4%BA%86%E7%B4%A2%E5%BC%95%E4%BD%86%E6%97%A0%E6%B3%95%E4%BD%BF%E7%94%A8
超键、候选键、主键、外键分别是什么？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%B6%85%E9%94%AE%E5%80%99%E9%80%89%E9%94%AE%E4%B8%BB%E9%94%AE%E5%A4%96%E9%94%AE%E5%88%86%E5%88%AB%E6%98%AF%E4%BB%80%E4%B9%88
简单说一说drop、delete与truncate的区别https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%AE%80%E5%8D%95%E8%AF%B4%E4%B8%80%E8%AF%B4dropdelete%E4%B8%8Etruncate%E7%9A%84%E5%8C%BA%E5%88%AB
drop、delete与truncate分别在什么场景之下使用？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#dropdelete%E4%B8%8Etruncate%E5%88%86%E5%88%AB%E5%9C%A8%E4%BB%80%E4%B9%88%E5%9C%BA%E6%99%AF%E4%B9%8B%E4%B8%8B%E4%BD%BF%E7%94%A8
B-Tree 和 B+Treehttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-%E5%92%8C-btree
为什么 B+Tree 比 B-Tree 更适合实际应用中操作系统的文件索引和数据库索引？**https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88-btree-%E6%AF%94-b-tree-%E6%9B%B4%E9%80%82%E5%90%88%E5%AE%9E%E9%99%85%E5%BA%94%E7%94%A8%E4%B8%AD%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E7%9A%84%E6%96%87%E4%BB%B6%E7%B4%A2%E5%BC%95%E5%92%8C%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B4%A2%E5%BC%95
什么是视图？以及视图的使用场景有哪些？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E8%A7%86%E5%9B%BE%E4%BB%A5%E5%8F%8A%E8%A7%86%E5%9B%BE%E7%9A%84%E4%BD%BF%E7%94%A8%E5%9C%BA%E6%99%AF%E6%9C%89%E5%93%AA%E4%BA%9B
Hash索引和B+树所有有什么区别或者说优劣呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#hash%E7%B4%A2%E5%BC%95%E5%92%8Cb%E6%A0%91%E6%89%80%E6%9C%89%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB%E6%88%96%E8%80%85%E8%AF%B4%E4%BC%98%E5%8A%A3%E5%91%A2
为什么用 B+ 树做索引而不用哈希表做索引?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E7%94%A8-b-%E6%A0%91%E5%81%9A%E7%B4%A2%E5%BC%95%E8%80%8C%E4%B8%8D%E7%94%A8%E5%93%88%E5%B8%8C%E8%A1%A8%E5%81%9A%E7%B4%A2%E5%BC%95
索引是什么？有什么作用以及优缺点？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E6%98%AF%E4%BB%80%E4%B9%88%E6%9C%89%E4%BB%80%E4%B9%88%E4%BD%9C%E7%94%A8%E4%BB%A5%E5%8F%8A%E4%BC%98%E7%BC%BA%E7%82%B9
上面提到了B+树在满足聚簇索引和覆盖索引的时候不需要回表查询数据,什么是聚簇索引?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%8A%E9%9D%A2%E6%8F%90%E5%88%B0%E4%BA%86b%E6%A0%91%E5%9C%A8%E6%BB%A1%E8%B6%B3%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E5%92%8C%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95%E7%9A%84%E6%97%B6%E5%80%99%E4%B8%8D%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E4%BB%80%E4%B9%88%E6%98%AF%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95
非聚簇索引一定会回表查询吗?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E9%9D%9E%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%80%E5%AE%9A%E4%BC%9A%E5%9B%9E%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%90%97
在建立索引的时候,都有哪些需要考虑的因素呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%9C%A8%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E7%9A%84%E6%97%B6%E5%80%99%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E9%9C%80%E8%A6%81%E8%80%83%E8%99%91%E7%9A%84%E5%9B%A0%E7%B4%A0%E5%91%A2
联合索引是什么?为什么需要注意联合索引中的顺序?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E6%98%AF%E4%BB%80%E4%B9%88%E4%B8%BA%E4%BB%80%E4%B9%88%E9%9C%80%E8%A6%81%E6%B3%A8%E6%84%8F%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E4%B8%AD%E7%9A%84%E9%A1%BA%E5%BA%8F
创建的索引有没有被使用到?或者说怎么才可以知道这条语句运行很慢的原因?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BA%E7%9A%84%E7%B4%A2%E5%BC%95%E6%9C%89%E6%B2%A1%E6%9C%89%E8%A2%AB%E4%BD%BF%E7%94%A8%E5%88%B0%E6%88%96%E8%80%85%E8%AF%B4%E6%80%8E%E4%B9%88%E6%89%8D%E5%8F%AF%E4%BB%A5%E7%9F%A5%E9%81%93%E8%BF%99%E6%9D%A1%E8%AF%AD%E5%8F%A5%E8%BF%90%E8%A1%8C%E5%BE%88%E6%85%A2%E7%9A%84%E5%8E%9F%E5%9B%A0
那么在哪些情况下会发生针对该列创建了索引但是在查询的时候并没有使用呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E9%82%A3%E4%B9%88%E5%9C%A8%E5%93%AA%E4%BA%9B%E6%83%85%E5%86%B5%E4%B8%8B%E4%BC%9A%E5%8F%91%E7%94%9F%E9%92%88%E5%AF%B9%E8%AF%A5%E5%88%97%E5%88%9B%E5%BB%BA%E4%BA%86%E7%B4%A2%E5%BC%95%E4%BD%86%E6%98%AF%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%97%B6%E5%80%99%E5%B9%B6%E6%B2%A1%E6%9C%89%E4%BD%BF%E7%94%A8%E5%91%A2
什么是事务?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1
数据库的乐观锁和悲观锁是什么？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E4%B9%90%E8%A7%82%E9%94%81%E5%92%8C%E6%82%B2%E8%A7%82%E9%94%81%E6%98%AF%E4%BB%80%E4%B9%88
ACID是什么?可以详细说一下吗?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#acid%E6%98%AF%E4%BB%80%E4%B9%88%E5%8F%AF%E4%BB%A5%E8%AF%A6%E7%BB%86%E8%AF%B4%E4%B8%80%E4%B8%8B%E5%90%97
同时有多个事务在进行会怎么样呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%90%8C%E6%97%B6%E6%9C%89%E5%A4%9A%E4%B8%AA%E4%BA%8B%E5%8A%A1%E5%9C%A8%E8%BF%9B%E8%A1%8C%E4%BC%9A%E6%80%8E%E4%B9%88%E6%A0%B7%E5%91%A2
Myql 中的事务回滚机制概述https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myql-%E4%B8%AD%E7%9A%84%E4%BA%8B%E5%8A%A1%E5%9B%9E%E6%BB%9A%E6%9C%BA%E5%88%B6%E6%A6%82%E8%BF%B0
并发事务带来哪些问题?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%B9%B6%E5%8F%91%E4%BA%8B%E5%8A%A1%E5%B8%A6%E6%9D%A5%E5%93%AA%E4%BA%9B%E9%97%AE%E9%A2%98
怎么解决这些问题呢?MySQL的事务隔离级别了解吗?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E6%80%8E%E4%B9%88%E8%A7%A3%E5%86%B3%E8%BF%99%E4%BA%9B%E9%97%AE%E9%A2%98%E5%91%A2mysql%E7%9A%84%E4%BA%8B%E5%8A%A1%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E4%BA%86%E8%A7%A3%E5%90%97
Innodb使用的是哪种隔离级别呢?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E4%BD%BF%E7%94%A8%E7%9A%84%E6%98%AF%E5%93%AA%E7%A7%8D%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E5%91%A2
MySQL 中有哪几种锁？https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E4%B8%AD%E6%9C%89%E5%93%AA%E5%87%A0%E7%A7%8D%E9%94%81
对MySQL的锁了解吗?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AF%B9mysql%E7%9A%84%E9%94%81%E4%BA%86%E8%A7%A3%E5%90%97
锁机制与InnoDB锁算法https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E9%94%81%E6%9C%BA%E5%88%B6%E4%B8%8Einnodb%E9%94%81%E7%AE%97%E6%B3%95
MySQL都有哪些锁呢?像上面那样子进行锁定岂不是有点阻碍并发效率了?https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E9%94%81%E5%91%A2%E5%83%8F%E4%B8%8A%E9%9D%A2%E9%82%A3%E6%A0%B7%E5%AD%90%E8%BF%9B%E8%A1%8C%E9%94%81%E5%AE%9A%E5%B2%82%E4%B8%8D%E6%98%AF%E6%9C%89%E7%82%B9%E9%98%BB%E7%A2%8D%E5%B9%B6%E5%8F%91%E6%95%88%E7%8E%87%E4%BA%86
锁的优化策略https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E9%94%81%E7%9A%84%E4%BC%98%E5%8C%96%E7%AD%96%E7%95%A5
Explain 性能分析https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#explain-%E6%80%A7%E8%83%BD%E5%88%86%E6%9E%90
如何优化SQLhttps://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96sql
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql中的varchar和char有什么区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#varchar10和int10代表什么含义
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#请说明varchar和text的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#float和double的区别是什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#如何在mysql种获取当前日期
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义-1
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb的事务与日志的实现方式
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql的binlog有有几种录入格式分别有什么区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql数据库cpu飙升到500的话他怎么处理
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#超大分页怎么处理
https://camo.githubusercontent.com/2c2cbcb83264d43b967c5144c045c7d7bec04e39bb1de84702f8d1bd4b16aa45/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313433393534382d3830363439383133352e706e67
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#关心过业务系统里面的sql耗时吗统计过慢查询吗对慢查询都怎么优化过
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#横向分表和纵向分表可以分别举一个适合他们的例子吗
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#什么是存储过程有哪些优缺点
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#说一说三个范式
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql的复制原理以及流程
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#六种关联查询
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#内连接分为三类
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#外连接left-joinright-join
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#联合查询union与union-all
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#全连接full-join
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#union与union-all的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#sql语句优化的一些方法
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql由哪些部分组成-分别用来做什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#如果一个表有一列定义为timestamp将发生什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-里记录货币用什么字段类型好
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#你们数据库是否支持emoji表情如果不支持如何操作
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-数据库作发布系统的存储一天五万条以上的增量-预计运维三年怎么优化
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#一个6亿的表a一个3亿的表b通过外间tid关联你如何最快的查询出满足条件的第50000到第50200中的这200条数据记录
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#优化数据库的方法
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#简单描述-mysql-中索引主键唯一索引联合索引的区别对数据库的性能有什么影响从读写两方面
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#sql-注入漏洞产生的原因如何防止
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#存储时期
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#解释-mysql-外连接内连接与自连接的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#存储引擎常用命令
https://camo.githubusercontent.com/ad15bb1f159ea58f25688dccb44123744faaf4f7e27675ab0dc6fde682f04761/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323730312e706e67
https://camo.githubusercontent.com/ae575fcfe8edd9cf91d0f744a5a846eadf40806c65ec964fd50b3a9c04d2407a/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323735332e706e67
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql支持哪些存储引擎
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#请说明innodb和myisam的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb引擎的特性
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#什么是触发器mysql中都有哪些触发器
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb和myisam有什么区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisamchk-是用来做什么的
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#为什么要尽量设定一个主键
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#主键使用自增id还是uuid
https://camo.githubusercontent.com/926403ec639ebdb642a2145ced6e85d61c243151b2e032add65113fa5c4b7006/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313431363731342d3738303935303033302e706e67
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#字段为什么要求定义为not-null
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#如果要存储用户的密码散列应该使用什么字段进行存储
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引是个什么样的数据结构呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#唯一索引比普通索引快吗-为什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引的优缺点
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#做过哪些mysql索引相关优化
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#怎么看到为表格定义的所有索引
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引的基础
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#创建索引的语法
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引对性能的影响
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引的类型
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的创建原则
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引的使用场景
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引分类
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的注意事项
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的原理
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#解题方法
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#创建mysql联合索引应该注意什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#列值为null时查询是否会用到索引
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#以下语句是否会应用索引select-from-users-where-yearadddate--2007
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引实现
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引与innodb索引的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#使用索引查询一定能提高查询的性能吗为什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#什么情况下设置了索引但无法使用
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#超键候选键主键外键分别是什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#简单说一说dropdelete与truncate的区别
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#dropdelete与truncate分别在什么场景之下使用
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-和-btree
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#为什么-btree-比-b-tree-更适合实际应用中操作系统的文件索引和数据库索引
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#什么是视图以及视图的使用场景有哪些
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#hash索引和b树所有有什么区别或者说优劣呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#为什么用-b-树做索引而不用哈希表做索引
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#索引是什么有什么作用以及优缺点
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#上面提到了b树在满足聚簇索引和覆盖索引的时候不需要回表查询数据什么是聚簇索引
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#非聚簇索引一定会回表查询吗
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#在建立索引的时候都有哪些需要考虑的因素呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#联合索引是什么为什么需要注意联合索引中的顺序
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#创建的索引有没有被使用到或者说怎么才可以知道这条语句运行很慢的原因
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#那么在哪些情况下会发生针对该列创建了索引但是在查询的时候并没有使用呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#什么是事务
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#数据库的乐观锁和悲观锁是什么
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#acid是什么可以详细说一下吗
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#同时有多个事务在进行会怎么样呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#myql-中的事务回滚机制概述
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#并发事务带来哪些问题
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#怎么解决这些问题呢mysql的事务隔离级别了解吗
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#innodb使用的是哪种隔离级别呢
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql-中有哪几种锁
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#对mysql的锁了解吗
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#锁机制与innodb锁算法
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#mysql都有哪些锁呢像上面那样子进行锁定岂不是有点阻碍并发效率了
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#锁的优化策略
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#explain-性能分析
https://camo.githubusercontent.com/ab8a9040f82fb765b9bbb6cc1c419654030a3eec91caddfaa0b0a0ccb6dc3253/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f35613161366162346665333834326461383436653839663639646536326666327e74706c762d6b3375316662706663702d77617465726d61726b2e696d616765
https://github.com/github-esme/JavaInterview-1/blob/master/interviewDoc/Java/database/MySQL.md#如何优化sql
https://camo.githubusercontent.com/8de777862671bba9d38a3d99e00530466fbe27a25ef30a649bd1be164e1300be/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343431372e706e67
https://camo.githubusercontent.com/d381118bb9ffa9e6d5ec558c3e285bf6605a8a16a86a726af34d0bb276c338e8/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343634312e706e67
https://camo.githubusercontent.com/031cb86fec6a6d1ac41c60e2daf8da618024339710682a7d324d3ee47e1b2938/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343830372e706e67
https://camo.githubusercontent.com/7bd6245a4901fdc3deda8132ddde296eefb576c8f5abe8c46f8e8ca267037c36/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343932332e706e67
https://camo.githubusercontent.com/195dc8dde33626a5c4f102b95aec4980c31e1a4faf35e50a17d2c787f2512c15/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353133312e706e67
https://camo.githubusercontent.com/247a783acedc46ce90d2775c7ae8a952db3a58ada9a066a865f17f57a78be648/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353135382e706e67
https://camo.githubusercontent.com/4bd37c01e612b921815b88a84a71c43513755cf1aa5e8ba715615ce61052a44f/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353231332e706e67
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.