-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Aaron Stone schrieb: | As noted earlier, InnoDB table never get smaller, they just get more | organized :o | | 10 seconds is almost too fast... oh, looks like OPTIMIZE TABLE might be | what you need, not just ANALYZE. |
Full ACK! | Based on some various web searching, it appears that InnoDB is not very | space efficient in general. Several blog posts I just read indicate that | InnoDB regularly uses 2-3x the space as the total of all data in it -- exactly what I wrote some messages before. In my case, the filesystem usage is round about twice the real data in the database. Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSJVcGts3frmum9swAQKpkAf/aMg0lnVEn+jhBaO2w3mfRl3RCumaVAmX zT0LGH6BSGA60Il42v1L4s/sBsP7dYxYdOhp1qcEhKduwhVy7zkEtksumsC0LvEu rqv9oivI0eDmy4pSo/taOzJTKj9Ppfl+smVKskCc7zCgFno7Ho8YL4baw521A2wi h0LLXw+JSWddAr6NVUy67O1zBHTCFVjdkwPLqAYtfUr8uThNDBYUtxgmwkw5wS5K gj1l34gcHVEtR0ZGMLTbG9jfYnrcmgrPL8YDdXnLe68B3Rj5LSgnTfQKSTKR/VY4 oSZABcwo5OgOM4wlV2Cy98L/ZJuPic0u7EavNenup8NJSGS3HhTLFQ== =PnKg -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
