Skip to content

Instantly share code, notes, and snippets.

🎯
Focusing

Hydra ox0spy

🎯
Focusing
Block or report user

Report or block ox0spy

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View psql-tips.md

use vi mode editing in psql

~/.inputrc

set editing-mode vi
@ox0spy
ox0spy / nginx-tuning.md
Created Apr 8, 2020 — forked from denji/nginx-tuning.md
NGINX tuning for best performance
View nginx-tuning.md

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

View yum-tips.md

Fix rpmdb: Thread died in Berkeley DB library

error message

rpmdb: Thread/process 277623/140429100390144 failed: Thread died in Berkeley DB library
error: db3 error(-30974) from dbenv->failchk: DB_RUNRECOVERY: Fatal error, run database recovery
error: cannot open Packages index using db3 -  (-30974)
error: cannot open Packages database in /var/lib/rpm
CRITICAL:yum.verbose.cli.yumcompletets:Yum Error: Error: rpmdb open failed
View graylog-tips.md

ElasticSearch

Q: 通过 docker-compose 运行的 graylog 及 elasticsearch,如何进入 elasticsearch?

A:

sudo docker-compose exec elasticsearch bash

@ox0spy
ox0spy / README.md
Created Jan 11, 2020 — forked from tombigel/README.md
How to Change Open Files Limit on OS X and macOS Sierra (10.8 - 10.12)
View README.md

How to Change Open Files Limit on OS X and macOS

This text is the section about OS X Yosemite (which also works for macOS Sierra) from https://docs.basho.com/riak/kv/2.1.4/using/performance/open-files-limit/#mac-os-x

The last time i visited this link it was dead (403), so I cloned it here from the latest snapshot in Archive.org's Wayback Machine https://web.archive.org/web/20170523131633/https://docs.basho.com/riak/kv/2.1.4/using/performance/open-files-limit/

Mac OS X

To check the current limits on your Mac OS X system, run:

@ox0spy
ox0spy / mysql-load-data-local-infile.md
Last active Dec 11, 2019
[MySQL] load data local infile
View mysql-load-data-local-infile.md

错误信息

ERROR 1148: The used command is not allowed with this MySQL version

解决

修改 MySQL 配置文件

my.cnf 中的 [client][mysqld] 中增加 loose-local-infile=1

@ox0spy
ox0spy / disable.sh
Created Nov 22, 2019 — forked from pwnsdx/disable.sh
Disable bunch of #$!@ in Catalina
View disable.sh
#!/bin/bash
# IMPORTANT: Don't forget to logout from your Apple ID in the settings before running it!
# IMPORTANT: You will need to run this script from Recovery. In fact, macOS Catalina brings read-only filesystem which prevent this script from working from the main OS.
# This script needs to be run from the volume you wish to use.
# E.g. run it like this: cd /Volumes/Macintosh\ HD && sh /Volumes/Macintosh\ HD/Users/sabri/Desktop/disable.sh
# WARNING: It might disable things that you may not like. Please double check the services in the TODISABLE vars.
# Get active services: launchctl list | grep -v "\-\t0"
# Find a service: grep -lR [service] /System/Library/Launch* /Library/Launch* ~/Library/LaunchAgents
@ox0spy
ox0spy / migrate-markdown-link-from-bitbucket-to-github.py
Created Nov 2, 2019
修复从 bitbucket 导入到 github wiki 中的 markdown link
View migrate-markdown-link-from-bitbucket-to-github.py
View java-reverse-engineering.md

Java 逆向工程

Java反编译

注:反编译后的 java 代码只能阅读来查看代码逻辑,不能保障能再通过 javac 编译会 class

@ox0spy
ox0spy / PostgreSQL-tips.md
Last active Feb 24, 2020
PostgreSQL Tips
View PostgreSQL-tips.md

json

JSON Functions and Operators

将不带 timezone 的日期修改为带 timezone 的

ALTER TABLE a ALTER COLUMN t TYPE TIMESTAMP WITH TIME ZONE;

https://stackoverflow.com/questions/9772825/postgresql-alter-type-timestamp-without-time-zone-with-time-zone It is better to specify the time zone explicitly. Say, if your timestamp are supposed to be in UTC (but without timezone), you should be wary of the fact that the timezone of the client or server might be messing everything here. Instead write:

You can’t perform that action at this time.