… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as…) NOT NULL, `l_quantity` decimal(15,2) NOT NULL, `l_extendedprice` decimal(15,2) NOT NULL, `l_discount` decimal(15,2) NOT NULL, `l_tax` decimal(15,2) NOT NULL, `l_returnflag…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default…OrderPriority varchar(15), LO_ShipPriority char(1), LO_Quantity tinyint, LO_ExtendedPrice decimal, LO_OrdTotalPrice decimal, LO_Discount decimal, LO_Revenue decimal, LO_SupplyCost decimal, LO…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…is 15 minutes job for others it is many month projects. Why is that ? Performing MySQL upgrade two… type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage…representative enough you should set it up on 2 same boxes and use mk-upgrade tool to…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… first take a look at the configuration used with different MySQL flavors. MySQL 5.5.24 Configuration innodb_file_per_table=1…_nationkey` int(11) DEFAULT NULL, `s_phone` char(15) DEFAULT NULL, `s_acctbal` decimal(10,2) DEFAULT NULL, `s_comment` varchar(101) DEFAULT…, `o_totalprice` decimal(10,2) DEFAULT NULL, `o_orderDATE` date DEFAULT NULL, `o_orderpriority` char(15) DEFAULT NULL, `o_clerk` char(15) DEFAULT NULL…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…ol_quantity` tinyint(4) default NULL, `ol_amount` decimal(6,2) default NULL, `ol_dist_info` char(24) default… in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 … 99 100 done. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ …
