harvey harveyqing

## Nginx - debug specified client.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                harveyqing
                / Nginx - debug specified client.md
            
            
              Last active
              March 31, 2018 03:00
            
              
                show how to debug specified clients in Nginx.
              
          
    e.g.
events {
    debug_connection 10.224.66.14;
    debug_connection 10.224.57.0/24;
}
P.S. --with-debug option should be on during configure phase

  
## gist:e4d133dbfa9626be070f6657a3ed9025
set debug option:

error_log path/to/err/log debug;

P.S. Should config the ``--with-debug`` option during configure phase.

## Re. match `2014-03-17 09:33:59` format like timestramp
import re

tp = re.compile(r'^(\d{4})-([1-9]|0[1-9]|1[0-2])-([1-9]|[1-2]\d|3[0-1]) (\d|0\d|1[0-2]|1\d|2[0-3]):(\d|[0-5]\d):(\d|[0-5]\d)$')

# can match string timestamps like below
# t1 = '3003-1-1 9:03:59

## All fields in a specified table
Syntax:

    mysql> SHOW FULL COLUMNS FROM DBname.table_name

Head description:
    Field ：field name
    Type：field type
    Collation：char set (above mysql 5.0）
    Null ：can be `NULL` of not
    Key：index（PRI,unique,index)

## dump & backup
* Export a whole database:
Syntax:

    mysqldump -u username -p [pwd] DBname > /path/to/backup

* Export a table in a specified database:
Syntax:

    mysqldump -u username -p [pwd] DBname table_name > /path/to/backup
	set debug option:

	error_log path/to/err/log debug;

	P.S. Should config the ``--with-debug`` option during configure phase.
	import re

	tp = re.compile(r'^(\d{4})-([1-9]\|0[1-9]\|1[0-2])-([1-9]\|[1-2]\d\|3[0-1]) (\d\|0\d\|1[0-2]\|1\d\|2[0-3]):(\d\|[0-5]\d):(\d\|[0-5]\d)$')

	# can match string timestamps like below
	# t1 = '3003-1-1 9:03:59
	Syntax:

	mysql> SHOW FULL COLUMNS FROM DBname.table_name

	Head description:
	Field ：field name
	Type：field type
	Collation：char set (above mysql 5.0）
	Null ：can be `NULL` of not
	Key：index（PRI,unique,index)
	* Export a whole database:
	Syntax:

	mysqldump -u username -p [pwd] DBname > /path/to/backup

	* Export a table in a specified database:
	Syntax:

	mysqldump -u username -p [pwd] DBname table_name > /path/to/backup