… 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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 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: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release… you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking. Client applications can…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
March 23, 2012 By 46 Comments
…) Lock 3) Transaction 1 tries to locks row for UPDATE (goes into queue) It is reasonable not to release Lock 1, but why MySQL tries to create Lock 3? Why can’t it use Lock 1 instead of Lock 3 for…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… download. This is a release candidate for the Percona Server 5.5 series. In addition to MySQL 5.5.10 now being the base version, here are the changes that have been made since Percona Server beta release…) Variable Changes Old status variable innodb_row_lock_numbers was renamed to innodb_current_row_locks. (Yasufumi Kinoshita) Old system variable innodb…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option …_dateblogpercona.commanual Com_release_savepointblogpercona.commanual Com_…lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 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: 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 28 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…
