sunyun0090的博客

//30多万条数据0.4秒 不到，查询某时间段内连续登陆n天的用户，1132条SET @wy=0;SELECT DISTINCT uidFROM (SELECT MAX(date)-MIN(date) less,uid    FROM (SELECT date-rn diff, uid, date, rn        FROM (SELECT @wy:=@wy+1 rn, u

--sumdate--注册日期--diff1--次日留存人数--diff3--三日留存人数--diff7--七日留存人数select sumdate,SUM(diff1) diff1,SUM(diff3) diff3,SUM(diff7) diff7        from (            SELECT b.sumdate sumdate,a.gu

//http请求 body内容添加public static void do_json_req(){        HttpPost request = new HttpPost("http://localhost:8080/DSQ_Payment/uccb.do");        JSONObject param_data = new JSONObject();

解决方法：将sigar-x86-winnt.dll拷到java jdk的bin目录下sigar-amd64-winnt.dll sigar-x86-winnt.dll 下载地址