mysql issue

Daniel Fussell dfussell at byu.edu
Wed Feb 8 16:56:18 MST 2012


On 02/08/2012 04:49 PM, Jason Van Patten wrote:
> On 2/8/2012 4:38 PM, Daniel Fussell wrote:
>> On 02/08/2012 03:31 PM, Jason Van Patten wrote:
>> I've never used InnoDB with files per table option, so I can't comment
>> on that.  I will say that my innodb file is roughly twice the size of
>> the tables it contains.
>>
>> Grazie,
>> ;-Daniel Fussell
> Well the difference is that when working with smaller datasets on poorly
> designed dbs myisam is faster. But like i said once you hit 200K+
> records innodb will beat myisam query for query. Optimize it for innodb
> and you will see the innodb goodness flow.
> Jason
>
Exactly; I was just backing you up.

;-Daniel


More information about the PLUG mailing list