These two links should help you. http://www.mysql.com/doc/en/Column_types.html http://www.mysql.com/doc/en/Storage_requirements.html
I believe you would be using a 4byte field. So.. (1 314 000 000) * (4) = 5 256 000 000 bytes or, 5.256Tb (assuming my calculations are not in error) Huge. --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.932.0211 c. 601.209.4985 -----Original Message----- From: Jonas Askås [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:52 AM To: [EMAIL PROTECTED] Subject: Storage issue Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? Best regards, Jonas Askås --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
