chihchun

chihchun

https://www.pushbullet.com/apps

Learn python

程式語言教學誌: Python 教材 <http://pydoing.blogspot.com/2012/10/python-tutorial.html>  

松鼠博士的魔法眼鏡: 關於 checkio.org <http://weijr-note.blogspot.com/2012/12/checkio.html>  

Welcome :: CheckiO <http://www.checkio.org/>  

samuel

Celery - Distributed Task Queue http://www.celeryproject.org/

ZODB - a native object database for Python http://www.zodb.org/en/latest/

yan

SHODAN - Computer Search Engine http://www.shodanhq.com/

JD-GUI - Java Decompiler http://jd.benow.ca/

MySQL partition

partition type

  • range
  • list
  • hash
  • key

create partition

ALTER TABLE tbl partition by range(`day`) (
   partition p_2012 values less than (20130000),
   partition p_2013 values less than (20140000)
 );

show partitions in database

SELECT  TABLE_NAME, PARTITION_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = 'db_name' ;

show partition type

SHOW CREATE TABLE tbl_name;

show table partition size

SELECT PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD
       FROM information_schema.PARTITIONS 
       WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tbl_name';