Comments on: MySQL 8.0.14: A Road to Parallel Query Execution is Wide Open! https://www.percona.com/blog/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/ Fri, 02 Feb 2024 23:51:26 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Matt https://www.percona.com/blog/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/#comment-10971504 Fri, 29 Nov 2019 05:34:31 +0000 https://www.percona.com/blog/?p=54981#comment-10971504 Any further updates on when MySQL team will take this to the next step?

]]>
By: Jacob https://www.percona.com/blog/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/#comment-10970223 Thu, 24 Jan 2019 22:23:56 +0000 https://www.percona.com/blog/?p=54981#comment-10970223 Hi Alexander,

Thank you for the post – it is very good news. It means that Oracle/MySQL team is starting to address real urgent needs of MySQL users. However, talking about MySQL parallel query implementation we should mention Justin Swanhart who
released the first implementation for MySQL parallel queries in 2014 – five years ago. Unfortunately, it was quite difficult to install.

What surprises me that if this is such important and fundamental feature (and I think, it is), why it was mentioned so briefly in corresponding documentation on MySQL site? Does it mean that Sunny Bains (its implementor according to
blog https://mysqlserverteam.com/the-mysql-8-0-14-maintenance-release-is-generally-available/) just a little bit shy of his achievement? Or this parallel query execution is just hack-like use of new functionality? If this is just a hack, it could be
that we have to wait quite a long time for the second step in MySQL parallel query implementation.

I am also not sure how innodb-parallel-read-threads flag works in case of MySQL server running in virtual machine. According to the article, the higher number of threads leads to improved performance. It means that increasing the number of virtual CPUs should be beneficial. However, we also know (https://theithollow.com/2013/01/21/the-effect-of-too-many-virtual-cpus/) that too many virtual CPUs have decreasing effect on server performance. I wonder how this contradiction could be resolved? Is it possible to resolve it at all?

]]>
By: Abbas Ahmed https://www.percona.com/blog/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/#comment-10970221 Thu, 24 Jan 2019 13:54:19 +0000 https://www.percona.com/blog/?p=54981#comment-10970221 Well, I would say it’s not bad for a start. Baby steps 🙂

]]>
By: Adam Mulla https://www.percona.com/blog/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/#comment-10970218 Wed, 23 Jan 2019 18:23:58 +0000 https://www.percona.com/blog/?p=54981#comment-10970218 Thanks for your post. I will try it. I was also thinking why mysql don’t have parallel query execution like in Oracle ,MSSQL and PostgreSQL.

]]>