… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return… Ubuntu 13.04. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…” align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the …INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… isn’t really deleted. The MySQL server keeps an open filehandle to the file, and it won’t be deleted until the server… your data permanently. The pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain open via a filehandle… transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
…however a better metric, which in most cases will indicate the problem waiting to happen, this is when … which have some locks, like in this case: MySQL thread id 2059, query id 1014425 10.10….transactions are holding some locks and perform some update/deletes as there are undo log entries. This is …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add in child table, in… thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id… high values for any of these variables is indication of IO bound workload. Note however – IO …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is … which record versions are no longer needed and deletes them from the database. The Checkpointer flushes the … if the index page size is changed, then the indices need to be rebuilt, which can be done…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… tour database. This is where Trending can help, for example MySQL CACTI Templates will have the graphs you need. If you… this is a very good indicator. If you’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg… rows. In many cases doing such processes in chunks, updating/deleting may be thousands of rows per transaction may be better…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
October 20, 2007 By 51 Comments
… give is: DELETE FROM USERS WHERE NAME LIKE “%Heikki%”; First of all, mysql will not be able to use indices so indeed all… the following schedule: BEGIN BEGIN [nothing happens here] INSERT “fooHeikkibar” DELETE WHERE NAME LIKE “%Heikki%”; [nothing happens here] INSERT “barHeikkifoo” END…
Comment: Finding out largest tables on MySQL Server
April 24, 2012 By 27 Comments
… is deleted. However, what I’m wondering is if there is a large discrepancy in the sizes, is this an indicator that…/lib/mysql/databasename # ls -lh tablename* -rw-rw—- 1 mysql mysql 8.7K 2010-08-05 16:31 tablename.frm -rw-rw—- 1 mysql mysql…
