wordpress 的 schema

ver 2.7: 幾個查詢例: SELECT m.* FROM wp_posts p , wp_postmeta m where p.id=m.post_id order by post_id desc SELECT tr.* FROM wp_posts p , wp_term_relationships tr where p.id=tr.object_id order by p.id desc SELECT p.id , w.* FROM wp_posts p , wp_term_relationships tr , wp_term_taxonomy t where p.id=tr.object_id and tr.term_taxonomy_id=t.term_taxonomy_id order by p.id desc SELECT p.id , … Read more

gentoo emerge php options

2009.0630 Monster LAMP Pack: 取消 : ncurses pdo readline spell 增加 : ctype json sockets berkdb gdbm xmlreader xmlwriter oci8-instant-client USE=”apache2 berkdb bzip2 calendar cjk cli crypt ctype curl gd gdbm hash iconv json mysql mysqli nls oci8-instant-client pcre reflection session simplexml sockets spl ssl tokenizer truetype unicode xml xmlreader xmlwriter zlib” emerge -av php … Read more

Simple Monster Tracking System – step by step

mts.js , 網上範例很多 , 這個是基本型: 這段 code 前面就是一連串的組出 z 變數(包括 OS , BROWSER , SCREEN WIDTH/HEIGHT …) , 然後用一個小點透過 apache 的 log 記錄下來. 這個 apache 要裝 mod_setenvif 或 mod_rewrite modules , 在 apache config 中設定 只 log 特定的 tracking data. SetEnvIf Request_URI /dot.gif MTS_icon LogFormat "%{%Y-%m-%d}t , %{%H:%M:%S}t , %a , \"%q\" , \"%{Referer}i\" , … Read more

MySQL – Optimizing Database Structure

參考: http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html 7.4.1. Make Your Data as Small as Possible 7.4.2. Column Indexes 7.4.3. Multiple-Column Indexes 7.4.4. How MySQL Uses Indexes 7.4.5. The MyISAM Key Cache 7.4.6. MyISAM Index Statistics Collection 7.4.7. How MySQL Opens and Closes Tables 7.4.8. Disadvantages of Creating Many Tables in the Same Database 減少 record structure 的大小 – Numeric Types … Read more

mysql index 的建立/使用 , Multiple-Column Indexes

http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), INDEX name (last_name,first_name) ); The name index is an index over the last_name and first_name columns. The index can be used for queries that specify values in a known range for last_name, or for both … Read more