Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

[Ifechukwukwu Okobi]

Rick James Wrote:
-------------------------------------------------------
> While I have your attention...
>
> What is in those LONGBLOBs? Text? Pictures? In
> particular, is it something compressible? English
> compresses 3:1. Shrinking the row sizes will let
> you keep more rows and run faster. Faster is
> because of less I/O.
>
> When DESCRIBEing a table, please use SHOW CREATE
> TABLE, it is more descriptive. For one thing, it
> shows the indexes, and indexes are a significant
> thing to consider when having 500GB tables and
> when using PARTITIONing. There are a few caveats
> on indexing; I can't see what index issues I may
> need to advise you on.


Sound Files.

Please find create table output.

CREATE TABLE `upload_table` (
`id` varchar(50) NOT NULL default '',
`filename` varchar(255) default NULL,
`previewfile` longblob,
`binaryfile` longblob,
`list_id` varchar(50) NOT NULL default '',
`preview_exists` tinyint(1) default '0',
`serve_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`,`list_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8