Hi, I am new to InnoDB. From the manual, InnoDB has tablespace which consistent of files (Segment).
When you specify the following parameter:
innodb_data_file_path = /ibdata/ibdata1:100M:autoextend; ibdata/ibdata2:200M
Does that means the 2 files (ibdata1 and ibdata2) are inside the same tablespace.
Then, is there any way to create or name multiple tablespace (like oracle) in InnoDB?
Also, Is there any way to coalescent the dropping extent like oracle or InnoDB will manage that automatically?