mysql:16226

丐﹜馨翮匹允﹝

CREATE TABLE妐及醱匹反
＞手午手午皿仿奶穴伉□平□分勻凶＝serial_code卞UNIQUE孺沶互丐曰引六氏匹仄凶互﹜
> index idxserial_mst_serial_code ( serial_code )

UNIQUE KEY及樺寧fast index
creation互躲井卅仁卅曰引允及匹﹜innodb-sort-buffer-size反中元勻化手躲絆互卅中匹允﹝


yoku0825,


2015コ4畸9ざ 1:13 yoku ts. <yoku0825@xxxxxxxxxx>:
> 仇氏壬氏反﹜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

>>

>>

>>

>>