…how to make MySQL replication reliable, part of which is to…insert into test.ins select * from test.t *************************** 6. row *************************** Log_name: mysql-bin.000011 Pos: 477 Event_type: Query Server_id…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…mysql> insert into percona values (0,’percona1′,’peter’); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction percona1 mysql> insert…how it needs to…id = 6, members = 2/3 (joined/total), act_id = 19, last…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…last way too long for your 150 GB table! If you have inserted in…in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections. Now let’s get…INSERT…to note is the last line in the output the # MISC part, it tells you how…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…to 43255 in previous statistics). Though it would be interesting to see how it will grow with further inserts, and I also suspect random INSERTS…last point of the post – if you are badly missing some features in MySQL…
Comment: Edge-case behavior of INSERT...ODKU
October 31, 2012 By 6 Comments
…, but when I get time I will. I … all a question of how many rows to insert / update at once. …to the client… but believe me.. it really does work. It also highlights what would be a VERY good feature in MySQL…that last_insert_id should return an array of inserted ids, instead of only the last…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…last…MySQL doesn’t do intra-query parallelization, so ETL jobs written to rely on SQL tend to get really bogged down. In…to bypass the hard-to-scale database server for the initial insertion…to think about how to avoid enormous tables that are hard to…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…get Sphinx to report which matched? The SHOW META command in Sphinx shows how…to add documents to, either individually as you add new data to the MySQL database or else periodically batch-insert data that has changed since last…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
…to be a rant on how RDS can make you feel locked in. Instead, I wanted to…INSERT INTO percona.test VALUES (1); master> INSERT INTO percona.test VALUES (1); replica> show slave status\G … Slave_SQL_Running: No Last…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…to be fixed in new InnoDB flushing mechanism. However Dimitry told me that we may need a bigger innodb logfiles to get…in intensive IO workloads. In MySQL 5.6 it is finally possible to…id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert…
