There is a tens of millions of-record table on MySQL 5.0.x, which now reads about 1 billion of the records. Common methods, followed by loops:
1
The code is as follows
Copy Code
SELECT * FROM mytable where index_col =
How does Mysql LIMIT optimize (reprinted) a large amount of data? mysqllimit
The following is a brief introduction to Mysql LIMIT. We all know that the LIMIT clause is generally used to LIMIT the actual number of rows returned by the SELECT
the solution for which limit and in cannot be used concurrently in MySQL.Category: MySQL2011-10-31 13:53 1277 people read comments (0) favorite reports Mysqlsubquery MySQL5.1 Neutron query cannot use limit, error: "This version of the MySQL
Paging usage and Performance Optimization of mysql limit
Mysql tutorial limit performance problems
A table with tens of millions of records on mysql 5.0.x needs to read about tens of thousands of records.
Common Methods:Select * from mytable where
In mysql, limit can achieve fast paging. However, if the data reaches several millions, our limit must be optimized to effectively implement paging. Otherwise, your server may be stuck.This is a problem when a table has millions of data records!For
I haven't used mysql limit for a long time. I thought it was an error (limit starts and ends). the correct one is (limit offset, number of items ), to remember this error, repeat a detailed description of limit usage. I recommend it to you and hope
When a table data has millions of of data, pagination is a problemsuch as SELECT * FROM table limit 0,10 This is no problem when the limit 200000,10 data reading is very slow, you can follow the method to solve
A recent web site's server reviews
In MySQL limit can achieve fast paging, but if the data to millions of when our limit must be optimized to effectively achieve a reasonable paging, otherwise may be stuck to your server oh.
When a table data has millions of of the data is a problem!
MySQL Tutorial limit performance issues
There is a tens of millions of-record table on MySQL 5.0.x, now read out a few 1 billion records
Common methods, followed by loops:SELECT * FROM mytable where index_col = xxx limit offset, limit;
Experience:
The optimization of MySQL is very important. The other most common and most need to optimize is limit. The limit of MySQL brings great convenience to paging, but when the amount of data is large, the performance of limit is reduced dramatically.
It'
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.