… very frequent cases with performance problems with MySQL is what they happen every so often or … is really time critical process I would not use more than 4 parallel processes heavily writing to…good idea. It also often helps with monopolizing replication thread. For example if I need to delete …
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… names of the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…” for which this tool was originally built is long over, but still the tool serves well for benchmark purposes. OK, let’s start off with… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALTER large tables with… writing the table with no interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly….1 version of the tool removes those limitations and makes the tool fully featured and much easier to use. The key is that…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for… among other tools used by mysql client, so you might get a feel you can’t connect to the database at all (use mysql -A… in MyISAM tables anyway) you can consider using –no-lock option with Percona Xtrabackup. Many other tools have similar option. This option can…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use…t be connected to any known resource use. For example for global memory leaks you would …memory leak. Dealing with memory leaks is rather complicated as good tools to detect memory leaks…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages…-prm. You can use the CentOS 6 base box I used in the previous post (Testing Percona XtraDB Cluster with Vagrant). In the…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…limitations (e.g. could not be used with parallel file copying, it was required… is now included as well. Support for compiling and running Percona XtraBackup …MySQL Conference and Expo (register now!). Specifically, there are the following sessions at the conference on Percona XtraBackup and tools…
Post: Percona Toolkit 2.0.4 released
March 8, 2012 By Leave a Comment
….4 is available for immediate download. This release fixes 25 bugs and is a bug-fix release only, with the exception of a minor new filtering option for pt-kill. The change log is…, which entitles you to bug fixes and assistance using the tools, among other benefits. With this release we are introducing a new release…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… the other end there are Debian and Ubuntu. Both use tool called dpkg for package management. There isn’t a month that I… do with MySQL, but it would not install anyway. The larger problem – chances are that fixing this with ‘dpkg –configure -a’ would cause MySQL… all MySQL and MySQL-fork vendors – Oracle, MariaDB and Percona. By my observations RedHat and CentOS are also much more frequently used with MySQL, so…
