June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete… Ubuntu 13.04. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would… if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

June 3, 2013 By 3 Comments

… using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very rare circumstances, deleting… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

…. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain… a comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…

Filed Under: MySQL Tagged With: , , , ,

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… of the child table when appending exclusive key for cascading delete operation. Bug fixed #1089490 (Seppo Jaakola). Parallel applying would fail… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…

Filed Under: MySQL, XtraDB Cluster Tagged With: , ,

Post: Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

…-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1 & Our…-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will need Percona Server in order to use innodb_fake_changes…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software Tagged With: , , , , , , ,

Post: Finally. How to verify if all MySQL records were recovered

April 25, 2013 By Leave a Comment

…. There are two ways to know how many records an InnoDB page stores. The index page has a header PAGE_N… records the page stores. Obviously it doesn’t count any deleted records. The second method to confirm how many records are… – and count them. As you might know, records inside an InnoDB page are organized in an unidirectional list. The list is…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… two, delete some data, and see what happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize…) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: A quest for the full InnoDB status

October 31, 2008 By 4 Comments

… have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status… possibility is to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full… InnoDB status is. You can also help yourself with lsof tool available for many platforms: garfield fd # lsof -c mysqld | grep deleted…

Filed Under: Insight for DBAs Tagged With: ,

Post: How to recover deleted rows from an InnoDB Tablespace

February 20, 2012 By 4 Comments

…) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i INNER JOIN INNODB_SYS_TABLES as t USING(TABLE_ID… the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1… recovered! 10008 has recovered his salary again :) Conclusion With InnoDB the deleted rows are not lost. You can recover them from the…

Filed Under: Insight for DBAs, MySQL

Post: Recovery deleted ibdata1

August 10, 2012 By 9 Comments

… case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the… the deletion. By the way, this is a good reason to monitor existence of these files! But after the restart InnoDB will…, so it will create empty ones. The InnoDB dictionary will be empty and InnoDB won’t be able to use a bunch…

Filed Under: Insight for DBAs, MySQL Tagged With:
« Older Posts