Sample Header Ad - 728x90

How do MySQL 5.7 virtual columns differ from views?

4 votes
1 answer
1183 views
Starting reading point: https://www.percona.com/blog/2015/04/29/generated-virtual-columns-in-mysql-5-7-labs/ Running some tests with the most recent percona 5.7 they seem to work well. Explain plans and wall time look pretty good but I'm not seeing any difference in show table status index_length or data_length. How do you find the true footprint or overhead for using these? Unlike views they do seem to be faster than bookmarked selects.
Asked by atxdba (5293 rep)
Dec 22, 2015, 05:14 AM
Last activity: Dec 22, 2015, 03:12 PM