…cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… happens in B-Tree inserts (see InnoDB vs TokuDB for example). This… to solely on-disk. The insert performance is quite variable, more so…instance performed at various thread counts on the OLTP benchmark. Update Vadim…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
…updated software and hardware configuration, so I would argue MySQL…MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted …latin1 insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); mysql> begin; mysql> update test2 set names=’mysql‘ where id=1; Session 2: mysql> begin; mysql> update …
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
…with INSERT ON DUPLICATE KEY UPDATE) As I went from 1 value to 3 or 10 in the batch performance improved… 12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So with … select_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT is …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…out of sync and have conflicting updates applied to them. With DRBD …degraded performance. In the large databases I run in production relaying on MySQL … – hot vs cold. If you’re using decent hardware and care about performance … is simple example – assume you’re inserting the data at the same …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE… This experiment was not really about InfoBright vs MonetDB comparison. My goal was to …you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for online…or get info about air performance…
Post: How many partitions can you have ?
December 5, 2009 By 18 Comments
… large MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance was…. 1 partition insert took 50 seconds to complete, 10 partitions 52, 100 partitions 72, 1000 partitions 290 seconds. The performance loss with… by this issue. The Update path for MyISAM without indexes took 10 seconds for 1 partition vs 52 seconds for 1000 partitions…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/…size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM … It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to …
Post: Just do the math!
July 6, 2009 By 4 Comments
…the temporary table – the number of rows MySQL can insert/update depends on whenever temporary table can be …very important as it allows to predict how performance will change with data size, cardinality or … reports. Finally let me talk about modeling vs benchmarking for capacity planning. I’m sure …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…article lets comment on IO vs Disk question. If you …bound, while to understand if MySQL goes through more rows …update queries (from replication thread for example). When update is performed first problem is actually reading the data. If you’re updating… – even if you’re doing INSERT you will need to …
