ϡɥǥƥʥ ֥

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

ƥꡧ Linux






2߰ʲη¥СҲ𤷤褦

ٻ PRIMERGY MX130 S2

PRIMERGY MX130 S2

19,800ߤ2,000߰ݥѤ17,800ߡ

߸˶Ͼ

OS쥹פʬLinux뤫פ͡

CPU꡼ϡɥǥ(250GB)DVD-ROMɥ饤֤ܤäƤ뤫顢ȤLinuxƤƥ󥹥ȡ뤹

¥СϥȾɤƤˤʤ롣

桢෿֤ǽʥСϥ͡

ܤNASΥС⤢衣

HP ProLiant MicroServer Turion II NEO N5

HP ProLiant MicroServer Turion II NEO N5

16,980ߤ1,000߰ݥѤ15,980ߡ

߸˶Ͼ

CPU꡼ϡɥǥ(500GB)Ϥ뤬إɥ饤֤ʤΤѰդ뤫USB꡼饤󥹥ȡ뤹Ф褤

Linuxƥե륵СˤƤ襷MySQLDBγؽѤˤƤ襷

Сδϡϡɤޤ᤿μɬǤȡϹͤƤ롣

ʤСϤµ

CD SQL Ϥǡ١ (ץߥ󥰳ؽ꡼)
CD SQL Ϥǡ١ (ץߥ󥰳ؽ꡼)
posted with amazlet at 14.09.07
ߥå
Ʊ˼
夲󥭥: 4,658


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

ɾ
夲󥭥: 61,578


ϥѥեޥMySQL 3
ϥѥեޥMySQL 3
posted with amazlet at 14.09.07
Baron Schwartz Peter Zaitsev Vadim Tkachenko
饤꡼ѥ
夲󥭥: 112,943

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

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






DebianΥߥ顼ɥȯ(ؽԤΥ)

Current Pending Sector Count

ؽԤΥοǤ

ؽԤΥοǤ

ؽԤΥŪɤ߹ߤޤϽ񤭹ߤ硢ͤϸꥻؽޤ
ɤ߼ꥨ顼ϥؽޤ
񤭹ߤ˼ԤΤؽޤ


ΥХåɥȯ

Ǯʡ

ϡ֥ϡɥǥǮ˼夤פȤǧäƤꡢºݤȻפ

äʤ(ɴʾϤ뤬Ϥ餯ʤ)ܺ٤˥ǡä櫓ǤϤʤ᡼ˤäƤۤʤ

Google٤뵻55(224ڡ)ˡ֥ϡɥǥϤIJ뤫פȤƤ롣

ˤȡ

ĹȤȲ䤹ʤ櫓ǤϤʤ

褯ȤȲ䤹ʤȤ¤ʤ

Ȥͽۤȿ̤񤫤Ƥ롣

ˤϡ

٤⤤ۤɲ䤹ȤȤʤ

Ȥä٤(ȿ)Ƥ⡣

Failure Trends in a Large Disk Drive Population

S.M.A.R.T.˴طʤ(ʤ)ξ㤹Τ褯뤳ȤʤΤǡS.M.A.R.T.΅ʤ褦ˡ

S.M.A.R.T.ͤϤƤˤʤʤ⤷ʤ꤬Ƥ뤳ȤΤΤɬפ

ʤLinuxǤ¿ξɸS.M.A.R.T.Ǥ뤬WindowsǤϼǤʤ

ȯ䤹Τ

05ؽѤΥ
C5ؽαΥ
C6Բǽ

ΰ۾Ǥ롣

Ϣ٥եޥåȤˤS.M.A.R.T.Ѳ(ؽαΥ,ؽαΥ,Բǽ)

ͤǤʤѲ⤢롣

ɤФϡɥǥϡʸѤ٤ǤϤʤ

ޤʡ۾ʥȤϸ¤ʤΤǡʤΥϡɥǥȤƤ⡢S.M.A.R.T.ͤĴ٤Ƥ

S.M.A.R.T.ˤϰ۾郎ʤƤưԲʥǥΤա

ˤƤ⡢ϡɥǥϾʤǤꤤĤϸξ㤹Τǡߥ顼󥰤ɬܤ

ϢϡɥǥϾ

ߥ顼󥰤ξ塢Хååפ

ߥ顼󥰤ϡֶפʤΤǡäƾäǡʤ

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

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






ǡ١ǽפindexǤ뤬ƤfieldindexΤϡ¿ξ̵̤Ǥ롣

Ƥ⡢줬Ѥʤа̣ʤ

index뤳ȤϡfieldΥԡ뤳Ȥ˶᤯ǽ㲼򾷤

ƤfieldindexɲäСơ֥뤬2ĤΤƱ

ȯȡξ˽񤭹ޤͤФʤʤ(Ʊ)

indexΩĤʬʤΤˡƤfieldФindexꤹΤ̵̡

ɼ褬ᥤξϡʤϥޥ...

indexꤷƤȤʤfieldϡۤɹͤʤƤʬϤ

褯Τ祭ˤϴindexΤˡȤ̤indexƤѥ

Ĺ̵̤Ǥ롣

ʤSQLˤäƤϡindexΩʤ(Ȥʤ)⤢롣

̾ϡĢõ롣

Ģˤϡν¤Ǥ뤫

̾ξϡ줬Ȥʤ

ƤФơ̾Ǥǽ뤫

ʣindex(sei),̾(mei)νꤷƤ⡢̾ǤSELECTˤΩʤ

Ʊͤˡ̾ˤORDER BYˤΩʤ

SELECT * FROM `user` ORDER BY `mei`,`sei` ;

ޤLIKE'%'%줿()⡢Ƥ˰פǽΤindexΩʤ

'%%'ȶְפƱ͡

黻ƤӤʤɤ⡢indexΩʤ

WHERE `price` * 1.08 > 1000 ;

Τ褦ʾ硣

indexˤǡ`price`Ǥä`price` * 1.08ǤϤʤ

ϡξդ1.08dzä

WHERE `price` > 1000/1.08 ;

ȤȡindexѤǤ褦ˤʤ롣

()䡢IS NULLOR⡢indexѤǤʤ

âORINǽ񤭴ȡindexѤǤ褦ˤʤ롣

EXPLAINǡꤷindexpossible_keys˴ޤޤƤꡢkeyǼºݤѤƤ뤫ǧƤ

ãͤ˳ؤDB߷ Ű Ԥǽꤿʤʤ
ãͤ˳ؤDB߷ Ű Ԥǽꤿʤʤ
posted with amazlet at 14.06.29
ߥå
Ʊ˼
夲󥭥: 10,850


ʲSQLѥϤᡣ

Ʋ⤷Ƥ롣

줳졢뤢롪ߤʣ

ʤưƤ뤫顢ȤSQLν򤷤Ƥȡ쥳ɤȽŤʤäꤷʤ

ȤΤȤͤƤʤΤ͡

ޤͽ̤ۤSELECTƤ뤫OKȽǤꤷƤʤ

͡ʥ쥳ɤƤ硢ͽʤ̤֤Ƥʤ

SQLѥ
SQLѥ
posted with amazlet at 14.06.29
Bill Karwin
饤꡼ѥ
夲󥭥: 7,908


SQLǷѴְռˡפƤޤ졩indexѤƤʤȤ
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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






߱ѤƤWEBСǡ١Сե륵СϡưǤ롣

ưΥС

СȤɤѥʤΤǡξ㤹롣

˱ѤƤиǤ...

¿ΤϤǥθξ㡣



¨ǤϤʤS.M.A.R.T.ΰ˰۾郎Фѥ

Ϣ٥եޥåȤˤS.M.A.R.T.Ѳ(ؽαΥ,ؽαΥ,Բǽ)

ξ硢

ưϤʤȡ꤬Ф礬롣

ǥɥФ뤳Ȥ򸫹¤ƤΤǡɥȯƤ⡢ؽ뤳ȤǤ롣

ɥȯսˤäǡƤꡢ줬ؽСäʤư

âξǤ⡢ɤȯǥϸ򴹤٤

꤬ФΤϡɥȯսˤäǡ»Ƥޤä硣

줬ưɬפʥեǤȡư˼Ԥ롣

MySQLɬפʥեǤСMySQLưǤʤʤ롣

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

ɾ
夲󥭥: 32,202


Τ褦ʥȥ֥뤿ᡢߥ顼(RAID1)ȤǤ

RAID1RAID5ϡξ㤷ƤΤ1ΤߤǤ롣

2ʾȡǡϼƤޤ

RAID5ΥӥɻƤǥ٤ξ㤷ǡ򼺤äȤäϤ褯ʹ

ӥɻϡʤǥ٤Τǡλ˸ξ㤷ƤޤΤ

RAIDȤǤȤƤ⡢μ¤ǤȤϸ¤ʤ

ʻΤˡӥХååפäƤ

RAIDˤϡեȥRAIDϡɥRAID뤬LinuxǤСեȥRAIDѲǽ

# եȥRAIDϡɥRAIDϡ¤ۣʤΤ

ϡɥRAIDξ硢Υȥ餬Ƥޤȡ



¿ΤŸθξ㡣



ϢPowerEdgeT105Ÿ 2Ϣ³ L305P-01 NH493 PS-6311-5DF-LF

ޥܡɾԵפΤŤϤƤ褦Ÿʤ

ΥǥǤɤŤʤä⤷ʤŸʤ

ŸξĹƤʤСǤСͽŸݴɤɬפ(󥿥뤬)

꡼Υ顼ϡСǤϤʤ饤ȤǤϷи

ݤϡ԰ˤʤȤưʤȤ

꡼ꤹΤϡʤѤ

ǶWindowsˤϥ꡼åġ뤬Ƥ뤬Memtest86ǥåΤ褤͡

ϢMemtest(Memtest86)ǤΥå()ˡܸ

Memtest86Τ餢꡼åġǡեåԡCD-ROMǵưΤǶΥΡȥѥȡɤܤƤʤȤ⤢ΤǡUSB꡼鵯ư褦

ǶϾʤåOKΥ꡼2ƱޤNGȤʤ礬Τ(꡼)

СˤECC(Error Checking and Correction)դΥ򡢤ȤϤ褯롣



ϢPowerEdgeT105Υ꡼(ưǧ꡼η)

ECC꡼Ȥϡ顼θФԤʤǽäƤΤǡΤˤǤϤ뤬...

ECCդǤϤʤ꡼ѤСⲿ椫ѤƤ롣

꡼»ǡDB˳ǼȺ뤳Ȥʤ뤫͡

СˤɤΤ餤νŤߤ뤫ѤäƤ

ѤäԶȤƤϡŸǤǺƵưݤˡBIOS꤬ǤޤIDE⡼ɤꤷƤǥ⡼ɤAHCIˤʤäƤޤư˼Ԥ뤳Ȥä

DebianȡgrubθߤƤޤ

ʽиʤϤAHCIǧ̤ɽΤǵդʸƤʤԤϵդʤ⤷ʤ

󥿥륵С䥯饦ɤ˰ܹԤȡϡɥݼפˤʤ롣

äƤ⡢ϡ̤϶ȼԤƤ뤫͡

âƥʥ󥹤Ȥơ󥿥बȯ뤳Ȥ롣

¿Ͽ뤫ī˹ԤΤǡӤǤϱƶʤȤ¿WEBӥȺ롣

ϡɥˤȡݼ餬ɬפǤ뤷뤤ѼԤɬפˤʤ롣

ݼǤȤΤ⤢뤬¨¤ƤΤɤ

ĶбǤȤ4бˬʤɤ롣

DELLݼ饵ӥ


  • б󥵥ݼ饵ӥ

  • 4б󥵥ݼ饵ӥ(6Ķ 9-17)

  • 4б󥵥ݼ饵ӥ(24365)

  • 4֥ץ饹б󥵥ݼ饵ӥ(6Ķ 9-17)

  • 4֥ץ饹б󥵥ݼ饵ӥ(24365)



ϢDELLݼ饵ӥ

ݼݼǽפǤ뤬ݼɾˤ(ĶȤȤϰۤʤ夬櫓ǤϤʤ)Τǡͭݼ饵ӥФʤ¿

夬ϡɴϢ̵ΤǤ̤뤬Ⱦü˾ܤȡΤ餤Ҥǥ졪ȤʤäơޤȾü˾ܤ̳ʤ󤫤ִԡפˤʤäƤޤ

㳲Ƥ⡢ä̤ʤ

СʤưƤƤ⡢̿Ǥʤа̣ʤ

NICɤϷиʤHUBθξϤ褯롣

äGigabitHUBϤ褯ξ㤷

ȯǮ礭ä

ݤʤΤϡľ̿Ǥ뤬Ф餯ȥˤʤѥ

NICǤʤHUBξĹɬפ͡



ͭLANʤüϻʤС̵(Wi-Fi)ǤĤʤΤϤƤ

֥뤬ʤΤʬޤɡ

CPUθξϡ礱(ΤAthlonʤ)衢ΤȤиƤʤ

ե򴹻դľꥹCPULGA¦夷CPUǧΤΡ꡼ΰǧʤȤи롣

ꥹåȤΰΤߤȤʤΤ

ꥹɤݤϡCPU΢̤夷ƤʤLGA¦ˤդƤʤǧ褦

ޥܡɤɤ⡢С˱ƤϤΤȤиƤʤ

饤ȤǤUSBϤᡢɤиƤ뤬

ϢRenesas(ͥ)USB3.0(MPD720200)Υɥ饤Фι(Զ)

СʤΤǡüʵǽåɲäǤζʵǽɲäϤʤ

ååפ®٤夲Ȥ

ǯϤΤ褦ʥޥ¿äǶϸϤƤꡢʤ

СѤΥޥϡѤʤդʤ͡

ǥ󥵡⥢ߥǥ󥵡Υǥ󥵡֤äƤΤǡǥ󥵡ɥ饤åפ԰ˤʤ뤳Ȥʤ

ޤ꡼ϡɥǥͽи򴹤Ǥ뤬ޥܡɤξ㤷硢ƱΥޥܡɤͽäƤ뤳ȤϾʤȻפ...

ޥʤȤ򵧤

СƳ顢٤ݤưꤹ뤳ȤǧƤ顢´Ķ褦ˤƤ롣

ǤPRO CentOS 6 С (Ǥץ꡼)
ǤPRO CentOS 6 С (Ǥץ꡼)
posted with amazlet at 14.06.29
ŵ Ǥ륷꡼Խ
ץ쥹ѥ
夲󥭥: 53,086
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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






Τ٤LinuxʬñˤʤꡢGUIǤʬ

̤ʸǤäƤ(CUI)桼ɲä⡢GUIǤǤ뤷͡

Windows

GUIƤǤ뤫ȤФǤϤʤǤ褦˸Ƽ¤ϤǤʤȤGUIʤΤñȻפʣǤäꡣ

UbuntuޤdzڤФ褤Debianȳڤʤ͡

DebianϥСӤǤκѤ¿ȻפСӤǤϤʤ˺ꤹ뤳Ȥˤʤ롣

ȾüGUIǤΤ⡢ͤΤ...

㤨СDebianGUI󥹥ȡRAIDȤ礬

ѡƥڤäƤRAIDȤΤĤǺࡣ

ܤΥ֥륯åǤʬ뤬֥륯åǹԤΤΥܥ򲡤Τ

CUIϡֳڡפǤϤ뤬̤ιȤˡ˰ʤȤ

CUIǤϰŪߵ郎⤤ΤǡCUIΤޤޤǤѼԤʤ

ȤȤǡGUIʤɬʬΤ

GUI٤좪Ȥˤ桼Ȥή졩

Linuxƥ[] (Software Design plus)
̾ μŵ
ɾ
夲󥭥: 64,605
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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

ΥڡΥȥåץ