I am looking for some tips to correctly size the innodb tablespace.
The whole database is about 10GB and I couldn’t really find which es better for MySQL/innodb tablespace (assuming one tablespace and not per table tablespace):
- un big innodb file
- several smaller innodb files (eg . 5 files x 2GB)
We are using AIX 5.3 (which support large filesystems) an MySQL 5.0.24.
Thanks in advance.