[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:16225

From: "yoku ts." <"yoku ts." <yoku0825@xxxxxxxxxx>>
Date: Thu, 9 Apr 2015 01:13:40 +0900
Subject: [mysql 16225] Re: [mysql 16224] ÂçÎ̤ʥǡ¼¥¿¤Î°·¤¤¤Ë¤Ä¤¤¤Æ

¤³¤ó¤Ð¤ó¤Ï¡¢yoku0825¤È¤¤¤¤¤Þ¤¹¡£

¤Ñ¤Ã¤È»×¤¤¤Ä¤¯¤È¤³¤í¤ò¤Ä¤é¤Ä¤é¤È¡£¡£

MySQL¤Ï¹¥¤­¤ËºÆµ¯Æ°¤Ç¤­¤ë¡¢¥Ç¡¼¥¿¥í¡¼¥É¤Ï½é´ü¥Ç¡¼¥¿¤Î¥í¡¼¥É¤À¤±¤Ç¡¢¤½¤Î¸å¤Ï¥Ð¥ë¥¯¥í¡¼¥É¤µ¤ì¤ë¤³¤È¤Ï¤Ê¤¤¡¢¤È²¾Äꤷ¤Æ¤ÎÏäǤ¹¡£


## ¤¢¤È¤Ç¤â¤È¤ËÌ᤹¤â¤Î
* skip-innodb-doublewrite # ¥í¡¼¥ÉÃæ¤Ë¥¯¥é¥Ã¥·¥å¤·¤¿¤é¤ä¤êľ¤¹
* innodb-flush-log-trx-commit= 0 # Ʊ¾å
* innodb-log-buffer-size= 256M # ¤â¤¦¤Á¤ç¤Ã¤ÈÂ礭¤¯¤Æ¤â¤¤¤¤¤«¤â
* innodb-log-file-size= 2G, innodb-log-files-in-group= 4 ¤¯¤é¤¤ #¥í¥°¥Õ¥¡¥¤¥ëÂ礭¤á
* innodb-sort-buffer-size= 64M # ALTER TABLEÍÑ
* innodb-adaptive-hash-index= 0 # I/O¥Ð¥¦¥ó¥É¤Ê¤é¤³¤ì¤ÇÎɤ¤¤«¤È

## ÍͻҤò¸«¤Ê¤¬¤é
* innodb-io-capacity= innodb-io-capacity-max #
I/O¤¬Í·¤ó¤Ç¤¤¤ë¤è¤¦¤Ç¤¢¤ì¤ÐÁý¤ä¤¹(HDD1¶Ì¤Ê¤é¥Ç¥Õ¥©¥ë¥È¤Î¤Þ¤Þ¤Ç¤â¤¤¤¤¤«¤È)

## ¸ú²Ì¤¬¤¢¤ë¤«¤Ï¤ï¤«¤é¤Ê¤¤¤Ç¤¹¤¬
* innodb-autoextend-increment= 256M # .ibd¥Õ¥¡¥¤¥ë¤Î³Èĥñ°Ì,
innodb-file-per-table= 0¤Î»þ¤Ëibdata1¤òÂ礭¤á¤Ë½é´ü²½¤¹¤ë¤Î¤ÈƱ¤¸¹Í¤¨

¤ÇMySQL¤òµ¯Æ°¤·¤Æ¡¢
* ¥»¥«¥ó¥À¥ê¡¼¥­¡¼¤Ï¤Ä¤±¤Ê¤¤¤ÇCREATE TABLE
* LOAD DATA INFILE (handlersocket¤È¤«»È¤Ã¤Æ¤ß¤ë¤Î¤â¤è¤µ¤½¤¦¤Êͽ´¶¤¬¤·¤Þ¤¹)
* ALTER TABLE serial_mst ADD KEY .. (serial_code);
¤³¤³¤Ç¥Ñ¥é¥á¡¼¥¿¡¼¤òÌᤷ¤ÆºÆµ¯Æ°¡¢¤È¤ï¤¿¤·¤Ê¤é¤³¤¦¤ä¤ê¤Þ¤¹¡£

Á°¤Ë¤ä¤Ã¤¿»þ¤Îµ­»ö¤¬½Ð¤Æ¤­¤Þ¤·¤¿¡Ê¤â¤È¤â¤È¤ÎÌÜŪ¤Ï°ã¤¤¤Þ¤·¤¿¤¬¥Ð¥ë¥¯¥í¡¼¥É¤Î®ÅÙÈæ³Ó¤ß¤¿¤¤¤Ë¤Ê¤Ã¤Æ¤ë¡Ë

Æü¡¹¤Î³Ð½ñ: MySQL¥¤¥ó¥¹¥¿¥ó¥¹´Ö¤Ç¥Æ¡¼¥Ö¥ë¤ò°Ü¹Ô¤¹¤ëÅꤲ¸¯¤ê¥Ù¥ó¥Á¥Þ¡¼¥¯
http://yoku0825.blogspot.jp/2013/11/mysql.html



¤½¤Î¾¡¢¼êÁ°Ì£Á¹¤Ê¤â¤Î¤â´Þ¤á¤Æ¤´»²¹Í¤Þ¤Ç¤Ë¡£¡£

´Á(¥ª¥È¥³)¤Î¥³¥ó¥Ô¥å¡¼¥¿Æ»: ¤¿¤Ã¤¿3ÉäÇInnoDB¤Î¥Ç¡¼¥¿¥í¡¼¥Ç¥£¥ó¥°¤¬²÷Ŭ¤Ë¤Ê¤ë¥é¥¤¥Õ¥Ï¥Ã¥¯
http://nippondanji.blogspot.jp/2010/03/innodb.html

MySQL 5.6¤Ë¤ª¤±¤ëÂçÎ̥ǡ¼¥¿¥í¡¼¥É»þ¤Î¹ÍθÅÀ - SH2¤ÎÆüµ­
http://d.hatena.ne.jp/sh2/20131007

Ë»¤·¤¤¿Í¤Î¤¿¤á¤Î MySQL 5.7.6 DMR ¤Ë¤ª¤±¤ë InnoDB Flushing ¤ÎÊѹ¹ÅÀ¤Ë¤Ä¤¤¤Æ | GREE Engineers' Blog
http://labs.gree.jp/blog/2015/03/13735/

Æü¡¹¤Î³Ð½ñ: MySQL 5.6.4¤Ç¼ÂÁõ¤µ¤ì¤¿innodb-sort-buffer-size¤ÎÃÍ
http://yoku0825.blogspot.jp/2014/05/mysql-564innodb-sort-buffer-size.html



yoku0825,

2015ǯ4·î8Æü 21:39 Æ󸫡¡½¤¹¯[£Ä£Î£Ð¥Ç¥¸¥¿¥ë¥³¥à] <futami-n2@xxxxxxxxxx>:
> Æ󸫤ȿ½¤·¤Þ¤¹¡¢¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹

>

> µ×¤·¤Ö¤ê¤ÎÅê¹Æ¤È¤Ê¤ê¤Þ¤¹¡Ê2009ǯ°ÊÍè¡©¡Ë

> ¤Á¤ç¤Ã¤È³§ÍͤΤ´°Õ¸«¤ò»Ç¤¤¤¿¤¤¤Î¤Ç¤¹¤¬¡¦¡¦¡¦

>

> ²¼µ­¤ÎÍͤʴĶ­¤Ë¤Æ

>

>>Red Hat Enterprise 5.6

>>MySQL 5.6

>>

>>

>>create table serial_mst (

>> serial_code     varchar(16) not null,

>> serial_seq       bigint(16) unsigned zerofill auto_increment not null,

>> update_date  timestamp,

>>

>> primary key ( serial_seq ),

>> index idxserial_mst_serial_code ( serial_code )

>>) TYPE = InnoDB;

>

> ¥·¥ê¥¢¥ë¥³¡¼¥É¤ò500Ëü·ïËè¤ËLOAD DATA¤·¤Æ¤ª¤ê¤Þ¤¹

>

> ¥á¥â¥ê¤Ï8G¤¢¤êMySQL¤Ç5G»ÈÍѤ·¤Æ¤¤¤ë¤È¤Î»ö¤Ç¤¹

> ¡¡¡ô¥µ¡¼¥ÐÀßÄê¤Î¥Á¡¼¥à¤Ëʹ¤¤¤¿¾ðÊó¤Ç¤¹¡¢Û£Ëæ¤Ç¤¹¤ß¤Þ¤»¤ó

>

> 3²¯¤È¤«4²¯¥³¡¼¥É¤¯¤é¤¤Æþ¤ì¤ë¤Ä¤â¤ê¤Ê¤Î¤Ç¤¹¤¬

> ·ï¿ô¤¬Áý¤¨¤ë¤´¤È¤ËÅÐÏ¿¤¬½ù¡¹¤ËÃÙ¤¯¤Ê¤ê

> £±²¯3000Ëü·ï±Û¤¨¤¿Êդ꤫¤é¶Ëü¤ËÃÙ¤¯¤Ê¤Ã¤Æ¤­¤Þ¤¹

>       0¡¡¢Í  500Ëü¡¡1ʬ13ÉÃ

> 3000Ëü¢Í3500Ëü¡¡2ʬ57ÉÃ

> 9000Ëü¢Í9500Ëü¡¡4ʬ48ÉÃ

>

> 11500Ëü¢Í12000Ëü¡¡10ʬ11ÉÃ

> 12500Ëü¢Í13000Ëü¡¡37ʬ18ÉÃ

> 13500Ëü¢Í14000Ëü¡¡73ʬ

> 14500Ëü¢Í15000Ëü¡¡96ʬ

> 15500Ëü¢Í16000Ëü¡¡112ʬ

>

> 19500Ëü¢Í20000Ëü¡¡157ʬ

>

> ¥×¥é¥¤¥Þ¥ê¥­¡¼¤òserial_code¢Íserial_seq¤ËÊѹ¹¤·¤¿»ö¤Ç

> ¥È¡¼¥¿¥ë¤ÎÅÐÏ¿»þ´Ö¤¬

> 2²¯·ï¤Ç75»þ´Ö¢Í30»þ´Ö¤Ë¿¾¯Á᤯¤Ê¤ê¤Þ¤·¤¿

>

> ¥á¥â¥ê¤òÁý¤ä¤¹»ö¤Ç

> £±²¯3000Ëü·ï¤ÎÃÙ±ä¥Ý¥¤¥ó¥È¤òÃ٤餻¤ë»ö¤Ï½ÐÍ褽¤¦¤Ç¤¹¤¬

> ¡ÊÎ㤨¤Ð¥á¥â¥ê¤òÇܤËÁý¤ä¤·¤ÆMySQL¤ò10G¤Ë¤¹¤ì¤Ð2²¯6000Ëü¶á¤¯¤Ë¤Ê¤ë¤È»×¤ï

> ¤ì¤ë¡Ë

> ²¿¤«Â¾¤ËÎɤ¤ÊýË¡¤Ï̵¤¤¤Ç¤·¤ç¤¦¤«¡©

>

> ¤Þ¤À»î¤·¤Æ̵¤¤¤Ç¤¹¤¬¡¢

> Index¤ò̵¸ú¤Ë¤·¤Æ£³¡Á£´²¯¥Ç¡¼¥¿¤òºîÀ®¸åIndex¤òŽ¤ë¤È¤«

> ¡Ê¤½¤Î¾ì¹çIndex¤ÎÀ¸À®¤Ë¤â¤ÎÀ¨¤¯»þ´Ö¤¬³Ý¤«¤ë¤È¤«¤Ï¤Á¤ç¤Ã¤ÈÉݤ¤¤Î¤Ç¤¹¤¬¡Ë

>

> ²¿¤«Îɤ¤ÊýË¡¤ò¤´Â¸ÃΤǤ·¤¿¤é¤ª¶µ¤¨Äº¤±¤ë¤ÈÍ­¤êÆñ¤¤¤Ç¤¹

>

> µ¹¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹

>

> ¢¨Éô½ð̾¤¬ÊѤï¤ê¤Þ¤·¤¿

> -------------------------------------------------------

>   DNP DIGITALCOM

> ¡¡¥·¥¹¥Æ¥à¥½¥ê¥å¡¼¥·¥ç¥óËÜÉô

>   Â裱¥·¥¹¥Æ¥à³«È¯¼¼¡¡Â裲¥°¥ë¡¼¥×

> ¡¡¡¡¡¡Æ󸫡¡½¤¹¯

>

>   ¢©141-8001

>     ÉÊÀî¶èÀ¾¸ÞÈ¿ÅÄ3-5-20 £Ä£Î£Ð¸ÞÈ¿ÅÄ¥Ó¥ë5£Æ

>

>     TEL 03-6431-6324 ÆâÀþ 6324

>     FAX 03-6431-6193

> ¡¡  Mail: Futami-N2@xxxxxxxxxx

>

>

>

>


[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     16224 2015-04-08 21:39 [Æ󸫡¡½¤¹¯[£Ä£Î£Ð¥Ç¥] ÂçÎ̤ʥǡ¼¥¿¤Î°·¤¤¤Ë¤Ä¤¤¤Æ              
->   16225 2015-04-09 01:13 ¨²["yoku ts." <yoku0825] Re: [mysql 16224] ÂçÎ̤ʥǡ¼¥¿¤Î°·¤¤¤Ë¤Ä¤¤¤Æ
     16226 2015-04-09 01:49 ¨­¨±["yoku ts." <yoku0825]                                     
     16227 2015-04-10 12:20 ¨±[HIRATSUKA Sadao <sh2]