… if writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason… tests to see how well it performs 
One more thing to keep into account – INSERT … SELECT actually performs read in locking mode and so… id 6994931 localhost root Sending data insert into test select * from sample ——– As you can see INSERT… SELECT has a lot of lock structs…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…can build the functionality you need and get the performance you need. Because I’ve built two such … cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-…Â If you do it on the master with INSERT..SELECT queries, it will propagate to the slaves and …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…. MyISAM uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts but… can happen concurrently to select statements but it has to be one insert at the time. Happily inserts in MyISAM are rather fast so… you export data from OLTP system for example to perform data analyses – MyISAM will be great fit. Even if you get the…
Post: MyISAM mmap feature (5.1)
May 26, 2006 By 10 Comments
…=1 startup option. In this case instead of systems call MyISAM will use memcpy function. There is a memory addressing limit… SELECT/UPDATE/INSERT inside file queries, and no performance gain (maybe a bit slower) for INSERT at the end of file. In case with INSERT… different cases. The value of performance gain depends of count replaced pread/pwrite calls. For select-primary we replace only one pread…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
…INSERT ON DUPLICATE KEY UPDATE) As I went from 1 value to 3 or 10 in the batch performance…single row statements. So with single statement MyISAM was about 10% faster, which is …select_lock_type != LOCK_NONE && trx->mysql_thd != NULL && thd_is_select(trx->mysql_thd)) { /* It is a plain locking SELECT…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced … ran three queries: select sum(c19), sum(c89), sum(c129) from t; select sum(c19), sum(…Graphs of query performance time for all three databases are really not very helpful, because MyISAM is so…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
…-space (Solaris) or kernel-space (Linux). Some results for MyISAM table, query SELECT id FROM sbtest WHERE id BETWEEN N AND N… using range-queries and doing INSERT not often than disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the reason…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following…46 (the query Q0 is: select avg(c1) from (select year,month,count(*) as c1 from…you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for…compare or get info about air performance…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
… needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and… partitioning can impact performance of your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts you would…
