如何移除並取消 MySQL 的 binary log 檔案

o MySQL 的 binary log 檔案佔了磁碟很多的空間

在例如 /var/lib/mysql/ 目錄可能會發現不少 MySQL 的 binary log 檔案:
-rw-rw—- 1 mysql mysql 29662 Aug 6 23:53 mysql-bin.000001
-rw-rw—- 1 mysql mysql 1055243 Aug 6 23:53 mysql-bin.000002
-rw-rw—- 1 mysql mysql 1073790447 Aug 7 00:42 mysql-bin.000003
-rw-rw—- 1 mysql mysql 1074547174 Aug 7 01:30 mysql-bin.000004
-rw-rw—- 1 mysql mysql 1074351847 Aug 7 01:54 mysql-bin.000005
-rw-rw—- 1 mysql mysql 1074535688 Aug 7 02:01 mysql-bin.000006
-rw-rw—- 1 mysql mysql 1074495922 Aug 7 02:07 mysql-bin.000007
-rw-rw—- 1 mysql mysql 1074497579 Aug 7 02:13 mysql-bin.000008
-rw-rw—- 1 mysql mysql 147849819 Aug 7 17:21 mysql-bin.000009

這些檔案可以佔住了磁碟很多的空間。

這一篇要說明如何正規方式移除這些檔案,並改寫 my.cnf 設定組態不去記錄這些二進位日誌檔案。 Continue reading “如何移除並取消 MySQL 的 binary log 檔案”

將載入Google Plus One的JavaScript改寫成非同步載入寫法

原有的 Google Plus One (G+) 的同步載入 JavaScript 寫法假設是:

<script type=”text/javascript” src=”https://apis.google.com/js/plusone.js”>
{lang: ‘zh-TW’}
</script>

改寫成非同步載入寫法後變成這樣:

<script type=”text/javascript”>
window.___gcfg = {lang: ‘zh-TW’};
(function() {
var po = document.createElement(‘script’); po.type = ‘text/javascript’; po.async = true;
po.src = ‘https://apis.google.com/js/plusone.js’;
var s = document.getElementsByTagName(‘script’)[0]; s.parentNode.insertBefore(po, s);
})();
</script>

安裝Google Applicaiton Engine(GAE)開發環境

Install the development environment of Google Applicaiton Engine (GAE)

1. Install Python
2. Install GoogleAppEngine-1.5.4.msi (Download from http://code.google.com/intl/zh-TW/appengine/downloads.html)
3. Install eclipse for java Developer (maybe install the jre-7-windows-x64.exe)
4. Run eclipse.exe Continue reading “安裝Google Applicaiton Engine(GAE)開發環境”