Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql分表怎么办

mysql分表怎么办

WBOY
Release： 2016-06-13 10:07:38
Original
843 people have browsed it

mysql分表怎么处理?
数据量大的时候 如何根据数据量 比如一个表存放200万的数据 达到这个数据 自动分表 php如何结合mysql进行分表 查询怎么查询?

------解决方案--------------------
你想php中控制表的大小？

建议你翻下mysql的Partition，大概5.1+支持
将适当的字段根据range、hash……方式分区，我想一样能达到需求

如此的好处是，在数据操作中，你不需要人为去判断数据从哪些表中查询，

Related labels：
hash mysql partition php range
source：php.cn
Previous article：最新淘宝 API2.0 接口编写的淘宝客源码下载解决思路 Next article：关于网址缩短的程序是如何实现
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
How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
From 2024-04-06 21:44:19
0
1
603
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
From 2024-04-06 18:42:44
0
2
479
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