MySQL Forums
Forum List  »  InnoDB

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

Hi,
we have in production this MySql database:

innodb_version 5.7.29
protocol_version 10
slave_type_conversions
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.

Claudio

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems joining big tables
275
February 16, 2020 04:08PM
130
February 16, 2020 08:47PM
128
February 18, 2020 10:40AM


Sorry, only registered users may post in this forum.

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.