May 26, 2012

Post: Maximal write througput in MySQL

… amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions… BBU as storage for innodb log files, innodb system table space and binary logs. And I used Percon-XtraDB-5.1.43-9….02 tps, which drops to 23115.04 tps as we switch to innodb_flush_log_at_trx_commit = 1. As we use…

Comment: Announcement of Percona XtraDB Cluster (alpha release)

… opinion, which may be not full Percona XtraDB Cluster ● It is based on widely used XtraDB/InnoDB engine. ● It is almost drop-in… changes ● Less additional knowledge for DBA is required to run XtraDB Cluster than NDB Cluster. MySQL NDB Cluster is totally different… ○ expensive to deploy and maintain Percona XtraDB Cluster has: ○ Minimal entry barrier for one who switches from MySQL Replication or for new…

Post: InnoDB/XtraDB Training in New York City!

…, NY 10004), and it seems like a great opportunity to switch from using hotels to teaching in real classrooms.  This…

Post: Paul McCullagh answers your questions about PBXT

… tasks, much like InnoDB.  However, PBXT’s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database… table data. Both sizes can be set using compile time switches. However, if the index page size is changed, then the…

Comment: Should you move from MyISAM to Innodb ?

… ? Typically there are following conditions 1) Server Down. Switch to the slave or DRBD/SAN based standby …of downtime and get .ibd files movable for XtraDB :) In any case there is general sense an… we would have recommended you to stay with Innodb reviewing your application. Just recognize it is not …

Comment: XtraDB storage engine release 1.0.3-5

Percona rocks! I am thrilled that you switched to the Google rw-lock patch because that is in the InnoDB plugin and you can add value elsewhere. Is XtraDB derived from the InnoDB plugin?