Hi list, db partitioning caused me some headache last days. I'm still not sure what the correct way of doing things would look like. Here my thoughts regarding the partition type - please correct me if they are wrong and / or let me know if they where useful:
HASH and KEY partitions ----------------------- You cannot drop partitions, at least not as we need it here - so this is IMO a NO-GO for these partition types in MySQL. LIST and RANGE partitions ------------------------- ALTER TABLE ... DROP PARTITION is possible, BUT: you cannot add a new RANGE partition between or before existing partitions - so IMO the only option left are LIST partitions. Kind regards, Thomas Gelf NB: All statements above are valid for MySQL only. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/