… if your transaction accesses only InnoDB tables, it’s safe. My first thought was, you can’t do that. CREATE TABLE… ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables | 1 | +————————+——-+ The slave is now “vulnerable,” in theory. To test my theory, I’ll…’s see what‘s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any… there with the aim to show folks what they should be watching (at least from my opinion, this is subject to change… all nodes have these values! name The cluster’s name (first 5 characters). This is wsrep_cluster_name. P Either P for Primary…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…communication problem occurs, here is what you will have: percona1 mysql> …select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny |… needed to change it in my.cnf and restart the nodes) wsrep…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…my droppable (unused) indexes from this view: mysql> select * from droppable_indexes; +————–+—————+—————————–+ | table_schema | table_name | index_name | +————–+—————+—————————–+ | sakila | actor | idx_actor_last_name…, what…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…theory, but in practice it is problematic. What usually happens is that the full …16384)) * 100 pct_buffer_pool from ( select table_name, index_name, count(*) pages, sum(is_old=’YES’) old,… 15 rows in set (0.00 sec) Here are my modified versions of the queries (just …
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… about foreign key constraints from the INFORMATION_SCHEMA, but what if our database includes relationships for which we never … test.MY_KEY_COLUMN_USAGE SET CONSTRAINT_SCHEMA = ‘ecommerce’, CONSTRAINT_NAME = ‘fk_lineitems’, TABLE_SCHEMA = ‘ecommerce’, TABLE_NAME = ‘LineItems’, COLUMN_NAME = ‘order_…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…@localhost msb_ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /dev/null Baseline…} (information_schema) > select concat_ws(‘.’, t.schema, t.name, i.name) as index_name, sum(data_size)/1024/1024 as data_size_mb… now going inline with what you would expect. Lets see what is going on with buffer pool contents: INDEX_NAME DATA_SIZE_MB…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… bit closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I… hard to tell what is really happening. Test 3: Phantom rows: Table before test: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql | | 2…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… ID DB_TRX_ID DB_ROLL_PTR FOR_NAME REF_NAME N_COLS INDEX: name FOR_IND, id 0 12, fields 1/2…for forever, so it should be stable, right? So, to my customer. It may be important to note that this …time and asked me to take a look and see what happened. I looked through the data and found not only…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…my Previous Post I…stats are a bit off, so what ? What really matters is not how… | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed…
