…node we can have all sorts modifications floating around as long as they don’t…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication?…with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100, 1); UPDATE…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… as RLE compression for the other attributes. Don’t use FLOAT with this method (don’t use it at all). We…(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; mysql> insert into search_set values (-2,1),(-3,1),(-10,1),(15,2),(16… set (0.00 sec) mysql> insert into ex2 values (2,1); Query OK, 1 row affected (0.00 sec) mysql> select a.val, b…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… MySQL configuration. MySQL …float NOT NULL, PRIMARY KEY (`transactionid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (transactionid) (PARTITION p0 VALUES…insert rate of ~25k INSERTs Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…: mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c FLOAT) ENGINE=InnoDB; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t(c) VALUES (RAND()); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t(c) SELECT…
