MyISAM tables files have MYI suffix. See:
http://dev.mysql.com/doc/mysql/en/full-table.html
> Hi,
>
> I have a InnoDB database with MySQL version 4.1.0-alpha installed on my
> RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI".
>
>
> Currently the table size
Many many thanks... I was in confusion. But how can I exten the table
size.
Regards
Naveen
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Naveen C Joshi" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, March 15, 2005 7:52 PM
Subject:
Naveen C Joshi wrote:
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI".
These are MyIsam, not InnoDB.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me perfe
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat
Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI".
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me perfect command to extend my table size. The is my produ
t;
>>Other then that I wouldn't know. But live with the fact that keys
>>introduce overhead. It will be like that on any database system.
>>
>>>-Original Message-
>>>From: Xavier Leoncini [mailto:[EMAIL PROTECTED]]
>>>Sent: 30 July 2001 04:3
ve with the fact that keys
>introduce overhead. It will be like that on any database system.
>
>>-Original Message-
>>From: Xavier Leoncini [mailto:[EMAIL PROTECTED]]
>>Sent: 30 July 2001 04:34
>>To: [EMAIL PROTECTED]
>>Subject: Innodb table size
>&
ut live with the fact that keys
>introduce overhead. It will be like that on any database system.
>
>>-Original Message-
>>From: Xavier Leoncini [mailto:[EMAIL PROTECTED]]
>>Sent: 30 July 2001 04:34
>>To: [EMAIL PROTECTED]
>>Subject: Innodb table size
>&
d. It will be like that on any database system.
> -Original Message-
> From: Xavier Leoncini [mailto:[EMAIL PROTECTED]]
> Sent: 30 July 2001 04:34
> To: [EMAIL PROTECTED]
> Subject: Innodb table size
>
>
> Hello,
> I was wondering if someone could help me;
> Whe
Hello,
I was wondering if someone could help me;
When I load about 6Gb of raw data into a innodb table
the size used by the table is about 14G.
I noticed in preleminary tests that the sized used depends a lot on the
number of rows
in the case described above the data has about 180 millions rows,
