| 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:8456f2fe-9f5c-cd89-3748-cbf77d3e53f1 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | B280:127098:A3512:EDA7F:6AFC65FD |
| html-safe-nonce | e9dc4c203f946431131675b5b96039584a585955ee27920b664ae86e09e0fc30 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMjgwOjEyNzA5ODpBMzUxMjpFREE3Rjo2QUZDNjVGRCIsInZpc2l0b3JfaWQiOiI0NjU4MDE0OTEzMzIxMjY0NjM3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 8eba36e4256ca54df664e6b198ac02fe38aea804a2202c3ef504419fae546a4a |
| hovercard-subject-tag | repository:671940861 |
| 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/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md |
| twitter:image | https://opengraph.githubassets.com/45f1db4aeaefae8b8d37f14e79a1663a9c8b9b4d288156d9f27460aaa277bdd7/alphasu/JavaInterview |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/45f1db4aeaefae8b8d37f14e79a1663a9c8b9b4d288156d9f27460aaa277bdd7/alphasu/JavaInterview |
| og:image:alt | Java面试整理,涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - alphasu/JavaInterview |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 70a7e1972ba67881db0411d676e97455aa21c3f3dd866ccba1e1c32fb9c8a04e |
| turbo-cache-control | no-cache |
| go-import | github.com/alphasu/JavaInterview git https://github.com/alphasu/JavaInterview.git |
| octolytics-dimension-user_id | 13924301 |
| octolytics-dimension-user_login | alphasu |
| octolytics-dimension-repository_id | 671940861 |
| octolytics-dimension-repository_nwo | alphasu/JavaInterview |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | true |
| octolytics-dimension-repository_parent_id | 245599072 |
| octolytics-dimension-repository_parent_nwo | gsjqwyl/JavaInterview |
| octolytics-dimension-repository_network_root_id | 245599072 |
| octolytics-dimension-repository_network_root_nwo | gsjqwyl/JavaInterview |
| 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 | 7de95a0365c2894414eb47078bb1a54e816fff50 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#start-of-content |
| https://redirect.github.com/ |
| Sign in | https://redirect.github.com/login?return_to=https%3A%2F%2Fgithub.com%2Falphasu%2FJavaInterview%2Fblob%2Fmaster%2FinterviewDoc%2FJava%2Fdatabase%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%2Falphasu%2FJavaInterview%2Fblob%2Fmaster%2FinterviewDoc%2FJava%2Fdatabase%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=alphasu%2FJavaInterview |
| Reload | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md |
| Reload | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md |
| Reload | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md |
| alphasu | https://redirect.github.com/alphasu |
| JavaInterview | https://redirect.github.com/alphasu/JavaInterview |
| Code | https://redirect.github.com/alphasu/JavaInterview |
| Pull requests | https://redirect.github.com/alphasu/JavaInterview/pulls |
| Actions | https://redirect.github.com/alphasu/JavaInterview/actions |
| Projects | https://redirect.github.com/alphasu/JavaInterview/projects |
| Security and quality | https://redirect.github.com/alphasu/JavaInterview/security |
| Insights | https://redirect.github.com/alphasu/JavaInterview/pulse |
| https://redirect.github.com/alphasu/JavaInterview |
| JavaInterview | https://redirect.github.com/alphasu/JavaInterview/tree/master |
| interviewDoc | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc |
| Java | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc/Java |
| database | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc/Java/database |
| History | https://redirect.github.com/alphasu/JavaInterview/commits/master/interviewDoc/Java/database/MySQL.md |
| https://redirect.github.com/alphasu/JavaInterview/commits/master/interviewDoc/Java/database/MySQL.md |
| JavaInterview | https://redirect.github.com/alphasu/JavaInterview/tree/master |
| interviewDoc | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc |
| Java | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc/Java |
| database | https://redirect.github.com/alphasu/JavaInterview/tree/master/interviewDoc/Java/database |
| Raw | https://github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A4%96%E8%BF%9E%E6%8E%A5left-joinright-join |
| 联合查询(UNION与UNION ALL) | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%A8%E8%BF%9E%E6%8E%A5full-join |
| UNION与UNION ALL的区别? | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#union%E4%B8%8Eunion-all%E7%9A%84%E5%8C%BA%E5%88%AB |
| SQL语句优化的一些方法? | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%98%E5%82%A8%E6%97%B6%E6%9C%9F |
| 解释 MySQL 外连接、内连接与自连接的区别 | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%9F%BA%E7%A1%80 |
| 创建索引的语法 | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E7%B1%BB%E5%9E%8B |
| 索引的区别 | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB |
| MySQL索引的创建原则 | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E5%88%86%E7%B1%BB |
| MySQL索引的注意事项 | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8E%9F%E7%90%86 |
| 解题方法 | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%A7%A3%E9%A2%98%E6%96%B9%E6%B3%95 |
| 创建MySQL联合索引应该注意什么? | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam%E7%B4%A2%E5%BC%95%E5%AE%9E%E7%8E%B0 |
| MyISAM索引与InnoDB索引的区别? | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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+Tree | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-%E5%92%8C-btree |
| 为什么 B+Tree 比 B-Tree 更适合实际应用中操作系统的文件索引和数据库索引?** | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1 |
| 数据库的乐观锁和悲观锁是什么? | https://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/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://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#explain-%E6%80%A7%E8%83%BD%E5%88%86%E6%9E%90 |
| 如何优化SQL | https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96sql |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中的varchar和char有什么区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#varchar10和int10代表什么含义 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#请说明varchar和text的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#float和double的区别是什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如何在mysql种获取当前日期 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义-1 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb的事务与日志的实现方式 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql的binlog有有几种录入格式分别有什么区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql数据库cpu飙升到500的话他怎么处理 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#超大分页怎么处理 |
| https://camo.githubusercontent.com/3a28f3d1abba23dc986ef33c9aec8456d2957ca3993b24fa0d09132adc92e677/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313433393534382d3830363439383133352e706e67 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#关心过业务系统里面的sql耗时吗统计过慢查询吗对慢查询都怎么优化过 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#横向分表和纵向分表可以分别举一个适合他们的例子吗 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是存储过程有哪些优缺点 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#说一说三个范式 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql的复制原理以及流程 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#六种关联查询 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#内连接分为三类 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#外连接left-joinright-join |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#联合查询union与union-all |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#全连接full-join |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#union与union-all的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql语句优化的一些方法 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql由哪些部分组成-分别用来做什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如果一个表有一列定义为timestamp将发生什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-里记录货币用什么字段类型好 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#你们数据库是否支持emoji表情如果不支持如何操作 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-数据库作发布系统的存储一天五万条以上的增量-预计运维三年怎么优化 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#一个6亿的表a一个3亿的表b通过外间tid关联你如何最快的查询出满足条件的第50000到第50200中的这200条数据记录 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#优化数据库的方法 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#简单描述-mysql-中索引主键唯一索引联合索引的区别对数据库的性能有什么影响从读写两方面 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql-注入漏洞产生的原因如何防止 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#存储时期 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#解释-mysql-外连接内连接与自连接的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#存储引擎常用命令 |
| https://camo.githubusercontent.com/a7c18c1575a3e9457ab0afc58bb2b3081e9c5490b4314ce3493f4fc506f0517a/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323730312e706e67 |
| https://camo.githubusercontent.com/a7d6e2d5dcda1b5c7952e8138e075977282c25b3dfebbfc151a4e2c41b1f9c71/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323735332e706e67 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql支持哪些存储引擎 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#请说明innodb和myisam的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb引擎的特性 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是触发器mysql中都有哪些触发器 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb和myisam有什么区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisamchk-是用来做什么的 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么要尽量设定一个主键 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#主键使用自增id还是uuid |
| https://camo.githubusercontent.com/a1d59262cf3f4106ae6b68dba2fa1b11530b627488022b0d0eed0d13d80461ac/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313431363731342d3738303935303033302e706e67 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#字段为什么要求定义为not-null |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如果要存储用户的密码散列应该使用什么字段进行存储 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引是个什么样的数据结构呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#唯一索引比普通索引快吗-为什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的优缺点 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#做过哪些mysql索引相关优化 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#怎么看到为表格定义的所有索引 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的基础 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建索引的语法 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引对性能的影响 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的类型 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的创建原则 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的使用场景 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引分类 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的注意事项 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的原理 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#解题方法 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建mysql联合索引应该注意什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#列值为null时查询是否会用到索引 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#以下语句是否会应用索引select-from-users-where-yearadddate--2007 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引实现 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引与innodb索引的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#使用索引查询一定能提高查询的性能吗为什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么情况下设置了索引但无法使用 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#超键候选键主键外键分别是什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#简单说一说dropdelete与truncate的区别 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#dropdelete与truncate分别在什么场景之下使用 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-和-btree |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么-btree-比-b-tree-更适合实际应用中操作系统的文件索引和数据库索引 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是视图以及视图的使用场景有哪些 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#hash索引和b树所有有什么区别或者说优劣呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么用-b-树做索引而不用哈希表做索引 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引是什么有什么作用以及优缺点 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#上面提到了b树在满足聚簇索引和覆盖索引的时候不需要回表查询数据什么是聚簇索引 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#非聚簇索引一定会回表查询吗 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#在建立索引的时候都有哪些需要考虑的因素呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#联合索引是什么为什么需要注意联合索引中的顺序 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建的索引有没有被使用到或者说怎么才可以知道这条语句运行很慢的原因 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#那么在哪些情况下会发生针对该列创建了索引但是在查询的时候并没有使用呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是事务 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#数据库的乐观锁和悲观锁是什么 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#acid是什么可以详细说一下吗 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#同时有多个事务在进行会怎么样呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myql-中的事务回滚机制概述 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#并发事务带来哪些问题 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#怎么解决这些问题呢mysql的事务隔离级别了解吗 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb使用的是哪种隔离级别呢 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-中有哪几种锁 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#对mysql的锁了解吗 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#锁机制与innodb锁算法 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql都有哪些锁呢像上面那样子进行锁定岂不是有点阻碍并发效率了 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#锁的优化策略 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#explain-性能分析 |
| https://camo.githubusercontent.com/82efafe171f5dc7f4f72b953cfd03a3c828d616f28615f5d61a2fc94d93b2a13/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f35613161366162346665333834326461383436653839663639646536326666327e74706c762d6b3375316662706663702d77617465726d61726b2e696d616765 |
| https://redirect.github.com/alphasu/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如何优化sql |
| https://camo.githubusercontent.com/c0908f0421b17b719cc48db65181c11fb9eb0f80266d0d5f55a7a6b402853647/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343431372e706e67 |
| https://camo.githubusercontent.com/048a553e7235440c9fb1965a633a4532087854220460a154024ec5156a9969a5/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343634312e706e67 |
| https://camo.githubusercontent.com/331e5eeba545cc37864c6851eaa362b1af17fbae2fc556232d1d7a4148d03426/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343830372e706e67 |
| https://camo.githubusercontent.com/873382ef8b4f63a156ae15f630f182fe5ad62b81d7bfd6295f9eb818d2b914a5/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343932332e706e67 |
| https://camo.githubusercontent.com/e72860c09dd4c93cb20da8bf91016667c6ed4c14f676d49e0f98091b6dbd5b99/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353133312e706e67 |
| https://camo.githubusercontent.com/f0a5fe6258891f4edb253b3ea2336fa6569c919a350a271c1150aa9abe118739/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353135382e706e67 |
| https://camo.githubusercontent.com/89d289fe7f80f595eeb431a9b1f472a9740ab3cf53fe2e700b1cbd49c290463e/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353231332e706e67 |
|
| 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 |