… a look at MySQL 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… KEY state_id (state_id) ) ENGINE=MyISAM; 4) Dictionary table for cities_join: … VARCHAR show close performance, while join performance degraded dramatically. Here is why: mysql> explain select…1) Results for ENUM: select SQL_NO_CACHE city, state from cities_enum limit 10000, 5; Result time(mean): 0…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) …of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-…query for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm-up…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1…performance gain. This is not entirely visible in the manual either for MariaDB or MySQL…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…4,4 | NULL | 1032 | Using intersect(i1,i2); Using where | +—-+————-+———+————-+—————+——-+———+——+——+————————————-+ 1 row in set (0.00 sec) As you can see in this case MySQL… about 5 …performance but it is far from performance…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… at 4.1.14 because of all the bad things I’ve heard about loss 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 of performance differences and…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…MySQL. While my far goal is the performance…1 | Mysql | | 2 | Solid | | 3 | MyISAM | | 4 | HEAP | begin; Query OK, 0 rows affected (0.00 sec) Session2: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…performance_log_081221 where page_type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…log_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is event…5.1 to date. So this is the access pattern which is often going to define your MySQL on DRBD Performance…network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0…_pool, innodb_buffer_pool_instances=1 is more preferable. The … there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously …_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = …
