計算MySQL可能用到的記憶體數量

參考: http://dev.mysql.com/doc/refman/5.0/en/memory-use.html

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW VARIABLES LIKE 'innodb_additional_mem_pool_size';
SHOW VARIABLES LIKE 'innodb_log_buffer_size';
SHOW VARIABLES LIKE 'thread_stack';
SET @kilo_bytes = 1024;
SET @mega_bytes = @kilo_bytes * 1024;
SET @giga_bytes = @mega_bytes * 1024;
SET @innodb_buffer_pool_size = 2 * @giga_bytes;
SET @innodb_additional_mem_pool_size = 16 * @mega_bytes;
SET @innodb_log_buffer_size = 8 * @mega_bytes;
SET @thread_stack = 192 * @kilo_bytes;
SELECT
( @@key_buffer_size + @@query_cache_size + @@tmp_table_size
+ @innodb_buffer_pool_size + @innodb_additional_mem_pool_size
+ @innodb_log_buffer_size
+ @@max_connections * (
@@read_buffer_size + @@read_rnd_buffer_size + @@sort_buffer_size
+ @@join_buffer_size + @@binlog_cache_size + @thread_stack
) ) / @giga_bytes AS MAX_MEMORY_GB;

點選按鈕提示IE9釘選功能

<script type="text/javascript">
function addSite() {
    try{
        window.external.msAddSiteMode();
    }catch(e){
        alert("此功能僅適用於 Internet Explorer 9.");
    }
}
</script>
<button onclick="addSite();">釘我</button>



andorid模擬器轉橫向

mac裡跑android模擬器如果要轉橫向測試
fn+control+F12

IE9釘選功能

<META name="msapplication-task" content="name=標題;action-uri=網址;icon-uri="/>

css3 翻轉效果


#logo {width:200px; height:64px; background:url('../images/logo.png') top left no-repeat;
     -webkit-animation-name: y-spin;
     -webkit-animation-duration: 2s;
     -webkit-animation-iteration-count: 1;
     -webkit-animation-timing-function: linear;
 }
 @-webkit-keyframes y-spin {
     0% { -webkit-transform: rotateY(0deg); }
     50% { -webkit-transform: rotateY(180deg); }
     100% { -webkit-transform: rotateY(360deg); }
 }

mac os 更新 dns cache

Terminal 下指令
# dscacheutil -flushcache

透過google map由地址查詢經緯度

參考文件 http://code.google.com/intl/zh-TW/apis/maps/documentation/javascript/v2/services.html

測試 http://maps.google.com/maps/geo?q=%E5%8F%B0%E5%8C%97%E5%B8%82%E5%8D%97%E6%B8%AF%E5%8D%80%E4%B8%89%E9%87%8D%E8%B7%AF66%E8%99%9F&output=json&sensor=true

回傳

{ "name": "台北市南港區三重路66號", "Status": { "code": 200, "request": "geocode" }, "Placemark": [ { "id": "p1", "address": "115台灣台北市南港區三重路66號", "AddressDetails": { "Accuracy" : 8, "Country" : { "AdministrativeArea" : { "AdministrativeAreaName" : "台北市", "Locality" : { "DependentLocality" : { "DependentLocalityName" : "三重里", "PostalCode" : { "PostalCodeNumber" : "115" }, "Thoroughfare" : { "ThoroughfareName" : "三重路66號" } }, "LocalityName" : "南港區" } }, "CountryName" : "台灣", "CountryNameCode" : "TW" } }, "ExtendedData": { "LatLonBox": { "north": 25.0587660, "south": 25.0560680, "east": 121.6156030, "west": 121.6129050 } }, "Point": { "coordinates": [ 121.6142540, 25.0574170, 0 ] } } ] }