…gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, … Doesn’t the primary key solution for random selection only work when the IDs for movies … choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward… s4 are also lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 is behind s1> select count(*) from t; +———-+ | count(*) | +———-+ | 0…; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision … the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June… (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE… on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal… profiling, and session status to measure performance. The query patterns will include: Exclusion Join Random Selection Greatest-Per-Group Dynamic Pivot Relational…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the …the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates… have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona… fixed #1158443 (Raghavendra D Prabhu). In case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, in some cases first statement could be left hanging…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will be on the following tools: pt-query-digest, to select the… MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators perform…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL …technical content selected by an independent committee. The conference is refocused back on MySQL and the needs of the MySQL community covering …
