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 records. Can someone please explain me if this is the intended behaviour or i am missing out something. I am also including the o/p of desc table_name of the same table on both the databases. This is a bit urgent. So any help is greatly appreciated. ID NOT NULL VARCHAR2(50) H0 NUMBER H1 NUMBER H2 NUMBER H3 NUMBER H4 NUMBER H5 NUMBER H6 NUMBER H7 NUMBER H8 NUMBER H9 NUMBER H10 NUMBER H11 NUMBER H12 NUMBER H13 NUMBER H14 NUMBER H15 NUMBER H16 NUMBER H17 NUMBER H18 NUMBER H19 NUMBER H20 NUMBER H21 NUMBER H22 NUMBER H23 NUMBER D1 NUMBER D2 NUMBER D3 NUMBER D4 NUMBER D5 NUMBER D6 NUMBER D7 NUMBER D8 NUMBER D9 NUMBER D10 NUMBER D11 NUMBER D12 NUMBER D13 NUMBER D14 NUMBER D15 NUMBER D16 NUMBER D17 NUMBER D18 NUMBER D19 NUMBER D20 NUMBER D21 NUMBER D22 NUMBER D23 NUMBER D24 NUMBER D25 NUMBER D26 NUMBER D27 NUMBER D28 NUMBER D29 NUMBER D30 NUMBER D31 NUMBER D32 NUMBER D33 NUMBER D34 NUMBER D35 NUMBER D36 NUMBER D37 NUMBER D38 NUMBER D39 NUMBER D40 NUMBER UPDATE_SECS NUMBER B_UPDATE_SECS NUMBER B1 NUMBER B2 NUMBER B3 NUMBER B4 NUMBER B5 NUMBER B6 NUMBER B7 NUMBER B8 NUMBER B9 NUMBER B10 NUMBER DATE_ADDED DATE DATE_MODIFIED DATE UPDATED DATE ORIGINAL VARCHAR2(50) COUNT NUMBER(10) IPADDR VARCHAR2(16) HI NUMBER IM VARCHAR2(15) ST VARCHAR2(20) BS NUMBER USERID NUMBER(10) PAGE NUMBER URL VARCHAR2(150) DESCRIPTION VARCHAR2(100) TAG VARCHAR2(4) NH NUMBER REFRESH NUMBER POPULATE VARCHAR2(6) LERY VARCHAR2(1) LIST VARCHAR2(1) LITE VARCHAR2(1) STING_ID VARCHAR2(20) YN VARCHAR2(1) RY_ID VARCHAR2(9) RATED VARCHAR2(1) CREATED DATE In mysql +-----------------------+---------------------+------+-----+---------------- ---+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------------- ---+-------+ | id | varchar(50) | | PRI | | | | H0 | tinyint(3) unsigned | YES | | NULL | | | H1 | tinyint(3) unsigned | YES | | NULL | | | H2 | tinyint(3) unsigned | YES | | NULL | | | H3 | tinyint(3) unsigned | YES | | NULL | | | H4 | tinyint(3) unsigned | YES | | NULL | | | H5 | tinyint(3) unsigned | YES | | NULL | | | H6 | tinyint(3) unsigned | YES | | NULL | | | H7 | tinyint(3) unsigned | YES | | NULL | | | H8 | tinyint(3) unsigned | YES | | NULL | | | H9 | tinyint(3) unsigned | YES | | NULL | | | H10 | tinyint(3) unsigned | YES | | NULL | | | H11 | tinyint(3) unsigned | YES | | NULL | | | H12 | tinyint(3) unsigned | YES | | NULL | | | H13 | tinyint(3) unsigned | YES | | NULL | | | H14 | tinyint(3) unsigned | YES | | NULL | | | H15 | tinyint(3) unsigned | YES | | NULL | | | H16 | tinyint(3) unsigned | YES | | NULL | | | H17 | tinyint(3) unsigned | YES | | NULL | | | H18 | tinyint(3) unsigned | YES | | NULL | | | H19 | tinyint(3) unsigned | YES | | NULL | | | H20 | tinyint(3) unsigned | YES | | NULL | | | H21 | tinyint(3) unsigned | YES | | NULL | | | H22 | tinyint(3) unsigned | YES | | NULL | | | H23 | tinyint(3) unsigned | YES | | NULL | | | D1 | tinyint(4) | YES | | NULL | | | D2 | tinyint(4) | YES | | NULL | | | D3 | tinyint(4) | YES | | NULL | | | D4 | tinyint(4) | YES | | NULL | | | D5 | tinyint(4) | YES | | NULL | | | D6 | tinyint(4) | YES | | NULL | | | D7 | tinyint(4) | YES | | NULL | | | D8 | tinyint(4) | YES | | NULL | | | D9 | tinyint(4) | YES | | NULL | | | D10 | tinyint(4) | YES | | NULL | | | D11 | tinyint(4) | YES | | NULL | | | D12 | tinyint(4) | YES | | NULL | | | D13 | tinyint(4) | YES | | NULL | | | D14 | tinyint(4) | YES | | NULL | | | D15 | tinyint(4) | YES | | NULL | | | D16 | tinyint(4) | YES | | NULL | | | D17 | tinyint(4) | YES | | NULL | | | D18 | tinyint(4) | YES | | NULL | | | D19 | tinyint(4) | YES | | NULL | | | D20 | tinyint(4) | YES | | NULL | | | D21 | tinyint(4) | YES | | NULL | | | D22 | tinyint(4) | YES | | NULL | | | D23 | tinyint(4) | YES | | NULL | | | D24 | tinyint(4) | YES | | NULL | | | D25 | tinyint(4) | YES | | NULL | | | D26 | tinyint(4) | YES | | NULL | | | D27 | tinyint(4) | YES | | NULL | | | D28 | tinyint(4) | YES | | NULL | | | D29 | tinyint(4) | YES | | NULL | | | D30 | tinyint(4) | YES | | NULL | | | D31 | tinyint(4) | YES | | NULL | | | D32 | tinyint(4) | YES | | NULL | | | D33 | tinyint(4) | YES | | NULL | | | D34 | tinyint(4) | YES | | NULL | | | D35 | tinyint(4) | YES | | NULL | | | D36 | tinyint(4) | YES | | NULL | | | D37 | tinyint(4) | YES | | NULL | | | D38 | tinyint(4) | YES | | NULL | | | D39 | tinyint(4) | YES | | NULL | | | D40 | tinyint(4) | YES | | NULL | | | UPDATE_SECS | int(10) unsigned | YES | | NULL | | | B_UPDATE_SECS | int(10) unsigned | YES | | NULL | | | B1 | tinyint(4) | YES | | NULL | | | B2 | tinyint(4) | YES | | NULL | | | B3 | tinyint(4) | YES | | NULL | | | B4 | tinyint(4) | YES | | NULL | | | B5 | tinyint(4) | YES | | NULL | | | B6 | tinyint(4) | YES | | NULL | | | B7 | tinyint(4) | YES | | NULL | | | B8 | tinyint(4) | YES | | NULL | | | B9 | tinyint(4) | YES | | NULL | | | B10 | tinyint(4) | YES | | NULL | | | DATE_ADDED | date | YES | | NULL | | | DATE_MODIFIED | date | YES | | NULL | | | UPDATED | timestamp | YES | | CURRENT_TIMESTAMP | | | ORIGINAL | varchar(50) | YES | | NULL | | | count | tinyint(3) unsigned | YES | | NULL | | | IPADDR | varchar(16) | YES | | NULL | | | HI | tinyint(4) | YES | | 0 | | | IM | varchar(10) | | | logo.gif | | | ST | varchar(10) | | | A | | | BS | tinyint(4) | YES | | 5 | | | USERID | smallint(6) | YES | | NULL | | | PAGE | tinyint(4) | | | 0 | | | URL | varchar(150) | YES | | NULL | | | DESCRIPTION | varchar(100) | YES | | NULL | | | TAG | varchar(4) | YES | | NULL | | | NH | bigint(20) unsigned | | | 0 | | | REFRESH | int(10) unsigned | YES | | 0 | | | POPULATE | varchar(6) | YES | | NULL | | | LERY | char(1) | YES | | N | | | LIST | char(1) | YES | | N | | | LITE | char(1) | YES | | N | | | STING_ID | varchar(20) | YES | | NULL | | | YN | char(1) | YES | | Y | | | RY_ID | varchar(9) | YES | | NULL | | | RATED | char(1) | YES | | Y | | | CREATED | date | YES | | NULL | | +-----------------------+---------------------+------+-----+---------------- ---+-------+ Thanks in advance sujay
