… amazing MySQL manual, especially the option and …commanual Com_replaceblogpercona.commanual Com_replace_selectblogpercona.commanual Com_resetblogpercona.commanual…isolationblogpercona.commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… dirty change and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps… rest of the scripts and results) and here are the updated 5.6.2 results. The difference against baseline 5.6…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance…one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but…at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed out that…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname….55.55.55. The first thing to do is to update all the /etc/hosts files so that they look like…
Post: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 18, 2007 By 15 Comments
Jonathan Haddad writes about REPLACE INTO and INSERT ON DUPLICATE KEY UPDATE. Really, Why MySQL has both of these, especially both are non… be the following – REPLACE INTO existed forever, at least since MySQL 3.22 and was a way to do replace faster and what… problem with REPLACE was – many people tried to use it like update accessing previous column value, for example doing something like REPLACE INTO…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… a way to improve update performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw…->isolation_level select_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT is the first… it did not have a bug. INSERT ON DUPLICATE KEY UPDATE, REPLACE, UPDATE all should be affected, though I have not tested this…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… an integer based primary key B.)Â Update data from that row and replace the stored contents on disk C.)Â Use… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… based on an integer based primary key B.) Update data from that row and replace the stored contents on disk C.) Use…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… new partner. In order to achieve this, a search and replace operation in the local ha.cf file followed of restart… -d’|’ -f2` ssh -i /usr/local/bin/update_mysql ubuntu@$IP sudo ./updated_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE The full script... -d'|' -f2` ssh -i /usr/local/bin/update_mysql ubuntu@$IP sudo ./updated_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE /etc/init.d…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… you have transaction containing millions of simple updates instead of one large update to help MySQL replication lag it is not going to… scan in MySQL 5.0 (even if there are no spam posts) which will load slave significantly. You can replace it with: SELECT id FROM posts WHERE body LIKE “%cheap rolex%”; UPDATE posts SET spam=1 WHERE…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… GLOBAL server_id =…” You promote a slave as master to replace one of the masters but the replication was still catching up… so some events from the replaced master still had to be executed on the slaves. And…://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc…
