According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Comment: How to change innodb_log_file_size safely
June 13, 2013 By 17 Comments
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Hi Hrvoje, Few quick questions: 1. I have a large innodb database, do I have to export databases from mysql and…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… was missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty LSN… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete… if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF For full disclosure, here are the versions I was…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
