Archives

You are currently viewing archive for February 2008
Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
MySQL AB :: MySQL 5.1 Reference Manual :: 1.8.5 MySQL Differences from Standard SQL
1.8.5.1. SELECT INTO TABLE
1.8.5.2. Transactions and Atomic Operations
1.8.5.3. Stored Routines and Triggers
1.8.5.4. Foreign Keys
1.8.5.5. Views
1.8.5.6. '--' as the Start of a Comment
Category: Web dev
Posted by: hajime osako
MySQL AB :: MySQL Presentations: Optimizing MySQL

* SELECT SQL_BUFFER_RESULTS ...
Will force MySQL to make a temporary result set. As soon as the temporary set is done, all locks on the tables are released. This can help when you get a problem with table locks or when it takes a long time to transfer the result to the client.

* SELECT SQL_SMALL_RESULT ... GROUP BY ...
To tell the optimizer that the result set will only contain a few rows.

* SELECT SQL_BIG_RESULT ... GROUP BY ...
To tell the optimizer that the result set will contain many rows.

* SELECT STRAIGHT_JOIN ...
Forces the optimizer to join the tables in the order in which they are listed in the FROM clause.

* SELECT ... FROM table_name [USE INDEX (index_list) | IGNORE INDEX (index_list)] table_name2
Forces MySQL to use/ignore the listed indexes.
Category: Web dev
Posted by: hajime osako
Client Authentication with w3m
% openssl pkcs12 -cacerts -nokeys -in (PKCS#12型式ファイル) -out (PEM型式の「CA証明書ファイル」)
% openssl pkcs12 -clcerts -in (PKCS#12型式ファイル) -out (PEM型式の「クライアント証明書ファイル」)
FreeCAでWebサーバーのデジタル証明書を取得する
$ openssl pkcs12 -in loadcert.p12 -out certs.txt
Enter Import Password:
(FreeCAから証明書を取得したときのパスワードを入力します。)
MAC verified OK 
Enter PEM pass phrase:
(ここには秘密鍵を暗号化するパスワードを入力します。)
Verifying password - Enter PEM pass phrase:
$ openssl x509 -in certs.pem -noout -enddate
有効期限を確認する
Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako