ϡɥǥƥʥ ֥

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

2014ǯ01






ٿReadyNAS 104(RN10400-100AJS)η

ԡϸ塢Ф餯20MB/s餤ФƤΤɥɥ®٤㲼Τޤ֤ȡ

ReadyNAS 104,RN10400-100AJS,ԡ,٤

ReadyNAS 104,RN10400-100AJS,ԡ,٤

Ĥ֡559֣

0.4MB/s

ǡлȤȤ®٤㲼ƤΤǡ֤ФĤˤĤĤ֤ä櫣

NASή

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

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






ѥεưˡ

APSDaemon.exe - ݡͥȤĤޤ

Ȥ顼и

APSDaemon.exe - ݡͥȤĤޤ

-----

APSDaemon.exe - ݡͥȤĤޤ

MSVCR80.dll ĤʤäᡢΥץꥱ򳫻ϤǤޤǤ
ץꥱ򥤥󥹥ȡ뤷ľȤϲ褵礬ޤ


OK

-----

Ƥ

ץꥱ򥤥󥹥ȡ뤷ľȤϲ褵礬ޤ

Ȥ뤬Υץ꤫Ǥꡢ顼̤ΰ̣ʤʤ

ǡΥ顼ɤiTunesΤ褦͡

СiTunesUpdateդˤꡢԤä롣

Apple Software Update
Apple Software Update

ˡϡiTunesκƥ󥹥ȡ뤫Ȼפ뤬Ǥ褷ʤȤ롣

ξϡiTunesϢΥեȡŪˤ

iTunes
Apple Software Update
Apple Mobile Device Support
Bonjour
Apple Application Support

iTunesƥ󥹥ȡ뤹Ф褤(iTunesʳ4ĤդƤ)

ˤϡiTunesưƥ󥹥ȡǤʤ
ޤϺƥ󥹥ȡ뤬ǤƤiTunesưʤ
iTunesϢΥեȤԤ褷Ȥ롣

AppleΥץϡWindowsǤϡ͡

iCloud԰iTunesUpdate⡢β̤UpdateԤȡʤ٤ǼԤ(Υ顼)

԰ꢪWinMacذܹԡȤǤ뤫()
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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






ե륵С(Atom)NETGEARNASǤReadyNAS 104(RN10400-100AJS)˥ե뷲(500GB)򥳥ԡȽ®٤0.3MB/sȤʤ꽪λޤ250֤ȤեȤˤʤ񤤤

Atom顢̤Windowsޥ³ϡɥǥ(USB2.0³)Ʊե뷲򥳥ԡȡ1ǽλ櫡

ϤĤޤꡢReadyNAS 104(RN10400-100AJS)ȤȤˤʤΤ

-----

Τޤ֤ȡɾˣ

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

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






key_buffer_sizeȤϡindexξ

줬ǥեȤǤ8MBȾΤǡĴ롣

# ϡɥˤʤäȤ⤤롣

ޥɤrootǥ

MySQL˥

mysql -u root -p

MySQL˥󤹤ݤΥѥɤϭΥΤǡ

key_buffer_sizeͤĴ٤

show variables like 'key_buffer_size' ;

+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| key_buffer_size | 16777216 |
+-----------------+----------+
1 row in set (0.00 sec)

λ/etc/mysql/my.cnfεҤ

key_buffer = 16M

ȤʤäƤ롣

MySQLΥСˤäơkey_buffer_sizeȤʤäƤ뤳Ȥ⤢롣

ڤ

16,777,216(bytes)

ʤΤǡ

16(M)777(K)216(bytes)

Ǥꡢ16MB

ȤȤϡmy.cnfεҤǡ16MפȤɽOK

my.cnf񤭴Upload롣

key_buffer = 512M

MySQLȡ

mysql > exit

MySQLƵư롣

/etc/init.d/mysql restart

ٰʲͤǧ롣

show variables like 'key_buffer_size' ;

+-----------------+-----------+
| Variable_name | Value |
+-----------------+-----------+
| key_buffer_size | 536870912 |
+-----------------+-----------+
1 row in set (0.00 sec)

536,870,912(bytes)

536(M)870(K)912(bytes)

ʤˤʤäƤĶǤϡ512MˤƤ1M(1,048,576bytes)ˤƤѲϤʤä

¾䡢SQLʸθľʤɬפˤʤ롣

Ȥꤢ256M(268,435,456bytes)ˤƤ

ޤ礭᤮ȥΤǡDebianüܤ̤γǧˡˤǧξ塢Ṳ̆꿶

ϥѥեޥ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] Ӥո٤ΤBETWEENDz

datetime(reg_time)ơ֥Фǯ򤫤ƥǡФ

datetime㡧2014-01-01 12:34:56

SELECT * FROM `ơ֥̾` WHERE `reg_time` LIKE '2014-01-01%'

٤

reg_timeindexꤷƤ⡢indexѤʤΤ̵̣

鿴Ԥ¿ѤLIKEʤ󤫻Ȥ衪ȤȤǡdateȤ

datedatetime(2014-01-01 12:34:56)ǯ(2014-01-01)Фؿ

SELECT * FROM `ơ֥̾` WHERE date(`reg_time`) = '2014-01-01'

Ʊͤ٤(indexѤʤ)

βˡϡBETWEENѤ뤳ȤǤ롣

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '2014-01-01 00:00:00' AND '2014-01-01 23:59:59'

ˤꡢ®ǽ

EXPLAINư򸫤ȡtypeallrangeˤʤäƤ뤳Ȥʬ롣

typeϡơ֥ФƤɤΤ褦ˡǥΤ򼨤Ρ

allեơ֥륹ǡǥåѤƤʤȤɽǰʥ

rangeϡǥåѤϰϸǤ롣

2014ǯ11λü(00:00:00)Ƚü(23:59:59)ꤷδ(BETWEEN)ȤСƱΤSELECTǤBETWEENǤΤʬ롣

ޤϤǤ褤Ȥơǯ(ʤ)ξϤɤ

νפȤ͡



SELECT * FROM `ơ֥̾` WHERE `reg_time` LIKE '2014-01-%'

٤Ʊͤ

SELECT * FROM `ơ֥̾` WHERE LEFT(`reg_time`,'7') = '2014-01'



SELECT * FROM `ơ֥̾` WHERE LEFT(`reg_time`,'8') = '2014-01-'

LEFT(`reg_time`,'7')ϡreg_timeκ7ʸФĤޤǯ-ؿ

٤

Ȥʤȡ®ͤΤBETWEENȤʤ뤬ξϽü23:59:59Ƿޤ뤬ξνüϤɤ뤫

üϡˤäưۤʤ

ޤȻפä

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '2014-01-01 00:00:00' AND '2014-01-32 23:59:59'

Ȥ...

顼ˤϤʤʤ֤줿̤0ȤʤꡢԲģ

32¸ߤʤ

Ȥʤȡηκǽ(,)ʤФʤʤ

PHPǤС

cal_days_in_month(CAL_GREGORIAN,$month,$year)

Ȥؿ(ǯȷν)

ϷؿǤϤʤǯ($hikazu)Τ

ʬȤȤϡǽ($last_day)

$hikazu = cal_days_in_month(CAL_GREGORIAN,$month,$year) ;

$last_day = $year."-".sprintf("%02d",$month)."-".sprintf("%02d",$hikazu) ;

ȤƵΤǡ

$from = $year."-".sprintf("%02d",$month)."-01 00:00:00" ;

$to = $last_day." 23:59:59" ;

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '$from' AND '$to'

ȤФ褤

ޤMySQL/ؿlast_dayȤΤ롣

ϡͿǯη(ǯ)֤

last_day('2014-01-01') 2014-01-31

Ȥȡ

$from = $year."-".sprintf("%02d",$month)."-01" ;

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN CONCAT('$from',' 00:00:00') AND CONCAT(last_day('$from'),' 23:59:59')

Ȥ뤳ȤǤ롣

BETWEENȤȹ®ǤΤʬ뤬ɤĹʤľŪǤʤޡȤʤ...

-----

`reg_time`ˤϥߥäϳǼƤʤΤǡ23:59:59.xäϰϳˤʤ뤳ȤϤʤ

-----

BETWEEN '2014-01-01' AND '2014-01-01' + interval 1 day ;

Ȥû񤱤褦˻פ뤬 2014-01-02 00:00:00 ޤΤǡŬǤ롣

INTERVALξüޤͤ

ºݤ˻Ƥߤ롣

ʲΤ褦ʥơ֥뤬ꡢ(reg_time)˰ʲǼƤ롣

2014-01-01 23:59:59
2014-01-02 00:00:00
2014-01-02 00:00:01
2014-01-02 00:00:02

Ф

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '2014-01-01 00:00:00' AND '2014-01-01 23:59:59' ;

ꤲȡ̤

2014-01-01 23:59:59

1郎֤뤬

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '2014-01-01' AND '2014-01-01' + INTERVAL 1 day ;

ꤲȡ̤

2014-01-01 23:59:59
2014-01-02 00:00:00

Ȥʤꡢ2֤Ƥޤ

+ INTERVAL 1 dayǤϡ

2014-01-02 00:00:00(00:00:00)

ޤޤƤޤΤǥȡ

ǡˡ00:00:00פϿƤ뤫ϤεϿ٤ˤ뤬ȯǴޤޤƤʤСʥáפƥȤ̤äƤޤͤʤ()

ǡѳϸ塢00:00:00פϿ졢פˡ֥ʡפȤʤ롣

ʤ顢

SELECT * FROM `ơ֥̾` WHERE `reg_time` BETWEEN '2014-01-01' AND '2014-01-01' + INTERVAL 1 day - INTERVAL 1 SECOND ;

Ƚ񤱤ФɤʤΤϥ(SILANE)

Ϣ[MySQL] Ӥո٤ΤBETWEENDz

MySQLǽХ֥ ~ΩAtoZ~
MySQLǽХ֥ ~ΩAtoZ~
posted with amazlet at 14.06.01

ɾ
夲󥭥: 199,175


ϥѥեޥ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

ΥڡΥȥåץ