Problems joining big tables
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
Subject
Views
Written By
Posted
Problems joining big tables
884
February 16, 2020 04:08PM
406
February 16, 2020 08:47PM
431
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.