Re: What MySQL-flavor to choose.

2011-02-14 Thread Antonis Kopsaftis
According to http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas-tpcclike-workload-on-mysql-55.html the xtraDB is ignoring the io capacity setting. But this of course it might be just a minor bug in the percona version that dimitriK used in his test..:-) akops On 1

Re: What MySQL-flavor to choose.

2011-02-14 Thread Ewen Fortune
Hi, > Also after reading Dimitrik blog > (http://dimitrik.free.fr/blog/archives/2010/07/mysql-performance-innodb-io-capacity-flushing.html), > its seems to me , than one of the thing that are different between the > stock mysql (5.5) and xtradb, is the way that they handle IO capacity > and flush.

Re: What MySQL-flavor to choose.

2011-02-14 Thread Antonis Kopsaftis
According to the benchmarks on the Personal website, the 5.1 version of Persona has the same about performance as mysql 5.5 (http://www.percona.com/software/benchmarks/) Also the 5.5 version of the Persona(not reported as stable) is even better than mysql 5.5 according the the same site. Also aft

Re: What MySQL-flavor to choose.

2011-02-14 Thread Jay Ess
On 2011-02-14 15:43, Singer X.J. Wang wrote: So I'm assuming OLTP type transaction, then I'm going to recommend MySQL 5.5. Why is that flavor to be chosen over MariaDB with XtraDB or Percona with XtraDB? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Re: What MySQL-flavor to choose.

2011-02-14 Thread Jay Ess
On 2011-02-14 15:31, Singer X.J. Wang wrote: What is your load type? Heavy read but enough write not to benefit much from query cache. It is a webshop app (custom). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?u