https://www.percona.com/blog/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-2/ Wed, 07 Aug 2019 13:11:00 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-2/#comment-10970238 Wed, 30 Jan 2019 17:45:15 +0000 https://www.percona.com/blog/?p=55026#comment-10970238 Thank you for your input. can you please explain which part you think is missing? In the modified query, the data of both tables is “joined” (though without an actual join) inside the subquery, as it is a correlated query. The relevant part is: p.id = c.postid.

]]> https://www.percona.com/blog/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-2/#comment-10970233 Mon, 28 Jan 2019 21:00:11 +0000 https://www.percona.com/blog/?p=55026#comment-10970233 How is this even functional when there’s no command being used to join the data ? It should just run through the data and return nothing, or return an unorganized list of post titles and comments.

]]>