The only metric is "as big as it needs to be."
Personally I recommend setting innodb-file-per-table in the my.cnf, then configuring the
ibdata file to be some small size, with the autoextend option enabled. That way it will
take up only as much space as it needs, you'll be able to reduce space effectively by
Content-Type: text/plain; charset=ISO-8859-1
I want to know if there're a metric to adjust the innodb's ibdata file
Any reply is appreciated.
MySQL Senior Support Engineer,
Sun Gold Partner.
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies of
the original message.