mysql:16225

仇氏壬氏反﹜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

>

>

>

>