Skip to content

Instantly share code, notes, and snippets.

View n0ts's full-sized avatar
🏠
Working from home

Naoya Nakazawa n0ts

🏠
Working from home
  • Freelancer
  • Tokyo, Japan
  • X @n0ts
View GitHub Profile
@n0ts
n0ts / gist:493f0867b0541077768e
Created November 13, 2014 00:16
pgsql link error
...
ld: warning: directory not found for option '-L/usr/local/homebrew/Cellar/libpng/1.6.10/lib'
Undefined symbols for architecture x86_64:
"_lo_lseek64", referenced from:
_zif_pg_lo_seek in pgsql.o
"_lo_tell64", referenced from:
_zif_pg_lo_tell in pgsql.o
"_lo_truncate64", referenced from:
_zif_pg_lo_truncate in pgsql.o
ld: symbol(s) not found for architecture x86_64
@n0ts
n0ts / DBUtil.py.patch
Created December 22, 2014 02:22
Patch gmond/python_modules/db/DBUtil.py
--- ./gmond/python_modules/db/DBUtil.py-org 2014-10-23 10:24:40.000000000 +0900
+++ ./gmond/python_modules/db/DBUtil.py 2014-10-23 10:35:23.000000000 +0900
@@ -86,7 +86,7 @@
innodb_status['active_transactions']
for line in innodb_status_raw:
- istatus = line.split()
+ istatus = line.replace(',', '').replace(';', '').split()
isum = sumof(istatus)
@n0ts
n0ts / mysql.py.patch
Created December 22, 2014 02:23
Patch gmond/python_modules/db/mysql.py
--- ./gmond/python_modules/db/mysql.py-org 2014-10-23 10:20:38.000000000 +0900
+++ ./gmond/python_modules/db/mysql.py 2014-10-23 12:23:31.000000000 +0900
@@ -113,7 +113,7 @@
if get_innodb:
cursor = conn.cursor(MySQLdb.cursors.Cursor)
cursor.execute("SHOW /*!50000 ENGINE*/ INNODB STATUS")
- innodb_status = parse_innodb_status(cursor.fetchone()[0].split('\n'))
+ innodb_status = parse_innodb_status(cursor.fetchone()[2].split('\n'))
cursor.close()
logging.debug('innodb_status: ' + str(innodb_status))
@n0ts
n0ts / mysql.pyconf
Created December 22, 2014 02:35
Ganglia MySQL Configuration
###
###
### This module requires MySQL-python e.g. on Centos/RHEL
### * yum install MySQL-python
###
### Note:
### To setup database access:
### GRANT SUPER, PROCESS ON *.* TO your_user@localhost \
### IDENTIFIED BY "your_password";
###
@n0ts
n0ts / gist:5ce4e90e1ede58458bb1
Last active August 29, 2015 14:13
tmp nginx.conf
server {
listen 80;
server_name _;
#access_log /tmp/access.log main;
access_log /var/log/nginx/test-access.log main;
location / {
#root /tmp/test;
root /test/tmp;
@n0ts
n0ts / MySQL slave daly patch for MySQL 5.1.44
Created March 2, 2010 04:59
MySQL slave delay patch for MySQL 5.1.44
--- trunk/mysql/SOURCES/mysql-slave-delay-5.1.44.patch (rev 0)
+++ trunk/mysql/SOURCES/mysql-slave-delay-5.1.44.patch 2010-03-02 04:08:00 UTC (rev 71)
@@ -0,0 +1,84 @@
+diff -u mysql-5.1.44.bak/sql/mysqld.cc mysql-5.1.44/sql/mysqld.cc
+--- mysql-5.1.44.bak/sql/mysqld.cc 2010-02-04 20:39:50.000000000 +0900
++++ mysql-5.1.44/sql/mysqld.cc 2010-02-15 21:21:09.000000000 +0900
+@@ -523,6 +523,9 @@
+ ulong query_buff_size, slow_launch_time, slave_open_temp_tables;
+ ulong open_files_limit, max_binlog_size, max_relay_log_size;
+ ulong slave_net_timeout, slave_trans_retries;
require 'rubygems'
require 'id3lib'
# Set file name
filename = ARGV[0]
exit unless FileTest.exists?(filename)
basename = File::basename(filename, '.mp3').scan(/.*_(.*)-(.*)/)
season = basename[0][0]
chapter = basename[0][1]
#!/bin/sh
HANDBRAKE=/Applications/HandBrakeCLI
FFMPEG=/opt/local/bin/ffmpeg
INPUT=/Volumes/FRIENDS
OUTPUT=/Users/n0ts/Desktop
SERIES=$1
START_EPISODE=$2
if [ -z $1 ]; then
*nat
:PREROUTING ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
:POSTROUTING ACCEPT [0:0]
-A POSTROUTING -o eth0 -p tcp --dport 80 -m statistic --mode nth --every 4 -j SNAT --to-source 192.168.161.125
-A POSTROUTING -o eth0 -p tcp --dport 80 -m statistic --mode nth --every 3 -j SNAT --to-source 192.168.161.124
-A POSTROUTING -o eth0 -p tcp --dport 80 -m statistic --mode nth --every 2 -j SNAT --to-source 192.168.161.123
-A POSTROUTING -o eth0 -p tcp --dport 80 -m statistic --mode nth --every 1 -j SNAT --to-source 192.168.161.122
COMMIT
#!/bin/sh
MYSQL=/usr/bin/mysql
DATABASE="test"
SOCKET="/var/lib/mysql/mysql.sock"
# listed all tables
for table in `$MYSQL -u root $DATABASE -N -s -e 'show tables'`;
do