B
B
biryukovm2019-07-13 01:42:09
MariaDB
biryukovm, 2019-07-13 01:42:09

Why might a MYSQL query be processed differently?

Hi all.
Can someone come across a similar SQL query glitch.
There is a site with a catalog of goods, SQL query has a lot of links
Server - VDS RAM 4GB, xeon processor 2 cores
2.4 GHz MYSQL - mariadb
All tables on - InnoDB
1 query has 10 table links - 6 is LEFT JOIN and 4 inside SELECT (pulls out values)
So, to my surprise, I was poked-zeros and said that there is a problem on the site, the filter does not work.
I looked at the SQL query, the filter is formed correctly in the query, but it does not correctly select the data of the goods (it does not work correctly for a short time), as a result, I decided to come later and solve this problem.
5 hours passed and I decided to fix the code, but before fixing it, I decided to check the filter again.
I repeated the steps as I got the error, and to my surprise everything works.
And now for me it’s a mystery what
kind of ****** As a result there was a glitch and after 5 hours there was no glitch, I didn’t touch the code and didn’t correct anything.
Where is the dog buried? buffer? SQL memory? maybe the load on the site by clients has failed, but why is this not always?
Please answer seriously without humor.
I have been writing websites for more than one year, but this is the first time.
PS
Logo clean

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question