Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…a relay master (it can be on the same machine if you use the BLACKHOLE storage engine…a simple query. I’d suggest doing this as a user that does NOT have the SUPER privilege; a…a few rows into an InnoDB table, but trying to run a…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… sets of queries. Each set is known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general…_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine for…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick …TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF For full disclosure, here…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… will throw a warning instead of a note. In strict mode, it will throw an error and the second ALTER will fail, preventing… will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… straightforward: #For s2 (the new master), we remove its configuration as a slave s1> stop slave; s1> reset slave all; # For s0… hope so, as it is one of the ideas of GTIDs: having for each event across the cluster a monotonically incremental identifier… mysqlbinlog. Let’s say that we want to promote s1 as the new master. We need to know the coordinates of…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
Hi Azigui, Can you please report this as a bug on Launchpad (https://bugs.launchpad.net/percona-xtrabackup/+filebug)? This way it would be easier to track and provide more information. Thank you, Hrvoje
