Re: Bug#151302: mysql-server: transparent gzip support on selected columns

Hello MySQL developers

I forward this in behalf of a Debian user who filed a bug report against
the Debian package.

bye,

-christian-

On Fri, Jun 28, 2002 at 07:21:26PM +0000, supaplex@xxxxxxxxxxx wrote:
> Package: mysql-server
> Version: 3.23.50-1
> Severity: wishlist
> 
> 
> Currently I have about 40000 records in a table that use to consume 800mb of 
> space. (about 23kb per row).  Now I'm compressing the column that stores the 
> text as a blob with gzip compression.  Now that table only uses 64mb of 
> space. (about 1600 bytes per row)
> 
> I'd like the compression on selected columns/tables/databases to be gzip 
> compressed.  It's benifical to my table structure in my case because the blob 
> column stores an XML document, and has good compression.  I never need to 
> select the documents by search paramaters on the column, so the only runtime 
> difference would be compressing(insert/updates) and decompressing(selects) 
> that column on the fly.
> 
> Thanks.
> 
> -- System Information
> Debian Release: 3.0
> Kernel Version: Linux pcbkits.com 2.2.20 #1 Wed Mar 20 20:01:51 EST 2002 i686 
> unknown
> 
> Versions of the packages mysql-server depends on:
> ii  adduser        3.47           Add and remove users and groups
> ii  debconf        1.1.11         Debian configuration management system
> ii  libc6          2.2.5-6        GNU C Library: Shared libraries and Timezone
> ii  libdbi-perl    1.28-1         The Perl5 Database Interface by Tim Bunce
> ii  libmysqlclient 3.23.50-1      mysql database client library
> ii  libstdc++2.10- 2.95.4-9       The GNU stdc++ library
> ii  libwrap0       7.6-9          Wietse Venema's TCP wrappers library
> ii  mysql-client   3.23.50-1      mysql database client binaries
> ii  perl           5.6.1-7        Larry Wall's Practical Extraction and Report
> ii  psmisc         21-3           Utilities that use the proc filesystem
> ii  zlib1g         1.1.4-1        compression library - runtime

ROBOT: php mysql


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113414@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php