Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Gabriel PREDA
Yes they're all right ! Database is the last thing on your problem list... I don't know how you thought the system... if it's WEB based... more problems arrise... In a potential scenario... I miself would power up the database server with an UPS... because it contains DATA... the application...

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Karl Larsen
Chris White wrote: On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: ALL I am asking is how strong you think MySQL stands up in such a business scenario. I have even created the manual business procedures for power-failure scenarios. I DO need to know HOW gracefully MySQL will recover aft

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Brent Baisley
to keep a unique id for each record in that table. - Original Message - From: "Asif Lodhi" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 27, 2006 1:22 PM Subject: multi-column indexes on InnoDB tables Hi, I have created 4, 5 and 8 column unique indexes ( I had to -

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Chris White
On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: > ALL I am asking is how strong you think MySQL stands up in such a > business scenario. I have even created the manual business procedures > for power-failure scenarios. I DO need to know HOW gracefully MySQL > will recover after each power fai

multi-column indexes on InnoDB tables

2006-06-27 Thread Asif Lodhi
Hi, I have created 4, 5 and 8 column unique indexes ( I had to - the application requirements dictated me to do so) on some tables in an InnoDB only database on a 5.0.22 MySQL server running on XP-SP2 machine. The 4-col indexes are on order, invoice and receipt tables; the 5-col indexes are on d