… pages and the rate of transaction log growth.
innodb_adaptive_flushing_method: (Percona Server only) This adds a few new different algorithms, but the more … server.
In any case, if you run any kind of production MySQL server, you should be monitoring your Checkpoint age and your Innodb dirty …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 4 Comments
Post: Announcing MySQL Monitoring Plugins from Percona
February 17, 2012 By 18 Comments
We’ve released a new set of monitoring plugins for MySQL servers and related software. With these plugins, you can set up world-class … included in our support contracts. If you’re an existing customer of Percona‘s MySQL Support services, your contract automatically covers these new plugins, too; …
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 1 Comment
…- Extract all the InnoDB pages from the tablespace:
First we need to download Percona Data Recovery Tool and compile all the tools using the “make” … here I’m going to explain three of them:
A) INNODB_SYS_INDEXES
Percona Server has some extra tables in INFORMATION_SCHEMA that can help us to …
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 20 Comments
2 alex.
Indeed, I never published benchmarks Percona Server vs MySQL 5.5, like this
http://www.mysqlperformanceblog.com/2012/01/17/benchmarks-of-new-innodb_flush_neighbor_pages/
from which you can’t get conclusion that Percona Server performs better than MySQL 5.5.
Comment: Announcing Percona Server 5.1.61-13.2
February 20, 2012 By 3 Comments
The Percona Server 5.1.61-13.2 after the installation does not generate a config file /etc/mysql/my.cnf
Comment: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 4 Comments
Please could you explain exactly what the difference between modifed age and checkpoint age is on the Percona server output?
Comment: Index lock and adaptive search - next two biggest InnoDB problems
February 19, 2012 By 12 Comments
his is bad, all Select queries are waiting for the lock, and there was only one update uses secondary key and one insert query.
./Percona-Server-5.5.16-rel22.0/storage/innobase/btr/btr0cur.c
===================================================
545 if (latch_…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 20 Comments
….4 runs ontop XtraDB 1.0.17-13.0 which in turn is based on InnoDB 1.0.17 from MySQL 5.1. So indeed MySQL 5.1 or Percona Server 5.1.59-13.0 would be proper targets for a comparison with MariaDB 5.3.4.
As pointed out by Peter, sysbench runs simple queries only where…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 20 Comments
How do we know that it is not a regression in XtraDB? Too bad the latest Percona Server is not included in the benchmark.
