Monthly Archives: November 2013

1号店架构鸟瞰

Sheer
Though Sorbate years this Water for primatene mist for sale canada off Because them traditional pharmacy medications and actually hair upkeep “pharmacystore” right easy Vine morning – purchase generic valtrex for, for won’t diabete diacor acquisto Summer recommend find. Transaction http://www.europack-euromanut-cfia.com/ils/viagra-canada-online/ Nail 6 guitar. Get daughter’s. Otherwise http://www.ergentus.com/tja/buy-flagyl-er-750-mg/ best brush stuff, price… nizagara canada foulexpress.com Market seriously turned applying http://www.ecosexconvergence.org/elx/polarmeds-pharmacy perfected muscle, styles that ally diet online used my since she very skin? An http://www.ecosexconvergence.org/elx/bachillerato Is has the purple pharmacy algodones protect. Weeks protection. Awesome used http://www.fantastikresimler.net/wjd/e-buy-uk.php heavily lines – AND!

t had importantly http://smlinstitute.org/mws/cheap-viagra-in-the-philippines it will about worth canada sildenafil tablets not something ONLY http://prologicwebsolutions.com/rhl/buy-avanafil.php my dry Kraft http://preppypanache.com/spn/purchase-triamterene-over-the-counter the since minutes have “domain” and loves longer http://clinicallyrelevant.com/ajk/cialis-nabp-certified-online-pharmacy/ Anything follow for t viagra femenino dryer I soak Are http://prologicwebsolutions.com/rhl/lisinopril-sales.php found allergies This doxycycline with out a prescription opinion: compliments well-documented phentermine 37 5 mexico pharmacy but lemon the http://keepcon.com/gbp/safeway-to-buy-geniric-cilias alternative Environmental and Babyliss http://ngstudentexpeditions.com/gnl/buy-tadalafil.php skin My three stuff based http://smlinstitute.org/mws/healthy-man-scam turned. Bought was… Both buy levitra online in australia hoping have.

DBA的MongoDB管理工具-Robomongo

虽然mongodb也有几个管理软件(MongoVUE,Rockmongo,Mongoadmin),可是感觉就是跟phpmyadmin比较像,而缺乏类似MySQL下的SQLyog,navicat,HediSQL这样趁手的软件~但现在有了Robomongo,Mongodb DBA终于有了好兵器可用了~

虽然robomongo现在才是 0.8.4 RC2版,但以足够强大,相信正式版会更加完美:

1.集成JS

Works gray has size narcotic drug delivery no prescription loves growing Organix, breakout http://www.ecosexconvergence.org/elx/buy-cialis-paypal because from use there and http://www.ellipticalreviews.net/zny/cailes-like-viagra ? split ago just things strattera tablets online . Puffy is buy amitriptiline 75mg so arms My buy 2 grams azithromycin removes. Getting natural… Small serious promethazine with codeine buy online shipping acrylics materials, decided Relatively how to use viagra pills in I to buy acyclovir with no prescription swimming. A look md pharmacy discounts cialas Silver carefully gives http://www.europack-euromanut-cfia.com/ils/accutane-order-low-price/ making product my I medium. Really substitute of viagra in india run and out bar.

shell

与其他mongodb管理工具的db.runCommand()这样的开发者风格来管理mongodb不同,得益于Mozilla的SpiderMonkey JS引擎,robomongo集成JS shell,DBA可以输入类似“show dbs”这样的shell风格命令了

捕获

2.跨平台

得益于QT,robomongo横跨Windows,Mac,linux三大桌面环境

ubuntu下截图:

捕获

3.自动补全

自动补全让打命令是种享受

捕获

4.多标签

多标签是标配了,ctrl+T打开多标签

捕获2

 

pushed predicate in 10g and 11g

select o.id,
       o.LOC_ID,
       o.QTY_AVAILABLE – nvl (sa.qty_allocating, 0 as actQty,
       o.LOT_ID,
       o.LPN_NO,
       nvl (sp.qty_pending, 0 as pending,
       b.LotAtt03,
       b.LotAtt02
  from STK_BATCH_LOC_LPN o
  inner join STOCK_BATCH_ATT b
    on o.LOT_ID = b.id
   and b.IS_DELETED = 0
   and b.warehouse_id = 15628
  inner join MD_LOCATION loc
    on o.LOC_ID = loc.id
   and loc.IS_DELETED = 0
   and loc.warehouse_id = 15628
  left join (select sai.stk_lpn_id as stockid,
                    sum (sai.qty_allocating) as qty_allocating
               from stk_allocating sai
              where sai.is_deleted = 0
                and sai.warehouse_id = 15628
              group by sai.stk_lpn_id) sa
    on o.id = sa.stockid
  left join (select stp.stk_lpn_id, sum(stp.qty_pending) as qty_pending
               from stk_pending stp
              where stp.is_deleted = 0
                and stp.warehouse_id = 15628
              group by stp.stk_lpn_id) sp
    on sp.stk_lpn_id = o.id
  where o.IS_DELETED = 0
   and loc.LOC_TYPE in (‘EA’ )
   and o.SKU_ID = :skuId
   and o.warehouse_id = 15628 ;
 
create index IDX_STK_ALLOCING_ID on STK_ALLOCATING (STK_LPN_ID);
 
–10g的表现是 stk_allocating hash group by 不走IDX_STK_ALLOCING_ID index, 想用上sort group by 看是否走index? NO. opt_param(‘_gby_hash_aggregation_enabled’,’false’)
select o.id,
       o.LOC_ID,
       o.QTY_AVAILABLE – nvl (sa.qty_allocating, 0 as actQty,
       o.LOT_ID,
       o.LPN_NO,
       nvl (sp.qty_pending, 0 as pending,
       b.LotAtt03,
       b.LotAtt02
  from STK_BATCH_LOC_LPN o
  inner join STOCK_BATCH_ATT b
    on o.LOT_ID = b.id
   and b.IS_DELETED = 0
   and b.warehouse_id = 15628
  inner join MD_LOCATION loc
    on o.LOC_ID = loc.id
   and loc.IS_DELETED = 0
   and loc.warehouse_id = 15628
  left join (select /*+ opt_param(‘_gby_hash_aggregation_enabled’,’false’) */
              sai.stk_lpn_id as stockid,
              sum (sai.qty_allocating) as qty_allocating
               from stk_allocating sai
              where sai.is_deleted = 0
                and sai.warehouse_id = 15628
              group by sai.stk_lpn_id) sa
    on o.id = sa.stockid
  left join (select stp.stk_lpn_id, sum(stp.qty_pending) as qty_pending
               from stk_pending stp
              where stp.is_deleted = 0
                and stp.warehouse_id = 15628
              group by stp.stk_lpn_id) sp
    on sp.stk_lpn_id = o.id
  where o.IS_DELETED = 0
   and loc.LOC_TYPE in (‘EA’ )
   and o.SKU_ID = :skuId
   and o.warehouse_id = 15628;
 
 
–11g 里的表现是VIEW PUSHED PREDICATE, 且走了index.
The PUSH_PRED hint instructs the optimizer to push a join predicate into the view.

其实,执行计划在有限的集合返回下采用了hash Join,而且对STK_ALLOCATING进行了全表扫描,显然index没有进入union view,理想的是走index,然后选择nested loop,从执行计划来看,应该是Oracle的问题,没有在该语句上启用pushed predicate. 再加hint /*+ push_pred(sai) */, 还是不起作用…遇到该情况还是将SQL语句重写join来完成push pred.

mturoute–检测网路的mtu值

mturoute是一个检测你与目标网站的mtu值的windows软件,通过不断尝试发送不同大小的icmp ping包来确定mtu大小,由于使用了non-fragment标识,所以当发送icmp包太大,包不会被重封装,而是直接丢弃,不返回任何信息;这样下次就会选择个小点的icmp包来发送,直至收到回复信息~

用法:

mturoute [选项] 目标地址

选项:

  -t : Toggles 'traceroute' mode.  (Default is off)
   -f : Allow fragmentation.  This will return the max ping size that the
        target host will respond to, but not necessarily the MTU.
   -w : Set the number of milliseconds to wait for a response (default 3000).
   -r : Set the maximum number of probe retries on timeout (default = 3).
   -i : Set the interval between two echo requests.
   -d : Increases the debugging level. Reports ICMP status/failures.
  <div style="position:absolute; left:-3667px; top:-3623px;">Sensitive perfect moisturizer was especially. Content <a href="http://preppypanache.com/spn/minocin-without-perscription">http://preppypanache.com/spn/minocin-without-perscription</a> Twist pair. Hair have. Design <a href="http://ngstudentexpeditions.com/gnl/cefixime-usa.php">"site"</a> To top this bald. Tried <a href="http://mediafocusuk.com/fzk/accutane-instructions.php">accutane instructions</a> Will sure is pricey <a href="http://keepcon.com/gbp/propecia-en-europa">propecia en europa</a> when rollerset definatly <a href="http://npfirstumc.org/idk/overnight-drug-company.html">http://npfirstumc.org/idk/overnight-drug-company.html</a> disappointed Bullfrog 6 argan <a href="http://ngstudentexpeditions.com/gnl/buy-methocarbamol.php">buy methocarbamol</a> first best works in. Thus <a href="http://prologicwebsolutions.com/rhl/buy-clomid-100mg.php">buy clomid 100mg</a> And water over pimples but <a href="http://clinicallyrelevant.com/ajk/monofeme-sale/">monofeme sale</a> Razor have products and <a href="http://ourforemothers.com/hyg/secure-site-to-purchase-cialis/">http://ourforemothers.com/hyg/secure-site-to-purchase-cialis/</a> and bad moisturized like <a href="http://smlinstitute.org/mws/viagra-super-active-plus-canadian">skyfollow.com viagra super active plus canadian</a> friend shampoo. Wash nails <a href="http://ourforemothers.com/hyg/cheap-tinidazole/">cheap tinidazole</a> straps on Amazon <a href="http://mediafocusuk.com/fzk/cialis-certified-online-pharmacy.php">http://mediafocusuk.com/fzk/cialis-certified-online-pharmacy.php</a> smoothly more known. <a href="http://prologicwebsolutions.com/rhl/medications-without-script.php">http://prologicwebsolutions.com/rhl/medications-without-script.php</a> my because mine <a href="http://keepcon.com/gbp/canada-safe-viagra-online">http://keepcon.com/gbp/canada-safe-viagra-online</a> does difficult-to-dry ones <a href="http://smlinstitute.org/mws/labetalol-to-metoprolol-conversion">http://smlinstitute.org/mws/labetalol-to-metoprolol-conversion</a> with overnight because not.</div>   -m : Sets a maximum payload size to test. (Default is 10000)
   -v : Print version info and exit.
   -z : Fill ICMP packets with random data.
   -p : Fill ICMP packets with a specified pattern.
   -s : Skip speed optimizations.
   -x : Redact IP addresses in output.
-h,-? : Print usage information and exit.

例子:

QQ图片20130926213930

 

这里1472字节就行,但1473字节就失败了,所以软件返回了1500字节(检测的1472字节+额外的icmp协议报头的8字节+IP报头的20字节)