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
Do you need foreign keys? Then the switch to InnoDB may be worthwhile. That's part of the reason I switched. I also had occasional table corruption with my myISAM tables; this also went away when I switched to InnoDB. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-614

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