…to using temporary tables in this way, for example when using replication, a temporary table could vanish if the slave… sequence after making certain insert/update/delete operations. If you …to count the movies per production year for each kind_id. It was more efficient in this case to force MySQL to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…where the client is forced to correct the problem before …to modify the same record at once. But what will actually happen to the clients who try to update…MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave position to…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
…to fetch updates…to learn more about this, then I encourage you to read the relevant section of the MySQL…slave, it is possible that the transaction may not have reached any slave. Finally, I would be interested to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…growing data size forces it to. This goes back to what data you really need to make your business… to update the aggregates, you’re exposed to that bad data again. Any inconsistencies in the atomic data tend to… MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to…to be desired: Over 17 MS to do an update. Wouldn’t be great to just eliminate all the updates…
Post: Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
November 20, 2012 By 17 Comments
… synchronous replication” means: Writesets (or “transactions”) are replicated to all available nodes in the cluster on commit… force abort is only triggered by a locking conflict between a writeset being applied by a slave …like a bug and is investigating. I’ll update this post if and when an actual …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…command line option innodb_changed_pages_limit. MySQL option handling would then shadow the …slave server while there are updates on the replicated table on the master which is used in that trigger. For this to… page tracking wasn’t compatible with innodb_force_recovery=6. When starting the server …
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… pro, since using master-slave switching I’ve always been able to emulate online index adds. … small updates to one piece of data in a very large blob, the effort MySQL has to go to is greatly increased. The second downside I would mention is that this pattern tends to force you to…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…MySQL version 5.1.67-14.4[/caption] Percona is glad to announce the release of Percona Server for MySQL…slave. Bug fixed #1042946 (Sergei Glushchenko). The master thread was doing dirty buffer pool flush list reads to…an INSERT or UPDATE statement containing …compatible with innodb_force_recovery=6….
