…can see them in information_scheme database in Percona Server though). The structure of these tables is following:…name N_FIELDS: 1 TYPE: 0 SPACE: 15 PAGE_NO: 4 2 rows in set (0.00 sec) In …B7C5C82C; recorded = 0x BFE71C21 fixing new checksum of page 8 page 11 invalid (fails new style checksum) page…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…OLTP workloads. In fact, both Percona Server and MySQL 5.5….letter-spacing:0;word-spacing:0;background-color:#fff;z-index:1;…27611.9701240062712.22463583946230.975364208221441.2755739688873.4 year16.2612.981.3931….14327.5890979766854.83267164230352.24800109863282.1432509422302.8 year32.1485.6122.4472….
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have… 8 disks and ability to disable/enable write-back cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1… trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17 381.03 2 800.89 676.39 748.53 4 1385…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… 6.3, upcoming Percona Server 5.5.30 and 3 allocators – stock glibc 2.13, jemalloc-3.1.0, the latest …notably increase memory footprint. Conclusion: – if your box has 8 cores or less – there is almost no difference …3.0.0 # Set 2 – 5.5.30pre-jemalloc-3.1.0 # Set 3 – 5.5.30pre-jemalloc-3.2.0 # Set 4 – …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…: 833 out of 10000 rounds (8.33%) Delay distribution: Min: 0.66 ms; Max: 353.61…if it were single server from generic application. Right. Default configuration for Percona XtraDB Cluster …1 Delay: 0.71 ms Result Mismatch for Value 465; Retries: 1 Delay: 0.76 ms … Summary: 452 out of 10000 rounds (4…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…larger ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger…5GB of data, so ICE gets over 16:1 compression ratio(compared to Innodb, 8:1 compared to raw input data), which is…Q2,Q3,Q4,Q5,Q6,Q7,Q8.0,Q8.1,Q8.2,Q8.3,Q8.4,Q9,Q10,Q11 34.354,60.978…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… also inefficient. Percona Server as of versions 5.1.56 …3 min 4.87 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | …8); Query OK, 4194304 rows affected (1 min 13.69 sec) Records: 4194304 Duplicates: 0 Warnings: 0…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be also available on percona… servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` ( `ol_o_id` int(11) NOT NULL, `ol_d_id` tinyint(4…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
… UCS C250 server. The workload is read-only and fully in memory. There is the result for different threads (against Percona Server 5.5.17): Threads Throughput, q/s 1 11178.34 2 27741.06 4 53364.52 8 92546.73 16… the semaphore: Mutex at 0x2b0ccc8 ‘&kernel_mutex’, lock var 1 waiters flag 0 –Thread 140370752542464 has waited at trx0trx.c line 1772…
