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';
除非特別註明,本頁內容採用以下授權方式: Creative Commons Attribution-ShareAlike 3.0 License