Monster Oasis

http://schemaspy.sourceforge.net/

sample : http://schemaspy.sourceforge.net/sample

Share on Facebook

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 , w.*
FROM  wp_posts  p , wp_term_relationships tr , wp_term_taxonomy t ,  wp_terms w
where p.id=tr.object_id
and tr.term_taxonomy_id=t.term_taxonomy_id
and t.term_id = w.term_id
order by p.id desc

Share on Facebook

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

2009.0630 發現 wordpress code 裡面有用到 token_get_all ( tokenizer 所以不能取消)

Share on Facebook

http://www.oracle.com/pls/db111/homepage

Share on Facebook

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\" , \"%{User-agent}i\"" MTS_format
CustomLog "| /usr/sbin/cronolog /var/www/ts.monster.com.tw/log/access-%Y%m%d%H.log" MTS_format env=MTS_icon

引用例:

然後 apache log 會長這個樣子:

寫一段 PHP code:

$fp = fopen($mts_logfile,"r");

while ( $temp = fgetcsv($fp,$max_size)  ) {
  if ( count($temp)<1 ) continue;
  print_r($temp);
}
fclose($fp);

結果就類似這樣:

再來就是處理 [3] 那邊的各種 data …

Share on Facebook

參考: 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 參考表
(用 MEDIUMINT 3bytes 比 INT 4bytes 好 , 若資料內容不可能有負值那加上 UNSIGNED , 則數值範圍可多一倍!)

Share on Facebook

Share on Facebook

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 last_name and first_name. Therefore, the name index is used in the following queries:

SELECT * FROM test WHERE last_name='Widenius';

SELECT * FROM test
  WHERE last_name='Widenius' AND first_name='Michael';

SELECT * FROM test
  WHERE last_name='Widenius'
  AND (first_name='Michael' OR first_name='Monty');

SELECT * FROM test
  WHERE last_name='Widenius'
  AND first_name >='M' AND first_name < 'N';

However, the name index is not used in the following queries, 以下的 query 用不到 index —> 多重 index 有先後區別.

SELECT * FROM test WHERE first_name='Michael';

SELECT * FROM test
  WHERE last_name='Widenius' OR first_name='Michael';

Share on Facebook

Share on Facebook

照這樣看, 不到 3000公尺呀??

今天游了 1小時8分 , 比去年快6分, 聽說今天海流是順的, 而且水母不多…

這是今天的路徑圖

Share on Facebook

Share on Facebook

Share on Facebook

Share on Facebook

Share on Facebook

官網資料 : http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_aqadm.htm#i1015375

The DBMS_AQADM package provides procedures to manage Oracle Streams Advanced Queuing (AQ) configuration and administration information.

See Also:

• Oracle Streams Advanced Queuing User’s Guide and Reference

• Chapter 185, "Oracle Streams AQ TYPEs" for information about the TYPEs to use with DBMS_AQADM

This chapter contains the following topics:

• Using DBMS_AQADM

  • Constants

• Subprogram Groups

  • Queue Table Subprograms

  • Privilege Subprograms

  • Queue Subprograms

  • Subscriber Subprograms

  • Notification Subprograms

  • Propagation Subprograms

  • Oracle Streams AQ Agent Subprograms

  • Alias Subprograms

• Summary of DBMS_AQADM Subprograms

Share on Facebook

Share on Facebook

看看它的各章節, 也許可以知道 DBA 的工作是什麼

http://www.amazon.com/Oracle-Applications-Field-Guide-Experts/dp/1590596447/ref=sr_1_1?ie=UTF8&s=books&qid=1244462254&sr=1-1

Ch1. Components and Architecture of Oracle Applications
Ch2. Configuration
Ch3. Monitoring and Troubleshooting
Ch4. Performance Tuning
Ch5. Patching
Ch6. Toolkit
Ch7. Resources

另外, 這邊有一位真正的 Oracle DBA : http://blog.xuite.net/charley_ocp/mydba01

Share on Facebook

Share on Facebook

全國共有99個車隊組團參加，比賽車友有720人, 比賽起程路線從(樂水運動場)到(見晴觀景臺)，沿途連續上坡全長28公里，更從海拔300公尺爬升到標高1900公尺, 競賽分為公路車組、登山車組兩大組別，公路車組限使用彎把公路車，登山組限使用平把車，另外還開放推廣組…

▍活動日期： 98年6月7日（星期日）
▍集合地點：樂水(樂水運動場)（集合、出發及頒獎點）
▍比賽路線：宜51線(樂水運動場)轉宜專1線至見晴觀景台，沿途連續上坡全長28公里(自海拔300公尺起爬升至標高1900公尺)。
▍路線概況：活動自樂水運動場出發，沿太平山公路前進，沿途連續上坡23公里（自海拔300公尺起爬升至標高1900公尺），途中於14.5公里處（白嶺）設飲水及食物補給站，到終點後憑號碼牌至起點換「餐點」。

一路都被超…

當時還有些力氣…自拍一下…

一路風景不錯 … 只是爬坡很辛苦 … 通常就是一個轉彎後就是一個陡坡

這是整場的路徑/時間圖 , 落後太多了….得要好好的練 bike 了 …

Share on Facebook

Share on Facebook