MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Slow simple query in 4000000 records table
Posted by: Rick James
Date: November 29, 2010 10:55AM

KEY `datetime_reverse` (`datetime_reverse`),
KEY `datetime_r_nid` (`datetime_reverse`,`node_id`),
The former is redundant and can be dropped without loss of functionality.

innodb_buffer_pool_size | 650117120
Are some other tables using InnoDB? If not, then this is a big waste of RAM. Further details: http://mysql.rjweb.org/doc.php/memory

What is the rationale for LIMIT 3450000,50 ?

Can you use ranges of node_id instead of the LIMIT/OFFSET?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slow simple query in 4000000 records table
3536
Matias Burak
November 24, 2010 04:56PM
Re: Slow simple query in 4000000 records table
1613
Zsolt Kendi
November 26, 2010 08:02AM
Re: Slow simple query in 4000000 records table
2405
Rick James
November 27, 2010 01:42PM
Re: Slow simple query in 4000000 records table
1851
Matias Burak
November 29, 2010 09:16AM
Re: Slow simple query in 4000000 records table
1623
Rick James
November 29, 2010 10:55AM
Re: Slow simple query in 4000000 records table
1641
Matias Burak
November 30, 2010 05:43AM
Re: Slow simple query in 4000000 records table
1599
Matias Burak
November 30, 2010 08:11AM
Re: Slow simple query in 4000000 records table
2240
Rick James
November 30, 2010 09:50AM
Re: Slow simple query in 4000000 records table
1605
Matias Burak
November 30, 2010 10:06AM
Re: Slow simple query in 4000000 records table
1523
Rick James
December 01, 2010 12:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.