ϡɥǥƥʥ ֥

ϡɥǥοǡʪեޥåȡŲLinuxСMySQLʤɤᥤäΤǤθ幭ꡢϡɥƤƤޤ ХǥХϡMacBookAir(13)iPad Air2ݥ DM100(󥰥)OLYMPUS STYLUS XZ-2ʤɡ Ȥʤ顢֥򹹿Ƥޤ

2013ǯ12






˥ΰǥ륫ѤΥХåƥ꡼ǤEN-EL15θߴ줿

EN-EL15ν()ȸߴ()
EN-EL15ν()ȸߴ()



鵡ǤD7000ǻѤ롣

³ɤ



[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

Υȥ꡼ϤƤʥ֥åޡɲ mixiå Share on Tumblr Clip to Evernote






ϥѥեޥ MySQL 3פ



ޥ󤫤Ȣ...
ޥ󤫤Ȣ...

ҡ
ҡ

 ϥѥեޥ MySQL(3)
ϥѥեޥ MySQL(3)

3
3

2013ǯ1122 1ȯ
2013ǯ1122 1ȯ

Ѥ餺...
Ѥ餺...

DBϡǡʤ֤ʤưƤưCPU100%ˤʤäƤ롣



ѥեޥ󥹤ͤSQLʸ񤫤ͤФʤʤ

ϥѥեޥMySQL 3
ϥѥեޥMySQL 3
posted with amazlet at 14.03.03
Baron Schwartz Peter Zaitsev Vadim Tkachenko
饤꡼ѥ
夲󥭥: 56,487
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

Υȥ꡼ϤƤʥ֥åޡɲ mixiå Share on Tumblr Clip to Evernote






MySQLǤΥɸOFFʤΤǡͭˤ롣

ޤ

/etc/mysql/my.conf (Debian)

򳫤Խ

ͥ(̥)

# general_log_file = /var/log/mysql/mysql.log
# general_log = 1

Ƭ#򳰤



# Here you can see queries with especially long duration
# log_slow_queries = /var/log/mysql/mysql-slow.log
# long_query_time = 2

Ԥ#򳰤

Խ塢MySQLߡƳ

sudo /etc/init.d/mysql restart

ȡ

Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.

ɽ졢MySQLƵư졢꤬ȿǤ롣

嵭Ǽ

/var/log/mysql/mysql.log
/var/log/mysql/mysql-slow.log

ˡե뤬Ƥ뤳Ȥǧ롣

ϡlong_query_timeǻꤷְʾξ˵ϿΤǡ꤬ʤϵϿʤ
ͥ쵭ϿΤǡMySQLβƯ¿ȥˤʤΤա



# Time: 131225 23:30:00
# User@Host: root[root] @ localhost []
# Query_time: 2.941743 Lock_time: 0.000372 Rows_sent: 362 Rows_examined: 7138142
use test;
SET timestamp=1387952279;

ѡȤΤMySQL[+]ȥ֥륷塼ƥ󥰥

ɾ
夲󥭥: 14,492
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

Υȥ꡼ϤƤʥ֥åޡɲ mixiå Share on Tumblr Clip to Evernote






ӤƤ MINOLTA AF 100mm F2.8 Macro Ǥλơ


900(DSLR-A900)
900(DSLR-A900)DSLR-A900(ե륵ǥ)


ICF-38
ICF-38ICF-38(ˡFM/AM饸,ƹ)Υӥ塼


ICF-38
ICF-38


ڻ
ڻ


Τᤫ򤯥ܥ䤱뤳ȤϤǤ̡

âǤꡢԥȥ󥰤辯ʤΤǡMFˤˤ

ˡκǿ(4)ǤСԥȥ󥰤ʤäƤꡢMFϲäƤ롣

[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

Υȥ꡼ϤƤʥ֥åޡɲ mixiå Share on Tumblr Clip to Evernote






ޡȥեбޥդإåɥۥǤJVC󥦥å JVC ƥ쥪ߥ˥إåɥۥ ֥롼 HA-FR8-A(JVC󥦥å)פꤷ



HA-FR8-A(JVC󥦥å)
HA-FR8-A(JVC󥦥å)

ޡȥեб
ޡȥեб

֥ޡȥեбפȤΤϡںߡåסáǽ⥳դƤȤȡ

ʪ
ʪ

⥳ȤäƤ⡢ܥ1Ĥ

ޥ()ȥܥ
ޥ()ȥܥ

ܥ򲡤ĹʬΤ

ɤĹϡ1.2m

°ʤϡ

䡼ԡ(SML)ȥɥѡ
䡼ԡ(SML)ȥɥѡ

ɥѡؤδϡ˽񤤤Ƥ뤬...

(Ŭ)
(Ŭ)

ޡȥեбʤΤǡ̤ΥإåɥۥΤ褦3ˤǤϤʤ4ˤ͡

4
4

iPhone5
iPhone5

L¦ˤ͵
L¦ˤ͵

μΥإåɥۥϥԥ󤫤饭ޤǤ뤬餫˥()ͣ

ˤΤʤ顢ä衣



ʪ򤤤äƤ⡢ɤʤʤ
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

Υȥ꡼ϤƤʥ֥åޡɲ mixiå Share on Tumblr Clip to Evernote

ΥڡΥȥåץ