…: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s… storing another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which… roll-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that), so it will… UPDATE k=VALUES(k)+k; INSERT INTO sbtest_r100 (id, k) VALUES ($ID/100, $K) ON DUPLICATE KEY UPDATE k=VALUES(k)+k; INSERT…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…of ANALYZE TABLE for MyISAM vs Innodb. I used the following…but uses Innodb format: mysql> insert into antest_innodb select * from antest… just did couple of updates to refresh update time. mysql> show index from antest; …
Post: Just do the math!
July 6, 2009 By 4 Comments
… typical one – scan the table, when for each row insert (or update) row in the temporary heap table. After temporary table is… is the temporary table – the number of rows MySQL can insert/update depends on whenever temporary table can be kept in memory… acceptable for interactive reports. Finally let me talk about modeling vs benchmarking for capacity planning. I’m sure you need both…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…-to-disk threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean that we… that it would really benefit them. Finally, a single-threaded insert workload is not very revealing. To understand the sustained write… instance performed at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed out that I shouldn…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…also you can review binary logs to see which updates were applied to different nodes. Transaction log replay, yes…. This actually goes to two topics. First – hot vs cold. If you’re using decent hardware and … load. Here is simple example – assume you’re inserting the data at the same time as running …
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
… got data inserted to them per insert statement. As I tested the UPDATE path on INSERT OF DUPLICATE KEY UPDATE (adding ON DUPLICATE KEY UPDATE set c=c+1 to my bulk inserts) the regression… by this issue. The Update path for MyISAM without indexes took 10 seconds for 1 partition vs 52 seconds for 1000 partitions…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…=solidDB DEFAULT CHARSET=latin1 insert into test2 values (1,’Mysql’),(2,’Solid’),(3,’MyISAM’); mysql> begin; mysql> update test2 set names=’mysql… repeatable-reads): Session1: mysql> begin; Sessino2: mysql> begin; Session1: mysql> insert into test2 values (4,’FEDERATED’); Session2: select * from test2; +—-+——–+ | id…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem with INSERT ON DUPLICATE KEY UPDATE) As I… completed in 12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So with single statement… is INSERT, and it does not use this function so it did not have a bug. INSERT ON DUPLICATE KEY UPDATE, REPLACE, UPDATE all…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… different modes on successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based, correct? A… that to look forward to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split… slave lag more accurately is to use pt-heartbeat, which inserts the system timestamp into a dummy table once per second…
