lingzhiwangcn的专栏

hbase环境配置优化：几个配置参数：hbase.hregion.max.filesize:1)当hbase.hregion.max.filesize比较小时，触发split的机率更大，而split的时候会将regionoffline，因此在split结束的时间前，访问该region的请求将被block住，客户端自我block的时间默认为1s。当大量的region同时发生split

selectSIWEB.DNSDELAY from CPSPHOENIXTESTDEMO where provcity='8320800' andDNSDELAY='-1';[this is OK]selectSIWEB.DNSDELAY from CPSPHOENIXTESTDEMO where provcity like '8320%' and DNSDELAY='-1';