\u4ee5\u4e0a\u3067TPC-H\u3092\u5143\u306b\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\u305f\u3060\u3001\u500b\u4eba\u7684\u306b\u306fqph\u3088\u308a\u3082\u5404\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u6642\u9593\u304c\u77e5\u308a\u305f\u3044\u306e\u3067\u3001general_log\u3092\u51fa\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n
\n
\/usr\/sbin\/mysqld, Version: 5.6.16-log (MySQL Community Server (GPL)). started with:<\/p>\n
Tcp port: 3306\u00a0 Unix socket: \/data\/mysql\/mysql.sock<\/p>\n
Time \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Id Command\u00a0 \u00a0 Argument<\/p>\n
# Time: 140302\u00a0 7:40:56<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 1.932741\u00a0 Lock_time: 0.000281 Rows_sent: 100\u00a0 Rows_examined: 648306<\/p>\n
use tpch;<\/p>\n
SET timestamp=1393713656;<\/p>\n
select s_name, count(*) as numwait from SUPPLIER, LINEITEM l1, ORDERS, NATION where s_suppkey = l1.l_suppkey and o_orderkey = l1.l_orderkey and o_orderstatus = ‘F’ and l1.l_receiptdate > l1.l_commitdate and exists ( select * from LINEITEM l2 where l2.l_orderkey = l1.l_orderkey and l2.l_suppkey <> l1.l_suppkey) and not exists ( select * from LINEITEM l3 where l3.l_orderkey = l1.l_orderkey and l3.l_suppkey <> l1.l_suppkey and l3.l_receiptdate > l3.l_commitdate) and s_nationkey = n_nationkey and n_name = ‘CHINA’ group by s_name order by numwait desc, s_name limit 100;<\/p>\n
# Time: 140302\u00a0 7:40:58<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 2.233532\u00a0 Lock_time: 0.000180 Rows_sent: 10\u00a0 Rows_examined: 2830403<\/p>\n
SET timestamp=1393713658;<\/p>\n
select l_orderkey, sum(l_extendedprice * (1 – l_discount)) as revenue, o_orderdate, o_shippriority from CUSTOMER, ORDERS, LINEITEM where c_mktsegment = ‘HOUSEHOLD’ and c_custkey = o_custkey and l_orderkey = o_orderkey and o_orderdate < date ‘1995-03-16’ and l_shipdate > date ‘1995-03-16’ group by l_orderkey, o_orderdate, o_shippriority order by revenue desc, o_orderdate limit 10;<\/p>\n
# Time: 140302\u00a0 7:41:03<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 4.689517\u00a0 Lock_time: 0.000191 Rows_sent: 8\u00a0 Rows_examined: 7651587<\/p>\n
SET timestamp=1393713663;<\/p>\n
select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from CUSTOMER, ORDERS, LINEITEM where o_orderkey in ( select l_orderkey from LINEITEM group by l_orderkey having sum(l_quantity) > 312) and c_custkey = o_custkey and o_orderkey = l_orderkey group by c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice order by o_totalprice desc, o_orderdate limit 100;<\/p>\n
# Time: 140302\u00a0 7:41:04<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.817588\u00a0 Lock_time: 0.000205 Rows_sent: 4\u00a0 Rows_examined: 560132<\/p>\n
SET timestamp=1393713664;<\/p>\n
select n_name, sum(l_extendedprice * (1 – l_discount)) as revenue from CUSTOMER, ORDERS, LINEITEM, SUPPLIER, NATION, REGION where c_custkey = o_custkey and l_orderkey = o_orderkey and l_suppkey = s_suppkey and c_nationkey = s_nationkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = ‘MIDDLE EAST’ and o_orderdate >= date ‘1996-01-01’ and o_orderdate < date ‘1996-01-01’ + interval ‘1’ year group by n_name order by revenue desc;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.107374\u00a0 Lock_time: 0.000203 Rows_sent: 1038\u00a0 Rows_examined: 94397<\/p>\n
SET timestamp=1393713664;<\/p>\n
select ps_partkey, sum(ps_supplycost * ps_availqty) as value from PARTSUPP, SUPPLIER, NATION where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = ‘ETHIOPIA’ group by ps_partkey having sum(ps_supplycost * ps_availqty) > ( select sum(ps_supplycost * ps_availqty) * 0.0001000000 from PARTSUPP, SUPPLIER, NATION where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = ‘ETHIOPIA’) order by value desc;<\/p>\n
# Time: 140302\u00a0 7:41:06<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 1.506114\u00a0 Lock_time: 0.000250 Rows_sent: 4\u00a0 Rows_examined: 909683<\/p>\n
SET timestamp=1393713666;<\/p>\n
select supp_nation, cust_nation, l_year, sum(volume) as revenue from ( select n1.n_name as supp_nation, n2.n_name as cust_nation, extract(year from l_shipdate) as l_year, l_extendedprice * (1 – l_discount) as volume from SUPPLIER, LINEITEM, ORDERS, CUSTOMER, NATION n1, NATION n2 where s_suppkey = l_suppkey and o_orderkey = l_orderkey and c_custkey = o_custkey and s_nationkey = n1.n_nationkey and c_nationkey = n2.n_nationkey and ( (n1.n_name = ‘ETHIOPIA’ and n2.n_name = ‘CHINA’) or (n1.n_name = ‘CHINA’ and n2.n_name = ‘ETHIOPIA’)) and l_shipdate between date ‘1995-01-01’ and date ‘1996-12-31’) shipping group by supp_nation, cust_nation, l_year order by supp_nation, cust_nation, l_year;<\/p>\n
# Time: 140302\u00a0 7:41:08<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 2.492662\u00a0 Lock_time: 0.000152 Rows_sent: 1\u00a0 Rows_examined: 6001515<\/p>\n
SET timestamp=1393713668;<\/p>\n
select sum(l_extendedprice * l_discount) as revenue from LINEITEM where l_shipdate >= date ‘1995-01-01’ and l_shipdate < date ‘1995-01-01’ + interval ‘1’ year and l_discount between 0.06 – 0.01 and 0.06 + 0.01 and l_quantity < 24;<\/p>\n
# Time: 140302\u00a0 7:41:09<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.936907\u00a0 Lock_time: 0.000212 Rows_sent: 82\u00a0 Rows_examined: 257367<\/p>\n
SET timestamp=1393713669;<\/p>\n
select s_name, s_address from SUPPLIER, NATION where s_suppkey in ( select ps_suppkey from PARTSUPP where ps_partkey in ( select p_partkey from PART where p_name like ‘dark%’) and ps_availqty > ( select 0.5 * sum(l_quantity) from LINEITEM where l_partkey = ps_partkey and l_suppkey = ps_suppkey and l_shipdate >= date ‘1994-01-01’ and l_shipdate < date ‘1994-01-01’ + interval ‘1’ year)) and s_nationkey = n_nationkey and n_name = ‘EGYPT’ order by s_name;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.395880\u00a0 Lock_time: 0.000173 Rows_sent: 1\u00a0 Rows_examined: 389326<\/p>\n
SET timestamp=1393713669;<\/p>\n
select sum(l_extendedprice) \/ 7.0 as avg_yearly from LINEITEM, PART where p_partkey = l_partkey and p_brand = ‘Brand#35’ and p_container = ‘JUMBO BOX’ and l_quantity < ( select 0.2 * avg(l_quantity) from LINEITEM where l_partkey = p_partkey);<\/p>\n
# Time: 140302\u00a0 7:41:12<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 2.623498\u00a0 Lock_time: 0.000199 Rows_sent: 2\u00a0 Rows_examined: 6032625<\/p>\n
SET timestamp=1393713672;<\/p>\n
select l_shipmode, sum(case when o_orderpriority = ‘1-URGENT’ or o_orderpriority = ‘2-HIGH’ then 1 else 0 end) as high_line_count, sum(case when o_orderpriority <> ‘1-URGENT’ and o_orderpriority <> ‘2-HIGH’ then 1 else 0 end) as low_line_count from ORDERS, LINEITEM where o_orderkey = l_orderkey and l_shipmode in (‘FOB’, ‘TRUCK’) and l_commitdate < l_receiptdate and l_shipdate < l_commitdate and l_receiptdate >= date ‘1994-01-01’ and l_receiptdate < date ‘1994-01-01’ + interval ‘1’ year group by l_shipmode order by l_shipmode;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.345243\u00a0 Lock_time: 0.000189 Rows_sent: 18261\u00a0 Rows_examined: 395717<\/p>\n
SET timestamp=1393713672;<\/p>\n
select p_brand, p_type, p_size, count(distinct ps_suppkey) as supplier_cnt from PARTSUPP, PART where p_partkey = ps_partkey and p_brand <> ‘Brand#31’ and p_type not like ‘STANDARD BRUSHED%’ and p_size in (27, 8, 32, 37, 13, 46, 31, 5) and ps_suppkey not in ( select s_suppkey from SUPPLIER where s_comment like ‘%Customer%Complaints%’) group by p_brand, p_type, p_size order by supplier_cnt desc, p_brand, p_type, p_size;<\/p>\n
# Time: 140302\u00a0 7:41:14<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 1.955579\u00a0 Lock_time: 0.000463 Rows_sent: 1\u00a0 Rows_examined: 510249<\/p>\n
SET timestamp=1393713674;<\/p>\n
select s_suppkey, s_name, s_address, s_phone, total_revenue from SUPPLIER, revenue0 where s_suppkey = supplier_no and total_revenue = ( select max(total_revenue) from revenue0) order by s_suppkey;<\/p>\n
# Time: 140302\u00a0 7:41:17<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 2.497492\u00a0 Lock_time: 0.000180 Rows_sent: 32\u00a0 Rows_examined: 1850065<\/p>\n
SET timestamp=1393713677;<\/p>\n
select c_count, count(*) as custdist from ( select c_custkey as c_custkey, count(o_orderkey) as c_count from CUSTOMER left outer join ORDERS on c_custkey = o_custkey and o_comment not like ‘%unusual%accounts%’ group by c_custkey) as c_orders group by c_count order by custdist desc, c_count desc;<\/p>\n
# Time: 140302\u00a0 7:41:18<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.956482\u00a0 Lock_time: 0.000206 Rows_sent: 20\u00a0 Rows_examined: 406925<\/p>\n
SET timestamp=1393713678;<\/p>\n
select c_custkey, c_name, sum(l_extendedprice * (1 – l_discount)) as revenue, c_acctbal, n_name, c_address, c_phone, c_comment from CUSTOMER, ORDERS, LINEITEM, NATION where c_custkey = o_custkey and l_orderkey = o_orderkey and o_orderdate >= date ‘1993-02-01’ and o_orderdate < date ‘1993-02-01’ + interval ‘3’ month and l_returnflag = ‘R’ and c_nationkey = n_nationkey group by c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment order by revenue desc limit 20;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.411825\u00a0 Lock_time: 0.000232 Rows_sent: 100\u00a0 Rows_examined: 336528<\/p>\n
SET timestamp=1393713678;<\/p>\n
select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from PART, SUPPLIER, PARTSUPP, NATION, REGION where p_partkey = ps_partkey and s_suppkey = ps_suppkey and p_size = 17 and p_type like ‘%STEEL’ and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = ‘EUROPE’ and ps_supplycost = ( select min(ps_supplycost) from PARTSUPP, SUPPLIER, NATION, REGION where p_partkey = ps_partkey and s_suppkey = ps_suppkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = ‘EUROPE’) order by s_acctbal desc, n_name, s_name, p_partkey limit 100;<\/p>\n
# Time: 140302\u00a0 7:41:20<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 1.675488\u00a0 Lock_time: 0.000264 Rows_sent: 2\u00a0 Rows_examined: 1786223<\/p>\n
SET timestamp=1393713680;<\/p>\n
select o_year, sum(case when NATION = ‘CHINA’ then volume else 0 end) \/ sum(volume) as mkt_share from ( select extract(year from o_orderdate) as o_year, l_extendedprice * (1 – l_discount) as volume, n2.n_name as NATION from PART, SUPPLIER, LINEITEM, ORDERS, CUSTOMER, NATION n1, NATION n2, REGION where p_partkey = l_partkey and s_suppkey = l_suppkey and l_orderkey = o_orderkey and o_custkey = c_custkey and c_nationkey = n1.n_nationkey and n1.n_regionkey = r_regionkey and r_name = ‘ASIA’ and s_nationkey = n2.n_nationkey and o_orderdate between date ‘1995-01-01’ and date ‘1996-12-31’ and p_type = ‘PROMO ANODIZED COPPER’) all_nations group by o_year order by o_year;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.279161\u00a0 Lock_time: 0.000174 Rows_sent: 1\u00a0 Rows_examined: 149926<\/p>\n
SET timestamp=1393713680;<\/p>\n
select 100.00 * sum(case when p_type like ‘PROMO%’ then l_extendedprice * (1 – l_discount) else 0 end) \/ sum(l_extendedprice * (1 – l_discount)) as promo_revenue from LINEITEM, PART where l_partkey = p_partkey and l_shipdate >= date ‘1996-04-01’ and l_shipdate < date ‘1996-04-01’ + interval ‘1’ month;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.129972\u00a0 Lock_time: 0.000217 Rows_sent: 1\u00a0 Rows_examined: 215907<\/p>\n
SET timestamp=1393713680;<\/p>\n
select sum(l_extendedprice* (1 – l_discount)) as revenue from LINEITEM, PART where ( p_partkey = l_partkey and p_brand = ‘Brand#31’ and p_container in (‘SM CASE’, ‘SM BOX’, ‘SM PACK’, ‘SM PKG’) and l_quantity >= 10 and l_quantity <= 10 + 10 and p_size between 1 and 5 and l_shipmode in (‘AIR’, ‘AIR REG’) and l_shipinstruct = ‘DELIVER IN PERSON’) or ( p_partkey = l_partkey and p_brand = ‘Brand#42’ and p_container in (‘MED BAG’, ‘MED BOX’, ‘MED PKG’, ‘MED PACK’) and l_quantity >= 19 and l_quantity <= 19 + 10 and p_size between 1 and 10 and l_shipmode in (‘AIR’, ‘AIR REG’) and l_shipinstruct = ‘DELIVER IN PERSON’) or ( p_partkey = l_partkey and p_brand = ‘Brand#25’ and p_container in (‘LG CASE’, ‘LG BOX’, ‘LG PACK’, ‘LG PKG’) and l_quantity >= 29 and l_quantity <= 29 + 10 and p_size between 1 and 15 and l_shipmode in (‘AIR’, ‘AIR REG’) and l_shipinstruct = ‘DELIVER IN PERSON’);<\/p>\n
# Time: 140302\u00a0 7:41:24<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 3.396313\u00a0 Lock_time: 0.000234 Rows_sent: 175\u00a0 Rows_examined: 2575076<\/p>\n
SET timestamp=1393713684;<\/p>\n
select nation, o_year, sum(amount) as sum_profit from ( select n_name as nation, extract(year from o_orderdate) as o_year, l_extendedprice * (1 – l_discount) – ps_supplycost * l_quantity as amount from PART, SUPPLIER, LINEITEM, PARTSUPP, ORDERS, NATION where s_suppkey = l_suppkey and ps_suppkey = l_suppkey and ps_partkey = l_partkey and p_partkey = l_partkey and o_orderkey = l_orderkey and s_nationkey = n_nationkey and p_name like ‘%cornflower%’) profit group by nation, o_year order by nation, o_year desc;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.145015\u00a0 Lock_time: 0.000234 Rows_sent: 7\u00a0 Rows_examined: 305314<\/p>\n
SET timestamp=1393713684;<\/p>\n
select cntrycode, count(*) as numcust, sum(c_acctbal) as totacctbal from ( select substr(c_phone, 1, 2) as cntrycode, c_acctbal from CUSTOMER where substr(c_phone, 1, 2) in (’32’, ’34’, ’11’, ’12’, ’13’, ’33’, ’28’) and c_acctbal > ( select avg(c_acctbal) from CUSTOMER where c_acctbal > 0.00 and substr(c_phone, 1, 2) in (’32’, ’34’, ’11’, ’12’, ’13’, ’33’, ’28’)) and not exists ( select * from ORDERS where o_custkey = c_custkey)) custsale group by cntrycode order by cntrycode;<\/p>\n
# Time: 140302\u00a0 7:41:41<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 16.831948\u00a0 Lock_time: 0.000181 Rows_sent: 4\u00a0 Rows_examined: 6001523<\/p>\n
SET timestamp=1393713701;<\/p>\n
select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice * (1 – l_discount)) as sum_disc_price, sum(l_extendedprice * (1 – l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from LINEITEM where l_shipdate <= date ‘1998-12-01’ – interval ‘109’ day group by l_returnflag, l_linestatus order by l_returnflag, l_linestatus;<\/p>\n
# User@Host: root[root] @ localhost [127.0.0.1]\u00a0 Id:\u00a0 \u00a0 70<\/p>\n
# Query_time: 0.454927\u00a0 Lock_time: 0.000172 Rows_sent: 5\u00a0 Rows_examined: 140720<\/p>\n
SET timestamp=1393713701;<\/p>\n
select o_orderpriority, count(*) as order_count from ORDERS where o_orderdate >= date ‘1993-03-01’ and o_orderdate < date ‘1993-03-01’ + interval ‘3’ month and exists ( select * from LINEITEM where l_orderkey = o_orderkey and l_commitdate < l_receiptdate) group by o_orderpriority order by o_orderpriority;<\/p>\n
<\/p>\n<\/div>\n
<\/p>\n
MySQL\u3067\u78ba\u8a8d\u3059\u308b\u5834\u5408\u306f\u3001TPC-H\u3067\u3042\u308c\u3070general_log\u3092\u6709\u52b9\u306b\u3057\u305f\u65b9\u304c\u308f\u304b\u308a\u3084\u3059\u3044\u3068\u601d\u3044\u307e\u3059\u3002general_log\u306e\u66f8\u304d\u8fbc\u307f\u306f\u30af\u30a8\u30ea\u5b9f\u884c\u306b\u6bd4\u8f03\u3059\u308b\u3068\u975e\u5e38\u306b\u77ed\u3044\u306e\u3067\u3001\u8aa4\u5dee\u30ec\u30d9\u30eb\u3067\u3057\u3087\u3046\u3002\u3002<\/p>\n
\u30c7\u30fc\u30bf\u91cf\u304c\u5c11\u306a\u3044\u306e\u3067\u3001\u3069\u306e\u30af\u30a8\u30ea\u3082\u7121\u96e3\u306a\u6642\u9593\u3067\u5b8c\u4e86\u3057\u3066\u307e\u3059\u304c\u3001Scale Factor\u3092\u5927\u304d\u304f\u3057\u305f\u3068\u304d\u306b\u3069\u3046\u306a\u308b\u304b\u306f\u5225\u9014\u78ba\u8a8d\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n
<\/p>\n
\u3053\u308c\u3067\u4e00\u901a\u308a\u3001TPC-H\u306e\u30af\u30a8\u30ea\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\u00a0TPC-C\u306f\u78ba\u8a8d\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u540c\u3058\u624b\u9806\u3067\u5927\u4e08\u592b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/span><\/p>\n <\/p>\n
\u601d\u3063\u305f\u3088\u308a\u3082HammerDB\u304c\u3001\u4fbf\u5229\u305d\u3046\u306a\u306e\u3067\u3082\u3046\u5c11\u3057\u4f7f\u3063\u3066\u307f\u3088\u3046\u304b\u3068\u3002<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8a00\u308f\u305a\u3068\u77e5\u308c\u305fTPC-C\u304cOLTP\u306e\u6027\u80fd\u6307\u6a19\u3068\u306a\u308b\u306e\u3067\u3042\u308c\u3070\u3001TPC-H\u306fDSS\u306e\u6307\u6a19\u3068\u306a\u308b\u3082\u306e\u3002 10\u5e74\u307b\u3069\u524d\u306e\u65b0\u5165\u793e\u54e1\u306e\u3053\u308d\u306bMySQL4.1\u3067\u7121\u7406\u77e2\u7406TPC-H\u306e\u30af\u30a8\u30ea\u3092\u52d5\u304b\u3057\u305f\u3082\u306e\u306e\u3001\u7d50\u679c\u304c\u8fd4\u3063\u3066\u3053… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[5,24,22],"tags":[],"_links":{"self":[{"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1478"}],"collection":[{"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1478"}],"version-history":[{"count":26,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1478\/revisions"}],"predecessor-version":[{"id":1587,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1478\/revisions\/1587"}],"wp:attachment":[{"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a23187.yorozuyah.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.21.47.png\" "\\"2014-03-01")
<\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.22.19.png\" "\\"2014-03-01")
<\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.22.48.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.23.14.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.23.26.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.24.13.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.24.44.png\" "\\"2014-03-01")
<\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.25.04.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.25.41.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.26.10.png\" "\\"2014-03-01")
<\/a><\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.28.41.png\" "\\"2014-03-01")
<\/p>\n![\"\"](\"https:\/\/a23187.yorozuyah.com\/blog\/wp-content\/uploads\/2014\/03\/2014-03-01-23.26.47.png\" "\\"2014-03-01")
<\/a><\/p>\n