…=”229″] MySQL 5.6 Compatible Percona XtraBackup 2.0.6 was released March 20.[/caption] Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6…. Bug fixed #1121573 (Alexey Bychko). innobackupex would fail when –no-lock and –rsync were used in conjunction. Bug fixed #1123335 (Sergei…
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
….2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs… from working properly, and disabled the –lock-and-rename feature when using it with MySQL versions that don’t support it reliably… MySQL server settings, and more versions of Perl. I’m proud to say that the team has produced the highest quality release…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… on MySQL 5.5, so it will inherit a lot of the great improvements Oracle has made to the MySQL 5.5 release. This should help MariaDB be faster and more scalable, as well as adding a lot of nice features like less lock… MariaDB release is a great development for MySQL users. Users now have more choice than ever — there are three great versions of MySQL…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence … to open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. …The documentation has several other examples.) In future releases we will include more plugins to monitor …
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…environments which focus on minimizing changes. MySQL Version Compatibility – As new major MySQL versions are released they often have some incompatibilities ranging from… lock-in. Performance – We’re very good helping you to get the most performance from your MySQL server via our Percona MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads… as it should be and I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… does not get rid of it completely. In the new releases of MySQL (versions >= 5.5.23) work has been done on… page Release the lock on the page Take the reader-writer shared lock on the latch protecting the AHI again Release the shared lock on the latch protecting the AHI Drop Table in Oracle MySQL…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… you can do SELECT GET_LOCK(”,10) and in in the end of the request SELECT RELEASE_LOCK(”) where session_id is current… previous lock is automatically released. The good thing about it however – you can use it as an extra to your current MySQL Sessions… to release lock – as soon as connection is closed the lock is automatically released. The value 10 in GET_LOCK is timeout in seconds – if lock…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… release we now compile the xtrabackup binary against more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL… each of these releases contain. Using xtrabackup to back up older MySQL or Percona Server releases is still supported. This release introduces the –rsync…-phase pass over the MySQL datadir with rsync (first without a write lock and then with the write lock), we dramatically reduce the…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…ongoing: mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host …lock The final part of this command is the duration during which the lock is held. The lock is released…
