…transactions mixing transactional and non-transactional…mysql-bin.000001′ at 2793, the last event read from ‘./mysql-bin.000001′ at 2793, the last byte read from ‘./mysql…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…transactions here. This shows us something interesting that isn’t considered in the “all inside one transaction” argument: transactions…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… For incrementally refreshable views, the last parameter is a transaction id number, which is usually obtained…transaction id to which you have computed them. And then confirm they contain the same results mysql…of views together. The complete method examples show how to create a complete refresh view…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…of all cases) commits a transaction, the DML statements from that transaction are written to the binary log… calculated form the timestamp included in the last executed sql statement. As some of them are…the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… transactions or writesets. Up is outbound, i.e., where this node was the originator of the transaction. Dn is download, that is, transactions from other nodes in the cluster. Bytes Just like Ops, but in Bytes instead of transaction…_paused — This is the amount of time since the last time SHOW GLOBAL STATUS was run that replication was paused due to…
Post: Differences between READ-COMMITTED and REPEATABLE-READ transaction isolation levels
August 28, 2012 By 3 Comments
…), undo log entries 1 MySQL thread id 4, OS thread handle 0x7f8dfc35d700, query id 62 localhost root show engine innodb status You… for the transaction lasts only as long as each statement execution. As a result, consecutive executions of the same statement may show different… internals day covers MVCC and locking in detail The SET TRANSACTION ISOLATION LEVEL MySQL manual page
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… application for data mining stock market transactions,” or whatever the case may be … to get this information, too. The last three commands are for giving me …_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… instance, and I tried to show the minimal installation required for XtraDB…response time limits the number of transactions / second that you can do on… replication, galera and built-in mysql replication are independent from each other… groups of clients. So, the last gcomm:// option should be avoided….
Post: Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
November 20, 2012 By 17 Comments
… local transaction triggering the failure on commit, this is triggered by Galera replication threads applying replicated transactions. To be clearer: a transaction was… post where I wanted to show that these counters were being incremented using an example from my last post. Those examples should…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…each run, I will show different graphs: benchmark throughput – This is New Order Transactions per 10 seconds. dirty page…this value as Log sequence number – Last checkpoint at from SHOW ENGINE INNODB STATUS. Here are the …with the stable line in MySQL 5.5.8. But, finally, let me show the result IÂ got…
