… Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1.69-14.7… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will…, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using … SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database …faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… focused on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup…_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave…_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-11e2-b986-0800272864ba:1-4 We can see that it’s not obvious…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…want two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs should be …a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql….168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192.0.11 And this…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…, it’s still the same in 5.5. Here is the related output from show engine innodb status… rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760… SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…. MySQL 4.1.0 was also available as an early alpha. 2004 was the second year the event was independently organized by MySQL AB… brightest hopes for MySQL to date at the time, and everyone had a “lets change the world” mentality. MySQL 4.1.11 was available as GA at the time on the conference and a lot of hopes were pinned on MySQL 5.0…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-5 Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-4 There are different ways to find…-a3d7-080027635ef5:1-5 Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-5 After the START SLAVE the slave checks that transaction 5 is… an overview of MySQL 5.6 GTID that can help people to start working with this new feature in MySQL 5.6. Here are…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run… supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET…_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details…) Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP…/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total 0.441573…
