jpuyy的网志

Blog

  • git diff 换行

    git --no-pager diff

    or

    git diff --color | less -R

    显示改动过的文件

    git diff --staged --name-only  | cat

    比较 feature 分支和 master 分支具体一个文件的变动

    git diff feature/sftp-server master -- .gitlab-ci.yml

    https://stackoverflow.com/questions/4099742/how-to-compare-files-from-two-different-branches

  • 更改 mysql 慢查询时间阈值

    默认是 10s ，改为 200ms 

    mysql> show global variables like 'long_query_time%';
+-----------------+-----------+
| Variable_name   | Value     |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+
1 row in set (0.01 sec)

mysql> set global long_query_time=0.2;
Query OK, 0 rows affected (0.01 sec)

mysql> show global variables like 'long_query_time%';
+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| long_query_time | 0.200000 |
+-----------------+----------+
1 row in set (0.00 sec)

  • 防止在 slave 上执行sql 误操作

    防止在 slave 上执行sql 误操作最主要的还是知道自己执行的机器是否正确。

    要知道自己在哪台机器上

    select @@hostname

    查看 master status

    show master status\G

    查看 slave status (主库不应看到信息)

    show slave status

    查看 slave 有哪些 (从库不应看到信息)

    show slave hosts\G

  • rabbitmq从集群中拆除节点并初始化

    node1,node2,node3 想要拆掉 node3 做为单独和 node1,node2 相同配置的集群

    保存当前 definitions

    GET $host:15672/api/definitions 保存为 json文件

    node3 上执行

    rabbitmqctl stop_app

    node1上执行

    rabbitmqctl forget_cluster_node rabbit@node3

    node3 上删除 /var/lib/rabbitmq/mnesia 数据库下所有文件， 重启

    之后 node3 初始化

    rabbitmqctl add_user admin admin
rabbitmqctl set_user_tags admin administrator
rabbitmqctl set_permissions -p / admin ".*" ".*" ".*"

    登录到管理台导入json文件

  • macOS iCloud Drive path

    The path of iCloud Drive is

    ~/Library/Mobile\ Documents/com~apple~CloudDocs

    How to find this path
    Finder => View => Show Path Bar => Open iCloud Drive, in the bottom, right click, we can Copy “iCloud Drive” as Pathname

    We can create a symbolic link for the path

    ln -s ~/Library/Mobile\ Documents/com\~apple\~CloudDocs icloud

    Or an alias, cdi equals change directory to iCloud Drive

    alias cdi='cd ~/Library/Mobile\ Documents/com~apple~CloudDocs'

  • 2017读书清单

    目标30本书

    开始时间 技术书 非技术书 教学视频
    2017-03-10 人类简史
    2017-03-27 redis实战
    2017-04-28 Learning ELK stack
    2017-10-10 The go programming language