¥Ï¡¼¥É¥Ç¥£¥¹¥¯¥á¥ó¥Æ¥Ê¥ó¥¹

¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Î¿ÇÃÇ¡¢ÊªÍý¥Õ¥©¡¼¥Þ¥Ã¥È¡¢ÀŲ»²½¡¢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¡¢´í¸±¿ùή£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷

NETGEAR Inc. ReadyNAS 104 ¡Ú3ǯÊÝ¾Ú¡Û 4¥Ù¥¤ Diskless RN10400-100AJS
¥Í¥Ã¥È¥®¥¢ (2013-05-31)
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 1,853

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¥Ñ¥½¥³¥ó¤Îµ¯Æ°»þ¤Ë¡¢

APSDaemon.exe - ¥³¥ó¥Ý¡¼¥Í¥ó¥È¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó

¤È¤¤¤¦¥¨¥é¡¼¤¬½Ð¸½¡£

APSDaemon.exe - ¥³¥ó¥Ý¡¼¥Í¥ó¥È¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¤¢¤ë¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼(Atomµ¡)¤«¤éNETGEAR¤ÎNAS¤Ç¤¢¤ëReadyNAS 104(RN10400-100AJS)¤Ë¥Õ¥¡¥¤¥ë·²(500GBÄøÅÙ)¤ò¥³¥Ô¡¼¤¹¤ë¤È½ù¡¹¤Ë®ÅÙ¤¬Íî¤Á0.3MB/s¤È¤«¤Ê¤ê½ªÎ»¤Þ¤Ç250»þ´Ö¤È¤«¥Õ¥¶¤±¤¿¤³¤È¤Ë¤Ê¤ë¤È½ñ¤¤¤¿¤¬¡¢

¤½¤ÎAtomµ¡¤«¤é¡¢Ê̤ÎWindows¥Þ¥·¥ó¤ËÀܳ¤·¤¿¥Ï¡¼¥É¥Ç¥£¥¹¥¯(USB2.0Àܳ)¤ËƱ¤¸¥Õ¥¡¥¤¥ë·²¤ò¥³¥Ô¡¼¤¹¤ë¤È¡¢Ìó1Æü¤Ç½ªÎ»¤¹¤ëæ«¡£

¤³¤ì¤Ï¤Ä¤Þ¤ê¡¢ReadyNAS 104(RN10400-100AJS)¤¬¡ü¥½¤È¤¤¤¦¤³¤È¤Ë¤Ê¤ë¤Î¤«¡©

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



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ÈÇ
Baron Schwartz Peter Zaitsev Vadim Tkachenko
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 56,487

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¿·µ­»ö¡§[MySQL] ÆüÉÕÈæ³Ó¤äÆüÉÕ¸¡º÷¤¬ÃÙ¤¤¤Î¤ÇBETWEEN¤Ç²þÁ±¤µ¤»¤ë

datetime·¿¤ÎÎó(reg_time)¤¬¤¢¤ë¥Æ¡¼¥Ö¥ë¤ËÂФ·¡¢Ç¯·îÆü»ØÄê¤ò¤«¤±¤Æ¥Ç¡¼¥¿¤ò¼è¤ê½Ð¤¹¡£

Ãí¡§datetime·¿¤ÎÎ㡧2014-01-01 12:34:56

SELECT * FROM `¥Æ¡¼¥Ö¥ë̾` WHERE `reg_time` LIKE '2014-01-01%'

¤³¤ì¤ÏÈó¾ï¤ËÃÙ¤¤¡£

reg_time¤Ëindex¤òÀßÄꤷ¤Æ¤â¡¢index¤¬»ÈÍѤµ¤ì¤Ê¤¤¤Î¤Ç̵°ÕÌ£¡£

½é¿´¼Ô¤¬Â¿ÍѤ¹¤ëLIKE¤Ê¤ó¤«»È¤¦¤«¤é¤À¤è¡ª¤È¤¤¤¦¤³¤È¤Ç¡¢date¤ò»È¤¦¤¬¡¢

Ãí¡§date¤Ïdatetime·¿(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¤ÇÆ°ºî¤ò¸«¤ë¤È¡¢type¤¬all¤«¤érange¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤³¤È¤¬Ê¬¤«¤ë¡£

type¤Ï¡¢¥Æ¡¼¥Ö¥ë¤ËÂФ·¤Æ¤É¤Î¤è¤¦¤ÊÊýË¡¤Ç¥¢¥¯¥»¥¹¤¹¤ë¤Î¤«¤ò¼¨¤¹¤â¤Î¡£

all¤Ï¥Õ¥ë¥Æ¡¼¥Ö¥ë¥¹¥­¥ã¥ó¤Ç¡¢¥¤¥ó¥Ç¥Ã¥¯¥¹¤¬Á´¤¯»ÈÍѤµ¤ì¤Æ¤¤¤Ê¤¤¤³¤È¤òɽ¤¹¡¢ºÇ°­¤Ê¥â¥Î¤À¡£

°ìÊýrange¤Ï¡¢¥¤¥ó¥Ç¥Ã¥¯¥¹¤òÍѤ¤¤¿Èϰϸ¡º÷¤Ç¤¢¤ë¡£

2014ǯ1·î1Æü¤Î»Ïü(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¤ò»È¤¦¤È¹â®²½¤Ç¤­¤ë¤Î¤Ïʬ¤«¤ë¤¬¡¢¥³¡¼¥É¤¬Ä¹¤¯¤Ê¤ë¤·¡¢Ä¾´¶Åª¤Ç¤â¤Ê¤¤¤·¡¢¥¹¥Þ¡¼¥È¤¸¤ã¤Ê¤¤¤Í...

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯

¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø