June 19, 2013

Comment: How to change innodb_log_file_size safely

@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.

Comment: Sphinx search performance optimization: attribute-based filters

Fabian, – please note that, as stated in the article, this technique only works well for …

Comment: Performance Schema overhead

Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering :) Thanks for sharing.

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

a relay master (it can be on the same machine if you use the BLACKHOLE storage enginea simple query. I’d suggest doing this as a user that does NOT have the SUPER privilege; aa few rows into an InnoDB table, but trying to run a

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

… 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

…. 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

…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

… 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

… 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

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