…MySQL Optimizer Bug 
But now lets see in the difference of behavior of ANALYZE TABLE for MyISAM vs…mysql> insert into antest_innodb select * from antest; Query OK, 245760 rows affected (54.29 sec) Records: 245760 Duplicates: 0 Warnings: 0 mysql… updates to refresh update time. mysql> show index from…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…MySQL Replication you can use Maatkit to merge the changes after all, also you can review binary logs to see which updates… This actually goes to two topics. First – hot vs cold. If you’re using decent hardware …load. Here is simple example – assume you’re inserting the data at the same time as …
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…threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean…at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed out …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…mysql> begin; Sessino2: mysql> begin; Session1: mysql> insert into test2 values (4,’FEDERATED’); Session2: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql…
Post: Just do the math!
July 6, 2009 By 4 Comments
… MySQL may execute query above but lest focus on the most typical one – scan the table, when for each row insert (or update… aspect 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: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… not just for new connections as in MySQL. This is very helpful for measurement …number of tmp tables created in memory vs on-disk, percentage of queries that needed… 89 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 1… 260 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137 10…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… difference in CPU frequency alone (2600Mhz vs 2800Mhz) and it well may be…JOPS on updated software and hardware configuration, so I would argue MySQL is Slower….MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
July 22, 2011 By 117 Comments
… Search Yes Require Transactions Yes frequent select queries Yes frequent insert,update,delete Yes Row Locking (multi processing on single table) Yes… either innodb or MyISAM. http://developer99.blogspot.com/2011/07/mysql-innodb-vs-myisam.html
Post: How many partitions can you have ?
December 5, 2009 By 18 Comments
… with large MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The… 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… by this issue. The Update path for MyISAM without indexes took 10 seconds for 1 partition vs 52 seconds for 1000 partitions…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
…12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So …select_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT …INSERT, and it does not use this function so it did not have a bug. INSERT ON DUPLICATE KEY UPDATE, REPLACE, UPDATE…
