…your application updates this table with a statement like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players …From other nodes: First to commit wins. The others that try to commit AFTER the first and while the first is still in the local apply queue …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…UPDATE statements for that), so it will produce all good amount of reads. A few words about the hardware: I am going to…($ID/1000, $K) ON DUPLICATE KEY UPDATE k=VALUES(k)+k; COMMIT; So this workload produces …selects by `id`. However it will interesting how both InnoDB and TokuDB performs if PK…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group commit…to get you an idea bout number. How to spot you’re affected This one is interesting. If you have update… or have “commit” queries in the processlist for multiple statement transactions. Looking…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…the contents from scratch. The contents of the result set are updated periodically, not each time the view is accessed. If multiple statements access the…to the exact same consistent point in time, with respect to committed transactions The processing can be done on a slave dedicated to…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
…the slave if you do not need it for anything else. By default MySQL will only write statements which come to the…_slave_updates is enabled which makes slave to write all updates to binary logs – the ones executed directly on the… 1 end_log_pos 846 Xid = 27 COMMIT/*!*/; # at 846 #100411 19:24:45 server…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…the cluster will wait for the data to be actually replicated (committed) before serving the read. The…the UPDATE statement issued to DPE1 is blocked for some time. To check this idea I decided to use the sysbench script with very simple point update queries to…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
…UPDATE are more than hints. Behavior will be different from normal SELECT statements…commited yet. SESSION1: mysql> commit…to be upgraded when update happens. SELECT FOR UPDATE also blocks access to the…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… default settings. I’m surprised how many people fail to provide any reasonable answer to this question, and how many servers are where in… to adjust this value. Default value of 1 will mean each update transaction commit (or each statement outside of transaction) will need to flush log to the…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…the CONNECTED_TIME (because there are two replication threads on the slave) to see how much of the time the slave thread was actively processing statements. If the…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…statement-based replication is not supported by the engine. Another hard decision was not to…to be fixed. How to optimize the program without compromising data integrity is a constant question. Relative to…
