Hartmut, Monday, October 14, 2002, 2:07:11 PM, you wrote: HB> Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored HB> on several Sun servers. The Sun servers are responsible for collecting HB> all config data from all equipment connected to the network.
HB> We have developed scripts that import data into several mysql databases HB> on a dedicated machine. Four weeks of data is roughly equivalent to HB> 4 million rows of information in these databases. HB> In addition to this, other scripts sort through the data, "promoting" only the most recent data into another database using a CREATE TABLE...SELECT statement(since there is currently no SELECT HB> INTO statement in mysql). HB> I have noticed, that although there is much less information in this promoted database, it's on-disk-size is MUCH LARGER than the original HB> databases from which the information was promoted. HB> Running a 'myisampack' command on the databases, the compression ratio is typically 95% or better !! HB> Can someone explain this, and possibly suggest a solution on how to reduce this HUGE database size, without having to run a 'myisampack' HB> each time ? What is your CREATE .. SELECT statement? What is the size of initial table and new table? Is initial table compressed? What version of MySQL server are you using? What OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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