■
-
-
- > Deactivating apache2 @2.2.14_1+darwin+preforkmpm
- > Deactivating apr @1.3.12_1
- > Deactivating apr-util @1.3.9_2
- > Deactivating autoconf @2.63_0
- > Deactivating autoconf213 @2.13_0
- > Deactivating automake @1.10.2_0
- > Deactivating bzip2 @1.0.5_3+darwin
- > Deactivating cclient @2007e_0
- > Deactivating curl @7.19.2_0
- > Deactivating cyrus-sasl2 @2.1.22_0+kerberos
- > Deactivating db46 @4.6.21_6
- > Deactivating expat @2.0.1_0
- > Deactivating flex @2.5.35_0
- > Deactivating fontconfig @2.6.0_1+macosx
- > Deactivating freetype @2.3.12_0+macosx
- > Deactivating gawk @3.1.6_0
- > Deactivating gettext @0.17_3
- > Deactivating giflib @4.1.6_1
- > Deactivating glib2 @2.18.3_0+darwin_9
- > Deactivating gperf @3.0.4_0
- > Deactivating help2man @1.36.4_1
- > Deactivating ImageMagick @6.4.7-2_0+q16
- > Deactivating jpeg @7_0
- > Deactivating libexif @0.6.17_0
- > Deactivating libgdiplus @2.0_1
- > Deactivating libiconv @1.13.1_0
- > Deactivating libmcrypt @2.5.8_1
- > Deactivating libpng @1.2.42_0
- > Deactivating libtool @1.5.26_0
- > Deactivating libxml2 @2.7.6_0
- > Deactivating libxslt @1.1.26_0
- > Deactivating m4 @1.4.13_0
- > Deactivating mhash @0.9.9.9_0
- > Deactivating mod_python25 @3.3.1_1
- > Deactivating mysql5 @5.1.44_0
- > Deactivating ncurses @5.7_0
- > Deactivating ncursesw @5.7_0
- > Deactivating neon @0.28.3_0
- > Deactivating openssl @0.9.8l_0+darwin
- > Deactivating p5-locale-gettext @1.05_0
- > Deactivating p7zip @9.04_0
- > Deactivating pcre @7.9_0
- > Deactivating perl5 @5.8.9_0
- > Deactivating perl5.8 @5.8.9_3
- > Deactivating pkgconfig @0.23_1
- > Deactivating py25-bsddb @2.5.2_1
- > Deactivating py25-genshi @0.5_0
- > Deactivating py25-hashlib @2.5.2_0
- > Deactivating py25-pygments @1.0_0
- > Deactivating py25-setuptools @0.6c9_0
- > Deactivating py25-sqlite3 @2.5.2_0
- > Deactivating py25-zlib @2.5.2_0
- > Deactivating python25 @2.5.2_7+darwin_9
- > Deactivating readline @6.1.000_1+darwin
- > Deactivating render @0.9.2_0
- > Deactivating serf @0.3.0_0
- > Deactivating sqlite3 @3.6.22_0
- > Deactivating subversion @1.5.4_0+mod_dav_svn
- > Deactivating subversion-python25bindings @1.5.4_0
- > Deactivating tiff @3.9.2_2+macosx
- > Deactivating trac @0.11.2.1_0
- > Deactivating XFree86 @4.7.0_0+macosx
- > Deactivating xorg-bigreqsproto @1.1.0_0
- > Deactivating xorg-inputproto @2.0_0
- > Deactivating xorg-kbproto @1.0.4_0
- > Deactivating xorg-libice @1.0.6_0
- > Deactivating xorg-libsm @1.1.1_0
- > Deactivating xorg-libX11 @1.3.3_0
- > Deactivating xorg-libXau @1.0.5_0
- > Deactivating xorg-libXdmcp @1.0.3_0
- > Deactivating xorg-libXext @1.1.1_0
- > Deactivating xorg-renderproto @0.11_0
- > Deactivating xorg-util-macros @1.6.0_0
- > Deactivating xorg-xcmiscproto @1.2.0_0
- > Deactivating xorg-xextproto @7.1.1_0
- > Deactivating xorg-xf86bigfontproto @1.2.0_0
- > Deactivating xorg-xproto @7.0.16_0
- > Deactivating xorg-xtrans @1.2.5_0
- > Deactivating xrender @0.9.5_0
- > Deactivating zlib @1.2.3_4
-
UsuiMacBookAir:~ usui$ sudo port d
■
フラッシュジェネレータはつくれないのか?
swfreplacer
http://www.moongift.jp/2009/12/swfreplacer/#more-19498
swfmill swf2xml and xml2swf
http://swfmill.org/
http://www.moongift.jp/2007/12/swfmill/#more-5421
http://www.plusmb.jp/2008/12/05/1510.html
■
MySQL FULLTEXT + Ngram : LIKE検索より数十倍高速な、お手軽 日本語全文検索 について
UTF8じゃないとカナかなできなくない?
http://www.tatamilab.jp/rnd/archives/000390.html
http://www.tatamilab.jp/rnd/archives/000389.html#l
■
パーティションはハッシュで
これでいいんじゃない?
http://dev.mysql.com/doc/refman/5.1/ja/partitioning-overview.html
CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE)
ENGINE=INNODB
PARTITION BY HASH( MONTH(tr_date) )
PARTITIONS 6;
■
mysql複数起動するには
my.cnfに数字と下記を指定
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
[mysqld2]
port = 3308
socket = /opt/local/var/run/mysql5/mysqld2.sock
pid-file = /opt/local/var/db/mysql5.2/UsuiMacBookAir.local.2.pid
datadir = /opt/local/var/db/mysql5.2
server-id = 2
権限付与
GRANT SHUTDOWN ON *.* TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass';
手動起動
/opt/local/lib/mysql5/bin/mysqld_safe --defaults-file=/private/etc/my.2.cnf
× sudo /opt/local/lib/mysql5/bin/mysqld_multi start 1,2&
/opt/local/lib/mysql5/bin/mysqld_multi start 1,2
※権限の関係でsudoで起動しても上手くいかないので
/opt/local/var/db/mysql5/
/opt/local/var/run/mysql5/
のパーミッションをさげてみたら起動はした感じ
http://www.kimura-lab.net/wiki/index.php/MySQLサーバ複数起動メモ
で結果my.cnf の設定を無視して同じポートで起動しちゃう感じ
直接mysqldで起動したら一応動くけど...
/opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5.2 --user=mysql --pid-file=/opt/local/var/db/mysql5.2/UsuiMacBookAir.local.pid --port=3308 --socket=/opt/local/var/run/mysql5/mysqld2.sock
/opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=mysql --pid-file=/opt/local/var/db/mysql5/UsuiMacBookAir.local.pid --port=3306 --socket=/opt/local/var/run/mysql5/mysqld.sock
/opt/local/lib/mysql5/bin/mysql -u root -p --protocol=SOCKET --socket=/opt/local/var/run/mysql5/mysqld.sock
/opt/local/lib/mysql5/bin/mysql -u root -p --protocol=SOCKET --socket=/opt/local/var/run/mysql5/mysqld2.sock
mysqladmin5 -u root -p --protocol=SOCKET --socket=/opt/local/var/run/mysql5/mysqld.sock shutdown
mysqladmin5 -u root -p --protocol=SOCKET --socket=/opt/local/var/run/mysql5/mysqld2.sock shutdown