Percona's MySQL & InnoDB performance and scalability blog
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Fabian, – please note that, as stated in the article, this technique only works well for …
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.
…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…
… 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…
…. 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…
…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…
… 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…
… 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…
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
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.