jpuyy的网志

Blog

  • less 查找忽略大小写

    平时使用

    cat config.json | less

    如果有大小区分的时候搜索时不太方便

    现在只使用小写搜索

    cat config.json | less -i

  • mysqldump 加 where 条件

    导出表，时间大于 2017-05-17

    mysqldump -u root -p dw tracking --where 'stm > 2017-05-17' > dw.tracking.2017-05-17.sql

  • 《荒野求生》金句

    荒野虽险，身体+头脑依然能够生存，在社会上行走，也是行走在荒野

    Survival can be summed up in three words – never give up. That’s the heart of it really. Just keep trying.
    The line between life or death is determined by what we are willing to do.
    If you risk nothing you gain nothing
    If you can find a path with no obstacles, it probably doesn’t lead anywhere.
    There is little faith involved in setting out on a journey where the destination is certain and every step in between has been mapped in detail. Bravery, trust, is about leaving camp in the dark, when we do not know the route ahead and cannot be certain we will ever return.
    When you find yourself thinking about someone or something in the same old negative way, just stop yourself. Think. Check. Change. Refresh. Job done. Smile. Move on. Do this enough times and you will change. For the better; for the stronger.
    And if you give your heart to a goal, it will repay you. It’s the law of the universe.
    Stick to the fight when you’re hardest hit, It’s when things seem worst that you must not quit.
    There is no education like adversity.
    Tentative is no power.

  • 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