2014-08-07 聚會手記
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';