… 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: Upgrading MySQL
January 5, 2010 By 23 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: Copying InnoDB tables between servers
July 31, 2009 By 10 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 | +———-+ …
