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 1
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.
I currently have a customer who we switched over to INNODB from MyISM. It's
a Dell Server with 4GB or Memory and RHEL4 64-bit. It's a fairly big
database the size of the MyISM folders (before we converted to INNODB)
was about 2-3Gigs.
Questions:
1. The ibdata1 file size is 10GB. Does tha
