… lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer_size… MariaDB 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… is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to … | 5.5.30 | 1.2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5…_AUTH | OFF | ON | | VERSION | 5.5.30 | 5.6.10 | | INNODB_CONCURRENCY_TICKETS | 500 | 5000 | | INNODB_PURGE_THREADS | 0 | 1 | | INNODB_OPEN_FILES | 300 | 2000…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…. 1) Results for ENUM: select SQL_NO_CACHE city from cities_enum WHERE state=’Minnesota’ limit 10000,5; Result time(mean): 0.082196…. 1) Results for ENUM: select SQL_NO_CACHE city from cities_enum ORDER BY state limit 10000, 5; Result time(mean): 0.077549… longer. 1) Results for ENUM: select SQL_NO_CACHE city, state from cities_enum limit 10000, 5; Result time(mean): 0.003125 2…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…’ + interval ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id… 5.1 and 6.0 in cold mode (I dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… isolation mode which is REPEATABLE-READ for this test. Test 1: Solid, deadlock detection, default (OPTIMISTIC) concurrency control. CREATE TABLE `test2… set names=’mysql’ where id = 1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 Session2: mysql> begin; Query OK… versions. Test 5: UPDATE / SELECT FOR UPDATE in OPTIMISTIC mode Solid optimistic: Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory”. The cut-off time for this test was 1… 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… with PHP 5.1.6 or 5.2.2, and also with PHP 4.4.2 on SPARC64 under NetBSD 3.0: s1=1125899906842625… different results: s1=1.1258999068426E+15 s2=1125899906842625 The same 32-bit FreeBSD box with PHP 5.2.5 starts to emit all… numeric value handling: it can be used to workaround signed vs. unsigned int issues; it helps with float formatting; always a…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
October 1, 2009 By 30 Comments
Why you don’t put the version used of each software? that’s is very important!! there are differences between infobright 3.1.1 and 3.2 (ICE vs IEE), MySQL 4.1 vs 5.0 vs 5.1, for example.
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… bound. That said, benchmark was running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir… slightly lower, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important metric for… in_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of operations…
