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, [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php