innodb: TRUNCATE vs. DELETE FROM

big disk-bound operations. Use DROP TABLE or TRUNCATE TABLE (from MySQL 4.0 up) to empty a table, not DELETE FROM tbl_name." bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel: +49 (0)431/97108-24 E-Mail: [EMAIL PROTECTED] Fax: +49 (0)431/97108-29

inodb: large old ibdata1 and multiple tablespaces

me, what would happen if I deleted the main ibdata1 file but left the .ibd intact? Would innodb recover gracefully? bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel: +49 (0)431/97108-24 E-Mail: [EMAIL PROTECTED] Fax: +49 (0)431/97108-29

Query help needed

eces" trick, but that is too slow. Can anyone help me out? bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel.: +(49) 0431/97108-24E-Mail: [EMAIL PROTECTED] Fax: +(49) 0431/97108-29 Internet: www.ariva.de

Re: I'd like to use MySQL but actually I'm not sure ...

ffering your service via SOAP etc., converting queries from XML and responses to XML bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel.: +(49) 0431/97108-24E-Mail: [EMAIL PROTECTED] Fax: +(49) 0431/97108-29 Internet: www.ariva.de -