MySQL Forums
Forum List  »  InnoDB

Problems joining big tables
Posted by: Claudio Battaglino
Date: February 16, 2020 04:08PM

we have in production this MySql database:

innodb_version 5.7.29
protocol_version 10
tls_version TLSv1,TLSv1.1,TLSv1.2
version 5.7.29-0ubuntu0.18.04.1
version_comment (Ubuntu)
version_compile_machine x86_64
version_compile_os Linux

The size of the database has grown unexpectedly.
Now we have a query that joins three tables with almost 70000, 360.000 and 115.000 rows.
If I make the query with LIMIT 100, the query
But If I make the query with limit 1000 the server hangs on.
Is there an upper limit on the length of the tables when you make a join on Mysql?
There are settings of Mysql that should be tuned?

Thank you very much, any help will be appreciated.


Options: ReplyQuote

Written By
Problems joining big tables
February 16, 2020 04:08PM
February 16, 2020 08:47PM
February 18, 2020 10:40AM

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.