… Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics… a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that was…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l… is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use…) where ld.trash = ‘f’ and cai.trash = ‘f’ and (cai.status is NULL) group by ld.label_id, cai.inventory_id…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… said, there are plenty of other MySQL and OS-level status variables that you might want to keep an eye on… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…to prepared statement execution loop, which does not honor wsrep status codes correctly. Bug fixed #1144911 (Seppo Jaakola). State Snapshot …fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup… Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this… previously could find in SHOW INNODB STATUS, there are however few which were not available before. In SHOW INNODB STATUS many values are per… left by Innodb developers so SHOW INNODB STATUS can also be used as debugging tool. Next section you will find in SHOW INNODB STATUS is…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
