Re: Deciding whether to convert to InnoDB

2004-01-05 Thread Travis Reeder
Very much so. That's why I'm trying to get as much juice out of the cpu as possible. Travis Dan Nelson wrote: In the last episode (Jan 05), Travis Reeder said: I'm sure this has been asked before, but I cannot find solid evidence as to whether switching would provide us with any benefits.

Re: Deciding whether to convert to InnoDB

2004-01-05 Thread Dan Nelson
In the last episode (Jan 05), Travis Reeder said: > I'm sure this has been asked before, but I cannot find solid evidence > as to whether switching would provide us with any benefits. > > We currently run MyIsam tables on 4.1.x and we are continuously > processing 24 hours/day and using about 20 t

RE: Deciding whether to convert to InnoDB

2004-01-05 Thread Joshua Thomas
8-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -Original Message- > From: Travis Reeder [mailto:[EMAIL PROTECTED] > Sent: Monday, January 05, 2004 3:02 AM > To: MySQL List > Subject:

Re: Deciding whether to convert to InnoDB

2004-01-05 Thread Sam Vilain
Set up a load test system which is as near a replica of your production environment as possible. Capture an hour's worth of transactions. Load an copy of your database. Play the queries in and see how long it takes. Any advice without taking something like the above steps is pure speculation, a

Deciding whether to convert to InnoDB

2004-01-05 Thread Travis Reeder
Hi, I'm sure this has been asked before, but I cannot find solid evidence as to whether switching would provide us with any benefits. We currently run MyIsam tables on 4.1.x and we are continuously processing 24 hours/day and using about 20 tables heavily. The process is generally doing Updat