PROTECTED]
Sent: Tuesday, September 27, 2005 3:59 AM
To: Sujay Koduri
Cc: mysql@lists.mysql.com
Subject: Re: Avg row length is varying a lot from oracle to MySQL
Sujay Koduri wrote:
> we are converting our oracle DB to MySQL DB. One problem i see is that
> the abg row length in MySQL is much
Sujay Koduri wrote:
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle. In
oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as a
result, MySQL is taking more space to store the same numb
Jeff wrote:
Each row in the table takes around 600 bytes, taking every
thing into consideration and assuming every field is used to
its maximum bytes. But the major portion of this 600 bytes
are composed of varchar's (100 + 150 + 50 + 16 + 50 + 20 +
9..) Out of these 400 bytes we generally use
w. I
believe there is also some paging overhead so generally take your
calculated row size and multiply by 1.1.
> sujay
>
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 23, 2005 1:12 AM
> To: mysql@lists.mysql.com
> Subject: RE:
mysql@lists.mysql.com
Subject: RE: Avg row length is varying a lot from oracle to MySQL
> -Original Message-
> From: Sujay Koduri [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 15:23
> To: mysql@lists.mysql.com
> Subject: Avg row length is varying a lot from oracle
> -Original Message-
> From: Sujay Koduri [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 15:23
> To: mysql@lists.mysql.com
> Subject: Avg row length is varying a lot from oracle to MySQL
>
>
> hi ,,
>
> we are converting our oracle DB to
hi ,,
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle.
In oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as
a result, MySQL is taking more space to store the same number of record
