mysql 数据不存在插入,存在则更新
insert into car_media_article_click(media_id,article_id,click_num) values(3,1770351,1) on duplicate key update click_num = click_num + 1
其实我一直在你身边
insert into car_media_article_click(media_id,article_id,click_num) values(3,1770351,1) on duplicate key update click_num = click_num + 1
update by_article set pic_url = replace(pic_url,’oyskpbhvb.bkt.clouddn.com’,’wximg.checheng.cn’)
select date,DATE_FORMAT(date,’%Y%m’) weeks,sum(`install`) install_count,sum(`launches`) launches_count,sum(`active`) active_count from tj_app_day_data where date >=’2017-10-25′ and date<='2017-12-17' group by weeks;
select `date`,DATE_FORMAT(date,’%Y%m’) months,sum(`install`) install_count,sum(`launches`) launches_count,sum(`active`) active_count from tj_app_day_data where appid=’$appid’ and date >=’$start_date’ and date<='$end_date' group by months
新建索引
curl -XPUT ‘http://localhost:9200/dept/employee/1’ -d ‘{ “empname”: “emp1”}’
删除数据
curl -XDELETE ‘http://localhost:9200/dept/employee/3’
IK Analysis for ElasticSearch
The IK Analysis plugin integrates Lucene IK analyzer (http://code.google.com/p/ik-analyzer/) into elasticsearch, support customized dictionary.
Analyzer: ik_smart , ik_max_word , Tokenizer: ik_smart , ik_max_word
$client = Elasticsearch\ClientBuilder::create()
# ->setHosts([“localhost:9200”])
->setHosts([“101.37.85.163:9200”])
->setRetries(1)
->build();
namespace searchapi\controllers;
use Yii;
use yii\web\Controller;
use searchapi\models\CarBrandInfo;
use searchapi\models\CarBrandType;
use searchapi\models\CarBrandTypeInfo;
use searchapi\models\CarBrandSonTypeInfo;
use searchapi\models\CarFactory;
use yii\data\Pagination;
use yii\helpers\BaseJson;
use Elasticsearch;
elasticsearch + logstash + kibana 强大的日志处理分析系统
一、设计流程:
1.数据导入redis队列 key=logstash
2.logstash 获取redis队列logstash里面的数据
3.logstash把收集到数据传入elasticsearch 里面的index = sitelogs
4.kibana 设置 index = sitelogs
5.打开kibana 查询日志
在wp-config.php 最后一行添加
define(‘FS_METHOD’, “direct”);