… perform typical but challenging MySQL database administration tasks. My focus will be on the following tools: pt-query-digest, to select the queries…-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult to do manually. Years… problem without rebuilding the tables How to gather data for performance problems that happen randomly and last only a few seconds…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
….30 and MySQL 5.6.11 demonstrate notable drops in performance. What can be the reason for that? Below is a… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… if the user’s ad hoc query leads to scanning the entire last two partitions, performance is not bad. (The last 2… about Percona or MariaDB. (Re #4) There are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of… if you find otherwise.) I would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on… in my.cnf or schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can… MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing has been improved. Bug fixed #1080648 (Vlad Lesin). Missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling… returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling… returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
…, the “insert on dup key update” statements do a point query to read the row. If the row exists, then the… is inserted. TokuDB has an optimization in which the point query is avoided and replaced by the injection of an upsert… root of the fractal tree. This can result in dramatic performance increase since the cost of reads is amortized. TokuDB currently…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large data sets and…. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The main performance win of TokuDB is indexes. If you add multiple multi-…). It really shines on large tables and index scan like queries.
