In 5.6.27 I see the following memory usage by performance schema:
| performance_schema | performance_schema.memory | 1794090344 |
This is for:
bin/mysqld_safe --no-defaults --table_definition_cache=50000 &
So, it seems memory pre-allocation is what takes time in 5.6.x and (as 5.7 defers some meory allocation) is a reason why 5.7 is not that much affected.
In 5.6.27 I see the following memory usage by performance schema:
| performance_schema | performance_ schema. memory | 1794090344 |
This is for:
bin/mysqld_safe --no-defaults --table_ definition_ cache=50000 &
So, it seems memory pre-allocation is what takes time in 5.6.x and (as 5.7 defers some meory allocation) is a reason why 5.7 is not that much affected.