I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some …
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
Rob, That seems a little on high level. The feedback I am getting from our customers is that with some negotiations you should be able to drive price down for ~20%
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
… somenting , but i will, i have one question about select sorted results from a big mysql tabble, myISAM, with about 2…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
…, FileTbl.userid, FileTbl.folder_desc, LinksTbl2.description, LinksTbl2.userid, FileTbl.customize_access, FileTbl.fromdate, FileTbl.todate,LinksTbl2.main_version_id,LinksTbl2…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… the fixes in your kernel, and many of Percona’s customers are in the same situation. That’s why we don…
Comment: ext4 vs xfs on SSD
April 25, 2012 By 23 Comments
… most important factors. We are in consulting business also, and customers are most interested in recommendation that they can use today…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… Key-ordered scan, the secondary key on col1 would be sorted by col1 i.e. in index order and then the…_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ optimizer_switch=’mrr_cost_based=off’ optimizer_switch… * (1 – l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem FORCE INDEX (i_l_orderkey) where c_mktsegment…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ (only on MariaDB 5.5) optimizer_switch=’mrr…_acctbal, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_custkey = o_custkey and l… where; Rowid-ordered scan; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY,i_c_nationkey PRIMARY 4 dbt3.orders…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
… is known. With commercial software and fat, annual license agreements, customers can try to pressure companies to move one patch ahead…
