…and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow, 4… tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages…: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20 and… tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages…: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster…=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… my CentOS 6.2, …MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now we can get: ext4 4…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…and RAID10 on 6 disks with BBU, and 32GB RAM on board with CentOS 5…MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL… 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 …
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
…CentOS 6: http://www.percona.com/downloads/TESTING/Galera/Percona-XtraDB-Galera-5.5.15.tar.gz What difference between Percona Server+Galera and MySQL 5.5…And this is true parallel replication, not “per-schema” as in MySQL 5.6. 4…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… was 2* Quad Core Xeon E5310, CentOS 5, Data stored on ramfs. We …MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… it is equal to 15: mysql> select * from `INNODB_SYS_TABLES` where `SCHEMA` = ‘sakila’ AND `NAME` = ‘actor’G *************************** 1. row *************************** SCHEMA: sakila NAME… 11 4. The third time to be sure ibdata1 has valid checksums: #./innochecksum /var/lib/mysql/ibdata1 # 5. Now you can start MySQL and take… production. The tool ibdconnect was tested on MySQL 5.1 on CentOS 5.6 x86_64. However it expected to work on all versions of MySQL/InnoDB.
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_BUFFER… | 0 | 0 | 2 | 6 | unknown | | | | | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 5 | unknown | | | | | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | unknown | | | | | 3… (RedHat/Centos) and full source code also available to download P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… and Scalability solution for MySQL Users and based on Percona Server 5.5….and report us your feedback and experience. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and… overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of …13′;bw=’100′;ff=’4‘;pc=’4889F0…
