Re: Why does this table take 10x the disk space in MySQL compared to SQL Server?
"SHOW TABLE STATUS LIKE 'data1';"
CREATE TABLE `data1` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`column1` text,
`column2` text,
`column3` text,
`column4` text,
`column5` text,
`column6` text,
`column7` text,
`column8` text,
`column9` text,
`column10` text,
`column11` text,
`column12` text,
`column13` text,
`column14` text,
`column15` text,
`column16` text,
`column17` text,
`column18` text,
`column19` text,
`column20` text,
`column21` text,
`column22` text,
`column23` text,
`column24` text,
`column25` text,
`column26` text,
`column27` text,
`column28` text,
`column29` text,
`column30` text,
`column31` text,
`column32` text,
`column33` text,
`column34` text,
`column35` text,
`column36` text,
`column37` text,
`column38` text,
`column39` text,
`column40` text,
`column41` text,
`column42` text,
`column43` text,
`column44` text,
`column45` text,
`column46` text,
`column47` text,
`column48` text,
`column49` text,
`column50` text,
`column51` text,
`column52` text,
`column53` text,
`column54` text,
`column55` text,
`column56` text,
`column57` text,
`column58` text,
`column59` text,
`column60` text,
`column61` text,
`column62` text,
`column63` text,
`column64` text,
`column65` text,
`column66` text,
`column67` text,
`column68` text,
`column69` text,
`column70` text,
`column71` text,
`column72` text,
`column73` text,
`column74` text,
`column75` text,
`column76` text,
`column77` text,
`column78` text,
`column79` text,
`column80` text,
`column81` text,
`column82` text,
`column83` text,
`column84` text,
`column85` text,
`column86` text,
`column87` text,
`column88` text,
`column89` text,
`column90` text,
`column91` text,
`column92` text,
`column93` text,
`column94` text,
`column95` text,
`column96` text,
`column97` text,
`column98` text,
`column99` text,
`column100` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8
"SHOW TABLE STATUS LIKE 'data1'; "
name: data1
engine: InnoDB
version: 10
Name: data1
Engine: InnoDB
Version: 10
Row_format: Dynamic
Rows: 514
Avg_row_length: 3024378
Data_length: 1554530304
Max_data_length: 0
Index_length: 0
Data_free: 5242880
Auto_increment: 1001
Create_time: 2016-07-19 21:27:07
Update_time: 2016-07-19 21:33:51
Check_time:
Collation: utf8_general_ci
Checksum:
Create_options:
Comment
SELECT id, column1, length(column1), column100, length(column100) FROM data1 WHERE id=11;
id: 11
column1: 409744ca-13c5-48c9-bf73-704cd82f9c7948276e9b-7047-47b2-ad54-c5fafc2ae06682f4706d-7518-4726-bcda-acf7b55174af4b8fc55f-247e-483c-90a1-d0350068a0723478f843-5d77-4b8f-a456-bbb709ba702a67fcac0b-624a-41a4-90bb-54e048396519322ac272-06bb-47c6-bf9b-d28b7e06d982705d778a-b0f8-4d2e-b010-36712e681a97827180e7-54f6-42d2-9df4-af873479b033412a95cf-7d54-4094-b9bb-2960eef90404b189d988-a6ab-4916-9d07-988f296051981fda854f-7fcc-4808-b378-86c1d1d5fc1a2ff578be-ab37-45b2-94b2-6455c1865f570d92a095-b160-4195-8092-f33df91cb4ed70c0be1a-d938-431f-9ebc-ef6599ecd54ce33001c0-02fc-4678-9b72-96b44e5bc46a90561f04-6982-4a32-abd2-507f113bc7721e610921-c763-419d-a3aa-02b7b28dca6ae13e5cce-da5c-4a4a-a36c-63fe146a3cfd4379e720-f52e-4a6a-86a0-02f022c8b63b1a9ad901-0ffa-4d8b-afbb-75f3a5d4230e1ad7690c-8dd4-485a-b940-e6a58e85a938d0f1ea40-71e0-4121-a9bd-4860870049a13c943ae7-8fd8-40ec-81d8-8dacf3e20f12b9557e5e-35cc-4b9f-ba8a-d0249deebe128e9d2686-7786-4c9b-b6fc-5ab8773072892f5271ea-d788-4425-b23c-4d4e45ded6902ff6e194-d3cd-458a-8529-492e001aaf0c3cf0dd81-1a33-4689-bde8-c29910aeb31e1552cc28-a847-4e99-add3-cb93c900ad03e12d06a1-36fb-4094-b619-727ae0bacdb11ba3f638-af2d-410c-a855-7ed282b68fa609032d62-45e0-4214-8ce8-c05ea006770c42f7ec25-3be4-4826-a517-709558185c8e7571a966-12c3-417f-8ef8-fa897a41c7e3feaf66cc-7cd9-4d05-852d-d4b4ecdbde435fa43988-98e6-483c-8be1-c756d70b3ae23c4b8581-e0a7-492a-ae2c-a1b3157a8d6c29dc20b4-714c-413c-a951-3b868c5ce184ae2a5ca2-2bc1-4b7d-90d3-376a3b4d8f9276c404ea-6e68-4a58-b605-eb8eb84c85c6db4c4369-eda2-4dda-af7c-294661a66bfb875b05dc-c133-43b1-b995-070f80b1a75187c114e5-89e3-43e3-8188-2f85c0dddae5dcc87411-1417-4c17-b9bd-afc99a742a712e9b13dd-d572-46ca-b8d4-25884d055b6486a6397b-ae43-479c-b73b-5205ee88dbdab5e21d2f-87e6-468f-8b02-f0deb6ba1fe2f1960991-4c6e-47bc-8736-b153a773ac00f1c6d1f4-eaf6-4f72-86fe-4cc0f4a574eb
length(column1): 1800
column100: 5e3624f3-072e-4e29-b258-ee6f9ce9aafaeda2479f-9550-4f27-b559-9ca15003a69ad03ad34a-8ce3-4da4-aa79-0913a733ce078a167aeb-8788-47a6-8046-ac80f7197687362cbc92-0bac-4dda-bf86-63e08de4bb6ceaca1b71-a4ba-4eb3-a350-826f1a5f4cfb8830217c-9ad7-4890-b1f4-bddbe1152c0b95c1273c-10e9-4e43-a808-0521448ea9b17aa8f9ee-b4d5-4179-9c35-0b6ac46d59ad8a18e288-146f-481f-b6e9-e9f720998608563d6bb1-accd-4f78-ac2d-95eda4b859146723d9e8-fe3c-4975-93bf-7013b068721ce96362a9-0764-4f80-bbfb-ba6b239ede4cdaaa2b1a-5a3c-44dd-827d-5204c9e7e6828483228e-4d40-4d1e-84db-f7666ad023bdf61d7578-abd2-462a-b608-99a65c0e0d23d811007c-16a7-4e79-8b66-f5933ef97fba6b9d84e6-0703-4341-af98-47f2e827fd3d0260e573-914b-4440-baf2-8e3ea3706be341cd227f-ec38-485f-a62c-050dcf16f9fffcff684c-f96a-47c2-971f-7067e8ba78e1245fd0ee-6a8a-4f1a-891f-179679b3c72a05097dca-bab3-4058-b992-ae23314e5c7e447fbcee-35c1-4c40-a1c6-2d6515032ad0553d0946-f258-446a-a15e-d65722fb35917e80425b-a303-4537-9f31-d76c02dc035f335553db-225b-4d52-9786-4ceee6a78c764375c58b-8cc4-4a07-b82f-060b7d5aff5558f59251-2524-411d-8fd3-b0eb6384ff8b28aace00-0a1f-4095-ae34-98e332cc48e8d066fb0d-deb8-4e19-a61e-d94987e3823d43d8b5e7-b724-4a84-8aa7-e16cff44a653ae9bbd77-54af-4d9a-b220-6e584bcd7cb26b27bdff-f8a8-4de5-a1c1-f03a43362aaf8c0e6adb-0c3c-400a-ac6e-72c1d61fe9f55d3540cf-2f67-4727-8bbb-02f98efacdf5dbb1f9ef-3cd8-4c51-9abb-ed59e7bcd2616ac82e02-2b32-4e15-b008-2459ae27b5cdbdc599e2-6d96-4ad8-8c74-b7afc78f80b208f5b2e2-06f7-447f-9038-4f4cbadc965b8a77cb61-7dac-4cb1-a6a9-dd6a9c45cda03f5a2b61-da0d-408c-9f63-e5eda1de66319d66550c-59d9-4608-93ae-f6b06d985d420c7d5f6c-e0df-49ef-9d31-8df5ffc9f0d86fcb9cef-535a-4dbc-af91-1d12df9aaff901bdd6f8-0451-4457-b1a4-d0ee97fd3ca6bee9909d-9245-4a0c-b3ec-37fb980b9606b6285595-f9c9-477b-ad53-598fb1bb75e949a0073d-305c-43da-93cc-301b9dc545da00c92ff5-d782-4a05-aa9b-cbedd0ab28f3
length(column100): 1800
Any ideas?