…InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) …… Quad Core Intel XEON cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU …of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…mysql [localhost] {msandbox} (test) > update idxtest set i2=i1; Query OK, 10900996 rows affected (6…intersect(i2,i1); Using where | +—-+————-+———+————-+—————-+——-+———+——+——+————————————-+ 1 row in set (0.00 sec) Hm… in MySQL 5…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 15 Comments
…of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed …5 and i!=5 The query time dropped to about 6 seconds which is 3.5…mysql> explain (select * from test.abc where i=5) union all (select * from test.abc where j=5 and i!=5) \G *************************** 1. row *************************** id: 1…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… logging (with long_query_time = 0) for some time during peak …recommendation on when to use ENUM vs. CHAR? Especially for one character …and they will only need 1 byte per value. If you …5.5, and most should still be valid with 5.6. Q: I have good command of SQL query writing and wanted to learn MySQL…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
…a way. Same site publishes Core vs K8 architecture comparison which is very …3 Ghz beats Irwindale at 3.6 Ghz up to 3 times , which…1.5-1.7 times worse than PIII. Ie I remember being very surprised to find P4-2.0… interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… for TPCC load, so why don’t we take tpcc-mysql bencmark and check on results. I took 3 different datasets… row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users. Also… support STATEMENT based replication in 5.1), and everything was run under XtraDB-9 ( based on InnoDB-plugin 1.0.6) So there are results…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…vs…mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_TIME: 0 BYTES_RECEIVED: 0…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…Xeon(TM) CPU 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (revision)=IB_3… in InfoBright. MySQL is really stupid here, and EXPLAIN for this query took 6 min! If…6.3s and InfoBright: 0.31s To group all results there is graph: Conclusions: This experiment was not really about InfoBright vs…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring…2.0.5+, the time taken for “FLUSH TABLES WITH RAED LOCK” is normally under 1 second….possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1.14 because of… of performance with 5.0.X. I’m hopeful that 5.1.X will be better, but still not sure. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot…
