https://www.percona.com/blog/using-generated-columns-in-mysql-5-7-to-increase-query-performance/ Fri, 16 Feb 2024 22:58:20 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/using-generated-columns-in-mysql-5-7-to-increase-query-performance/#comment-10970915 Fri, 21 Jun 2019 04:32:29 +0000 https://www.percona.com/blog/?p=47004#comment-10970915 What would be performance difference when we compare:
1. Index with generated stored vs virtual column.
2. Index with generated vs actual column.

]]> https://www.percona.com/blog/using-generated-columns-in-mysql-5-7-to-increase-query-performance/#comment-10968933 Mon, 29 Jan 2018 19:45:10 +0000 https://www.percona.com/blog/?p=47004#comment-10968933 The “GROUP BY verb, url” will not change the results, you will still SELECT CONCAT( verb, ‘-‘, URL), and will solve the wrong grouping done using the hash índex.
At least, MySQL finally has some reasonables defaults, it’s a pitty that DBAs insist in going back to the wrong ones…

]]>