Skip to content

Instantly share code, notes, and snippets.


Hydra ox0spy

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

use vi mode editing in psql


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

Moved to git repository:

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.


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


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


sudo docker-compose exec elasticsearch bash

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

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

The last time i visited this link it was dead (403), so I cloned it here from the latest snapshot in's Wayback Machine

Mac OS X

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

ox0spy /
Last active Dec 11, 2019
[MySQL] load data local infile


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


修改 MySQL 配置文件

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

ox0spy /
Created Nov 22, 2019 — forked from pwnsdx/
Disable bunch of #$!@ in Catalina
# 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/
# 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 /
Created Nov 2, 2019
修复从 bitbucket 导入到 github wiki 中的 markdown link

Java 逆向工程


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

ox0spy /
Last active Feb 24, 2020
PostgreSQL Tips


JSON Functions and Operators

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

ALTER TABLE a ALTER COLUMN t TYPE TIMESTAMP 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.