MySQL Forums
Forum List  »  MyISAM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
Posted by: Ifechukwukwu Okobi
Date: January 30, 2015 05:49AM

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`)

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.