ϡɥǥƥʥ ֥

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

2014ǯ02






KURO-DACHI/CLONE+ERASE/U3(HDD,USB3.0³,ǽ,ǡõǽ)õȤʤ(EraseܥĹ4θ塢õϤޤʤ)Ǥ뤬

KURO-DACHI/CLONE+ERASE/U3(HDD,USB3.0³,ǽ,ǡõǽ)
KURO-DACHI/CLONE+ERASE/U3(HDD,USB3.0³,ǽ,ǡõǽ)

ϡɥǥޤŸƤ餢ޤ֤֤EraseܥĹ¹ԤΨ夬褦(᤹Ƥ)



ξ硢EraseܥĹ֤ϡ4ǧФǤ褯ξ硢3äʤ

θΤΤʤ

Ÿ塢®䤫˾õȤȤȤϡ

14ڡˤ

Make sure all HDDs have stopped rotating before Erase button is pressed.

ȿ뤳ȤˤʤȻפ...

Ÿ塢žƤޤСEraseܥĹǤžϤޤ餺̤ȤƾõȤʤΤǤ롣

ޤõڤӾõȸHDD2(100%)פϡõȼԤΥ

ȤϰۤʤꡢɥäƤõȤϿʹԤ뤬԰ʥϡɥǥϾõԤˤʤ뤳Ȥ¿

ʤ񤤤ĶĶĶĶ٤ϡɥǥϡõ䡹³ƿʹԤʤä(HDD2(100%)פȤϤʤʤ)

ĶĶĶĶ٤ʤʹԤƤΤϡǤ롣

ˡWDWD1500ADFDȤϡɥǥ(WD Raptor,150GB,10000ž)2ͭƤ뤬2ȤɤäƤõȤʤΤǡǥȤΤΤʤ




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

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






ǡ١С(DBС)ؤ

Debian7.4(64bit) MySQL5.5.35

Debian7.4(64bit)

CPU2.4GHz3.0GHz
MEM4GB8GB (2GB4)

(Ǥ)SQLǽŤ򤹤ȡCPUͭΨ100%ã롣

CPUͭΨ100%
CPUͭΨ100%

ʲΤ褦100%ʾ򼨤Τϰ۾ǤϤʤʣ硣

CPUͭΨ189%
CPUͭΨ189%

Xeon E3110ؤδʤΤǡDualǤ롣

Xeon E3110ξܺ

CPUͭΨ100%ã֤Ĺϡ˽񤤤ƤMySQL䡢SQLʸǡ١߷סindexľɬפ

¿ľȤ٤Τ٤׽ϡɬ¸()

DBСν(ϡŪ)ͥåˤʤΤϡ

CPU꡼ǥNIC

λͤġ

NICϡ100BASEGbE褤

NIC
NIC

1Gbps125MB/sǤ뤬ǥ®ǤäƤ⡢ºݤˤϤޤǤϽФʤ

NICФ(С)Ť¹ԤǤŤNICϴطʤ

ǥϡ˥ϡɥǥѤ뤬®̤顢ǶSSDѤ뤳Ȥ⤢

ϡɥǥSSD
ϡɥǥSSD

SSDϼ̿ΤǤۡȤäƤ⡢HDDξϤΤǡĹɬס

SSDϥϡɥǥñ̤βʤ⤤򥯥ꥢǤʤƳƤ褤

꡼ϡǥ˹®Ǥ뤬ǤꡢǡŪˤݻǤʤ

꡼


Τ٤Ȱ²Ǥꡢ¿ѤߤᥤܡɤΥåȿܾ¤դɬפ롣

ޤСϤΥᥤܡɤξ硢ECCդǤʤ

ˡMySQLĴ(key_buffer_size)ǥ꡼ͭ˻Ȥ褦򤷤ʤȡ̵̤ˤʤ롣

ǸCPU

CPU(Xeon)
CPU(Xeon)

ƬǤ񤤤褦ˡ̤CPU˴ƤŤΤϽŤCPUͭΨ100%ã롣

100%ãƤ֤ûʤȤ̤Ϥ뤬ɴMHz夲Ȥǡ礭ʸ̤ϸʤ

Ťˤϡ֥ǡɤ߽ФΤ˻֤׽롣

ΥǡSELECTȤʽ

ϡǡ礭Τǡ֤Τ

CPUϡǥľ٤

ΥǡɬפˤʤΤȤƤɬס

̵̤˥ǡSELECTƤ⡢ǽŪˤΰɬפǤʤΤʤ顢⤽SELECTɬפΤ

indexŬڤդƤΤѤƤΤ(EXPLAIN)

JOINUNIONȤΤǤ롣

ޤDB߷פȤ꤬롣

Υѥեޥ󥹤ϸ夹뤬Υѥեޥ󥹤㲼
Υѥեޥ󥹤ϸ夹뤬Υѥեޥ󥹤㲼

ϡñˤȥơ֥ʬȤȡ

ơ֥ʬ()ȹϰΥơ֥ΤߤιǺѤब
˷礹ɬפΤǡΥѥեޥ󥹤㲼롣

ɤ߽Ф¿ϡΤ

פʤΤϻѼԤˤȤäƲŬʥƥफǤ롣

ѼԤȯԤȰۤʤ硢ѼԤˤȤäơɤǤ褤ȡ

ԡΤ褦߷׼Ԥ뤬ѼԤΩΩĤȡ櫓ǤϤʤȤʬ

򤷤߷פ뤫ǤʤϡפǤꡢΤʤʹ֤ȶ˳ȯƤ⡢äʤ()

----

Ťǡ֥饦Ȥޤ͡

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

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






Xeon E3110ϡWolfdale,2Cores,FSB:1333MHz,L2:6MB,TDP:65WǤꡢXeonǤϤ뤬Core2 Duo E8400ȤۤƱ

Xeon E3110
Xeon E3110

CPUåȤ⥵СѤLGA771ǤϤʤLGA775ǤꡢᥤܡɤбƤаʤǤƯ롣

(LGA775LGA771ϥԥڷ礭ΰ֤ۤʤߴʤ)

Xeon E3110ϡCore2 Duo E8400ˤʤäˡѤȤƵ줿

Xeon E3110LGA771ǤȤ⤤ΤE5240

Core2 Duo E8400ϡCore2 Duoξ(E8600,E8500˼夫黰)Ǥäθ塢ٽŤʤޥƥ(MA)οʲꡢ

Core2

Corei7 (Nehalem,Lynnfield)

Corei7 (Sandy Bridge)

Corei7 軰(Ivy Bridge)

Corei7 (Haswell)

ĤƤCore2 DuoǶĤΰ2014ǯκȤʤäƤϡʤCeleron Dual-Core(Haswell,LGA1155)(ǽ)餱롩⤷ʤ...

Celeron DC G18202.7GHz

Celeron DC G1820T2.7GHz

Celeron DC G18302.8GHz

٤CeleronȤˡԤ(ޥ)Τá

ϢCore2 Duo (E8400, E8500 ,E8600) - Core2 DuoǶ

Intel Boxed Core 2 Duo E8400 3.00GHz BX80570E8400
ƥ (2008-01-20)
夲󥭥: 9,064
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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






phpMyAdmin 3.4.11.1deb2

phpMyAdminɸΥǥ(ơ/)ϡĤpmahommeȤΤѹˤʤäƤ롣

pmahomme
pmahomme

Υơ(Original)˴Ƥ硢OriginalȤ⤢

Original
Original

ơޤϡۡˤ Ѥơ/ ѹǤ롣

Ѥơ/

ɸOriginalˤˤϡ

/var/www/phpmyadmin/libraries

ˤ

config.default.php

ΥեΰʲOriginal˽񤭴롣

/**
* set up default theme, if ThemePath not empty you can set up here an valid
* path to themes or 'original' for the original pma-theme
*
* @global string $cfg['ThemeDefault']
*/
$cfg['ThemeDefault'] = 'pmahomme';



$cfg['ThemeDefault'] = 'Original';

ʤơޤΥե뷲

/var/www/phpmyadmin/themes

˳ǼƤꡢ¾ΥơޤƤ롣

ʣΥСäʣphpMyAdmin򰷤硢СDBȻפäDROP顢¤ϼ±ѥСDBǤäȤʤȺ롣

ɤDBǤ뤫ʬ䤹뤿ᡢСȼ±ѥСphpMyAdminΥơޤ礭ѤƤȤ褤

phpMyAdminκˤϥåȥ֥ۡ뤬ֻСפȤּ¥СפȤѤƤʬ䤹

Originalξ

http://192.168.0.10/phpmyadmin/themes/original/img/logo_left.png

ΥǤꡢpmahommeǤ

http://192.168.0.10/phpmyadmin/themes/pmahomme/img/logo_left.png

Ǥ롣

ʤphpMyAdminǥơ֥ˡSQLפ򥯥åȡ֥ǡ١ xxx ǥ¹ԤפȤǤ뤬ɸSQLʸ(SELECT * FROM @TABLE@ WHERE 1)ѹǽ

config.default.phpγս񤭴롣

/**
* Default query for table
*
* @global string $cfg['DefaultQueryTable']
*/
$cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';

ݡȤκĹϤѹϤǤϤǤʤΤǡ

phpMyAdminǤΥݡȥեκĹѹ(Debian)򻲾ȤΤȡ
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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






Ťޥܡɤɤ͡

ASRock Z77 Extreme4

ASRock Z77 Extreme4

2012ǯ48䳫ϤʤΤǡ2ǯ

Ծͽ۲ʤ15,980ä顢ޥ

(̤ˤASRock Z77 Extreme6ꡢƱʤ20,980)

åȤLGA1155ʤΤǡǿ4770K(LGA1150)Ϻܤʤ

ܤΤϡ(Core i7 2600KȤ3770K

ޤǤäƤޤʬȤ뤷ǽͥ줿Celeron G1610ܤ뤷ĤǤޤޤ



ưȡUEFI(եBIOSäݤ)ˤʤ롣

뤬ɽ졢ޥȤ롣

UEFIΥåץǡȤϡåץǡȥեꤷUSBơ˥塼֤

ASRock Z77 Extreme4

ASRock Z77 Extreme4
ʬˤǥե̾򥯥åȿʤ

ASRock Z77 Extreme4

ASRock Z77 Extreme4

ASRock Z77 Extreme4

SDɡܥɥ꡼Ǥɤ᤿UEFIưޤƤǧ줿

SDɡܥɥ꡼

LAN֥ޤƤС󥿡ͥåȷͳDzǽʤ褦͡

DOSưΥեåԡǥBIOSե...ȤäƤǤʡΤϡ

ǿΥåץǡȥե

Z77EXT42.90 (ver.2.90,7/23/2013)

ǤäΥ8MB

եåԡǤ̵()

꡼4ɤΤ3ޤȥ顼Υӡײ

3ܤ1-2ܤޤȥ顼ǤϤʤΤǡ꡼

ޤϥ顼ʤǤ͡졣

USB꤫鵯ưUbuntu

Ubuntu

UbuntuǤΥƥ



UbuntuLinuxǤWindowsŪǤꡢ󥿡ͥåȤ᡼٤ǤФǽʬ͡

WindowsXPδǯ49äƤ뤬ӤǤʤСΥޥUbuntuȱ̿ǽ

ޤ󥿡ͥåȤ᡼٤ǤiPadΥ֥åȤǽʬʤΤ

ưǽХåƥ꡼ϻĤޥ⥭ܡɤס

ϢiPad Air(5) - ưϤʤ()

ŤäȤ򤷤褦Ȥȡ֥åȤǤԲǽ

ʤ饿֥åȤOK¦ʤϤѥ
[PR] au WALLETɤξ - auΥץڥɥɤǥåԥ󥰤򤪥ȥˡ

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

ΥڡΥȥåץ