Hello.
Have a look here:
http://lists.mysql.com/mysql/194596
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
If you feel uncomfortable with 10G ibdata size, you may want to
switch to per-file tablespace:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
http://dev
:~> -Original Message-
:~> From: Shaun Adams [mailto:[EMAIL PROTECTED]
:~> Sent: Tuesday, February 07, 2006 4:32 PM
:~> To: mysql@lists.mysql.com
:~> Subject: INNODB Questions and Optimization help
:~>
:~> Questions:
:~>
:~> 1. The ibdata1 file size is 10GB. Does that sound right? Shou
Shaun Adams wrote:
1. The ibdata1 file size is 10GB. Does that sound right? Should this file
be this big?
That sounds right. Innodb seems to incur large space overheads. but with
the cost of diskspace nowadays...
2. Once a week, I have to perform HUGE insert imports into the database.
