… typical but challenging MySQL database administration tasks. My focus will be on the following tools: pt-query-digest, to select the queries…, have proven the reliability of the Percona Toolkit tools for MySQL. In this presentation, you will learn how you can use some… these tools to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… GA release in the MySQL 4.0 series, and for the first and only time in a MySQL version you could buy MySQL in a box… MySQL 5.6.2 is nonGA. 2012 marks the first year the annual conference is organized by Percona, with technical content selected by an independent committee. The conference is refocused back on MySQL and the needs of the MySQL community covering other…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… stay attuned to the new companies, products and other developments in the MySQL ecosystem – both to drive Percona’s direction as well…. If you’re shopping for MySQL technology and services, then you’ll see the largest selection of MySQL Ecosystem vendors at the show. If you’re doing business associated with MySQL, you’ll have…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… two cases covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside… the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL… read-only optimization in MySQL 5.6 does not kick in. The default sysbench POINT_SELECT mode benchmark does PK lookup SELECT queries wrapped into…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; +————–+—–+——–+——+——–+———+————–+——-+ | NAME | ID | N…=latin1 Fields names explain their content. Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE INDEX_ID = 1679; +———-+—–+———-+ | INDEX…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… requested block(s) there. That optimization helps to avoid fragmentation in case of many small allocations and allows to free all… approach is quite inefficient and in some cases can be the reason for notable MySQL performance drop. Now in Percona Server, for each… have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… the Percona Live MySQL Conference and Expo are wondering why we submitted so many. I had 3 official talks selected, including one… right in here. http://www.percona.com/live/mysql-conference-2013/sessions/migrating-percona-xtradb-cluster The Hazards of Multi-writing in a… PXC experts like myself and the Codership folks should be in attendance. I can’t speak for any representatives from the…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…’m seeing that variable in 5.5.25a. Or does the functionality behind it just not work? mysql> select version()\G *************************** 1. row *************************** version(): 5.5.25a-27.1-log 1 row in set (0.00 sec) mysql> show…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…some roll-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE …` is low selectivity is not good for fast inserts, but it is suitable for range selects by `id…_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
