Percona or MySQL

[MR.KiDO]

Hello,

I am a bit confused on which one should I use. My forum uses 3 types of storage engines InnoDB (around 94%), MEMORY(3% again) and MyISAM( around 2% again). :heiligenschein:

Also my site has traffic of around 2.7k daily and for every guest it runs around 22 queries and around 6mb of data. So around 2700 x 22 = 59400 queries and around 15GB of data is transferred in MySQL.

Kind Regards
=]

 

[REAK]

InnoDB with proper configurations should be fine,

Your setup isnt big enough to bring some drastic changes, if you need faster mysql execution move mysql to SSD drives.

 

[MR.KiDO]

uhm... So what you are saying is, I should choose MySQL with proper configurations and that should be give me decent performance?

 

[REAK]

Yes, modify my.cnf make it more suitabe to your table structure that ought to do the trick

 

[MR.KiDO]

Thanks

 

[pi0tr3k]

Indeed, InnoDB is enough if configured well.. I had a nice config before on platinumw.org but I guess it's lost now...

Also,

My forum uses 3 types of storage engines InnoDB (around 94%), MEMORY(3% again) and MyISAM( around 2% again).

94 + 3 + 2 = 99 , where is 1 % ? :P

 

[MR.KiDO]

i said around, you missed to read that