Skip to content

Instantly share code, notes, and snippets.

View pcdinh's full-sized avatar

Pham Cong Dinh pcdinh

View GitHub Profile
ALTER TABLE `transaction`
PARTITION BY RANGE(TO_DAYS(created_time))
(PARTITION p09xx VALUES LESS THAN (TO_DAYS('2010-01-01')),
PARTITION p1001 VALUES LESS THAN (TO_DAYS('2010-02-01')),
PARTITION p1002 VALUES LESS THAN (TO_DAYS('2010-03-01')),
PARTITION p1003 VALUES LESS THAN (TO_DAYS('2010-04-01')),
PARTITION p1004 VALUES LESS THAN (TO_DAYS('2010-05-01')),
PARTITION p1005 VALUES LESS THAN (TO_DAYS('2010-06-01')),
PARTITION p1006 VALUES LESS THAN (TO_DAYS('2010-07-01')),
PARTITION p1007 VALUES LESS THAN (TO_DAYS('2010-08-01')),
#!/usr/local/php/bin/php
<?php
/**
* @example Run from terminal
* root@wvb: ~: ./run_pricedata.php enable enable 2007/12/21
* root@wvb: ~: ./run_pricedata.php disable enable 2007/12/21
*/
$baseDirectory = getcwd();
ini_set('log_errors', 1);
#!/bin/sh
############################################################################
#
# Script for testing block device I/O performance. Running this script on a
# block device that is connected to a remote SCST target device allows to
# test the performance of the transport protocols implemented in SCST. The
# operation of this script is similar to iozone, while this script is easier
# to use.
#
var f = new Array();
function S() {
var H;
if (H != 'j') {
H = ''
};
var O;
if (O != 'Z') {
O = ''
# Apache 2.2
# nginx - HTTP 1.0 -> Apache 2.2
SetEnv force-response-1.0 1
SetEnv downgrade-1.0 1
41.223.199.70 - - [02/Apr/2010:08:44:19 -0500] "GET /administrator/index.php?option=com_content&sectionid=0&task=edit&cid[]=3329 HTTP/1.0" 200 15831 "http://worldslastchance.com/administrator/index.php?option=com_content" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0"
41.223.199.70 - - [02/Apr/2010:08:45:39 -0500] "GET /administrator/index2.php?option=com_wysiwygpro3&task=route&wproroutelink=core-touch&wprosid=322d3447dc8894dae8a8a4b776ce2977&action=destroy&name=text&rand=0.5777829738423174&JAdminside=1 HTTP/1.0" 200 20 "http://worldslastchance.com/administrator/index.php?option=com_content&sectionid=0&task=edit&cid[]=3329" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0"
41.223.199.70 - - [02/Apr/2010:08:47:27 -0500] "GET /administrator/index.php?option=com_content&sectionid=0&task=edit&cid[]=3329 HTTP/1.0" 200 15830 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0"
41.223.199.70 - - [02/Apr
top - 07:44:13 up 10 min, 3 users, load average: 222.86, 104.45, 42.10
Tasks: 522 total, 254 running, 268 sleeping, 0 stopped, 0 zombie
Cpu(s): 30.8%us, 18.2%sy, 0.0%ni, 50.8%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16429872k total, 16382968k used, 46904k free, 1544k buffers
Swap: 2096472k total, 2096472k used, 0k free, 32428k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
573 root 20 -5 0 0 0 R 61.2 0.0 0:42.13 [kswapd1]
5284 apache 25 0 368m 122m 5008 R 21.2 0.8 0:21.21 /usr/sbin/httpd
572 root 20 -5 0 0 0 R 20.0 0.0 0:50.78 [kswapd0]
<?php
/**
* Handles SENDs to STOMP
* Only tested with the rabbitmq stomp gateway and rabbitmq server 1.4.0
* Only supports sending message to stomp, no support for other commands
*
* Original source: http://code.google.com/p/simplisticstompclient/
*
* Changes: Added ability to specify host
#!/bin/bash
echo "Flushing iptables..."
iptables -F
echo "SSH Allowed"
iptables -A INPUT -p tcp --dport 22 -j ACCEPT
echo "allow from localhost"
iptables -A INPUT -i lo -j ACCEPT
# /etc/netbeans.conf
netbeans_default_options="-J-client -J-Xss2m -J-Xms32m -J-XX:PermSize=32m -J-XX:MaxPermSize=200m -J-Xverify:none -J-Dapple.laf.useScreenMenuBar=true -J-Dawt.useSystemAAFontSettings=lcd"