With MySQL 5.7 there will be many improvements and changes. The most valuable ones are:
1. “General Tablespace” feature -> From now you can place tables to separate tablespaces. Prior, on our hands there were only “System TableSpace” and “InnoDB file per table” options.
Check for further reading: General Tablespaces Create statement: Create TableSpace
2. Resizing InnoDB Buffer Pool online -> for changing innodb_buffer_pool_size variable restart is required prior to MySQL 5.7, from now we can change buffer pool size without restart dynamically. Read Documentation -> …
[Read more]