… product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20. With…=’6a6a6a’;nc=’6a6a6a’;bc=’6a6a6a’;l=’y';fs=’16′;fsb=’13‘;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20…=’6a6a6a’;nc=’6a6a6a’;bc=’6a6a6a’;l=’y';fs=’16′;fsb=’13‘;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… we can get with Percona Server. This is also to address the results presented there Benchmarking MariaDB-5.3.4 The initial benchmark is…_size = 4G Versions: MySQL 5.5.20, Percona Server 5.5.19 With these settings we have following results: As you see with Percona Server we have stable and…=’6a6a6a’;nc=’6a6a6a’;bc=’6a6a6a’;l=’y';fs=’16′;fsb=’13‘;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous…conclusion ext4 looks like an good option, providing 20% better throughput. I am still going to …’;bc=’6a6a6a’;l=’y';fs=’16′;fsb=’13‘;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… release of Percona Server 5.5.13-20.4 on July 1st, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the current stable release in the 5.5 series. All of Percona’s software…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… plethora of useful information reported by Percona Server. Another great thing about Percona Server is the ability to enable logging …13 2.00k 182.86 346.17 154.34 84.10 # InnoDB: # IO r bytes 96.00k 0 32.00k 20… SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film #…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… this test. I have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with former being configured … mysqld btr_cur_search_to_nth_level 792651 13.8063 mysqld btr_search_guess_on_hash 716506 …_conn ection,handle_one_connection,start_thread,clone 4 pthread_cond_wait,os_cond_wait,os_event…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… in information_scheme database in Percona Server though). The structure of these …NAME` varchar(255) NOT NULL default ”, `ID` bigint(20) unsigned NOT NULL default ’0′, `N…13 ID: 16 NAME: idx_actor_last_name N_FIELDS: 1 TYPE: 0 SPACE: 15 PAGE_NO: 4… was tested on MySQL 5.1 on CentOS 5.6 x86_64….
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume …servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` ( `ol_o_id` int(11) NOT NULL, `ol_d_id` tinyint(4… 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 …
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… In fact, both Percona Server and MySQL 5.5.7rc have …4 year16.2612.981.3931.42716.2609069347382.97982621192931.3929548263551.4265050888062.5…7256820201878.18443679809573.48648905754093.4639980792999.13 year53.8478.9293….461112022413.3040139675145.45926189422615.4474551677704.20 year86.62514.2985….
