aws rds dump

Read full article  | 评论关闭

 

log_bin_trust_function_creators   = 1

 

mysqldump with –set-gtid-purged=OFF

Read More

更换wordpress 域名

Read full article  | 评论关闭

1. 更改wp-config.php里面的域名

2. 修改数据库里面的内容

UPDATE wp_options SET option_value = replace(option_value, ‘old_domain’,'new_domain’) ;

UPDATE wp_posts SET post_content = replace(post_content, ‘old_domain’,'new_domain’) ;

UPDATE wp_posts SET guid = replace(guid, ‘old_domain’,'new_domain’) ;

UPDATE wp_comments SET comment_content = replace(comment_content, ‘old_domain’,'new_domain’) ;

UPDATE wp_comments SET comment_author_url = replace(comment_author_url, ‘old_domain’,'new_domain’) ;

Read More

mysql explain type 优先级

Read full article  | 评论关闭

 

 

system/const/eq_ref/ref/range/index/ALL

Read More

ubuntu nodejs 8

Read full article  | 评论关闭

 

 

curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -

sudo apt-get install -y nodejs

 

 

npm install pm2 -g

Read More

ubuntu remove package

Read full article  | 评论关闭

 

apt-get autoclean:
如果你的硬盘空间不大的话,可以定期运行这个程序,将已经删除了的软件包的.deb安装文件从硬盘中删除掉。

 

apt-get clean:
类似上面的命令,但它删除包缓存中的所有包。这是个很好的做法,因为多数情况下这些包没有用了。

 

apt-get autoremove:
删除为了满足其他软件包的依赖而安装的,但现在不再需要的软件包。

 

其它:

apt-get remove 软件包名称:
删除已安装的软件包(保留配置文件)。

apt-get –purge remove 软件包名称:
删除已安装包(不保留配置文件)。

Read More

mongo explain

Read full article  | 评论关闭

 

db.test.explain("executionStats").find({"user":"1332200000"})

Read More

mongo add index

Read full article  | 评论关闭

 

db.user.ensureIndex({“name”:1,”age”:1})

 

db.COLLECTION_NAME.getIndexes()

db.sites.dropIndex("name_1_domain_-1")

Read More

mongo count distinct

Read full article  | 评论关闭

 

 

db.collection_name.distinct(‘types2′)

Read More

nginx upstream based on URL parameter

Read full article  | 评论关闭

 

 

location / {

if ( $arg_parameterName = “test1″ ) {
proxy_pass http://server1;
}
if ( $arg_parameterName = “test2″ ) {
proxy_pass http://server2;
}
}

Read More

delete old data from elasticsearch

Read full article  | 评论关闭

 

get indices info

curl 'localhost:9200/_cat/indices?v'

delete old data:
curl -v -X DELETE http://localhost:9200/logstash-$day*

Read More