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

期待MySQL 5.1正式版的发布

WBOY
Release： 2016-06-07 16:52:30
Original
822 people have browsed it

MySQL 5.1正式版迟迟还没有出来。我等它就是为了等它的表分区功能，有了这个功能，一个表因数据量太多就会严重影响到速度的烦恼就

　　MySQL 5.1正式版迟迟还没有出来。我等它就是为了等它的表分区功能，有了这个功能，一个表因数据量太多就会严重影响到速度的烦恼就会迎刃而解。

　　表分区，即是一个表可以有多个分区，每个分区物理上等同于多个表，但是在逻辑上可以将它们当作一个表管理。这样就可以将关联性不大的数据分割到不同的分区，这样程序到体积相对小巧的分区里面读取数据自然快速很多。不过这里有个前提，你的数据分割得要合理，因为经常性的出现跨分区做数据分析，例如简单的排序，速度也会变得慢起来。

　　现在的multishop系统由于没有表分区功能，被逼使用了库表散列，将data按照企业来划分开到结构相同的N个表中。这样客户（企业）就会根据确定的company_id去到特定的表中读写数据。而系统管理人员若要抽取各企业的数据进行比较，，就需要访问N个表，然后在程序里对N个结果集进行整合。呵呵，对比之后，无轮是编程上还是管理上还是表分区方便一点。

linux

Related labels：
MySQL知识 MySQL 5.1 期待MySQL 5.1正
source：php.cn
Previous article：MySQL4到MySQL5转移要点 Next article：记录Linux下一次oracle启动错误
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
Root user is denied access to MySQL I recently installed MySQL on x86_64 Access denied for "localhost" (using passwo...
From 2023-11-09 11:00:45
0
1
204
How to get the RGB value of CSS/HTML named color in JavaScript I have created a Javascript object called [name-rgb]. Your basic:namedColors={AliceBlue:[2...
From 2023-11-06 09:05:50
0
2
210
How-to: Switch dark mode using TailwindCSS + Vue3 + Vite I'm a beginner in Vite/Vue3 and currently I'm facing a problem where I need the combined k...
From 2023-11-01 12:05:00
0
1
272
Connect Visual Studio Code to a remote MySQL database: Simplify the connection process I know this should be more focused, but I've wasted an entire day doing this and I can't f...
From 2023-10-24 20:41:24
0
2
231
How to synchronize development and production databases Do you know of any application that synchronizes two databases - during development someti...
From 2023-10-22 23:37:30
0
1
247
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！