Bug #67792 Specify the initial size of a tablespace

Description:
InnoDB should can specify the datafile initial size, because if InnoDB under heavy write workload, InnoDB table datafile need to extend space frequently, it will effect performance.
And if we know the upper limit of the table, we can extend the space to upper limit when we create table. 

How to repeat:
heavy write workload to InnoDB

Suggested fix:
InnoDB can specify the datafile initial size.

CREATE TABLE test (
 id int ....
) ENGINE=InnoDB DATAFILE_INITIAL_SIZE=10000000;

DATAFILE_INITIAL_SIZE can specify the initial size of datafile, the unit is page.

this patch add a new option in creating table--DATAFILE_INITIAL_SIZE

Attachment: innodb_initial_size.diff (application/octet-stream, text), 5.71 KiB.

this patch based on 5.5.18

Thank you for the idea! I think that this should be a persistent attribute of the tablespace. (Currently it is 1 InnoDB table per tablespace (*.ibd file), but I would like to make this generic.)