简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL分表（Partition）学习研究报告_MySQL

WBOY
Release： 2016-06-01 13:31:59
Original
874 people have browsed it

bitsCN.com

最近在开发一个新的项目，可能会产生大数据量，需要对部分表进行分表操作，故来研究学习MySQL的分表功能。

由于实验报告已经写成Exlce文件了，各位看过就直接下载吧：MySQL分表分析报告.xls

以下是此次实验的结论：

  1. Insert时，分表和不分表的性能所差无几；
  2. 大量数据Insert时，大量数据整合成一条Sql的性能比逐个Insert的性能提高很多；
  3. 分表与否并不影响查询操作，其返回的结果还是和不分表的是一样的；
  4. 实际数据的存储，并不是完全按照分表策略执行的，会存在一定的偏差；
  5. 查询如果不是针对分表属性的话，反而会稍微慢一点；但是按照查询字段进行分区的效果很明显；

如有纰漏错误，欢迎各位指教啊~~~

 

bitsCN.com
Related labels：
analysis report open
source：php.cn
Previous article：mysql基础：mysql列类型--字符串_MySQL Next article：MySQL连接超时自动断开连接问题_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Generate default values ​​and CSS variables using SCSS I'm implementing website styling. For legacy support reasons, I need to support IE11, at l...
From 2024-04-06 17:46:54
0
1
355
How do I tune these cards to respond with Boostrap 4? How can I make each row display 4 cards, and of course make them stack if the screen size ...
From 2024-04-05 10:48:45
0
1
4072
next not working properly in middleware using Nodejs I am working with Nodejs and using expressjs and now I am working on middleware functional...
From 2024-04-04 17:33:56
0
1
340
Challenges when using window.location.href to redirect to a new page I'm having trouble redirecting to a local domain php file, I've got it ready to redirect t...
From 2024-04-04 12:57:06
0
1
446
Content overflow in window prevents scrolling and hides new content I'm currently building a roulette system program (this is more to stop me from placing bet...
From 2024-04-03 21:24:55
0
1
285
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！