mysql:11885

煽★枆匹允﹝仇氏卞切反﹝
MyISAM 及⑹讀氾□皮伙毛汊蛙仄凶煩董互拑中及匹樹扷羼間分仃’’’﹝

BLOB 滇及白奴□伙玉毛殖氏匹中月樺寧﹜MyISAM 及犯白巧伙玄匹丐月
斃讀氾□皮伙匹反卅仁﹜⑹讀氾□皮伙互睡迕今木引允﹝
⑹讀氾□皮伙井日伊戊□玉毛潸丿允月卞反﹜伊戊□玉咍卞伊戊□玉目永母井日
伊戊□玉扔奶朮毛厶心請仄化﹜田永白央尺丟乒伉毛喃曰癲化月質咥互墊歹木引允﹝

Not enough memory for blob at [sort_param->start_recpos] (need [block_info.rec_len])

午中丹丟永本□斥反﹜公及田永白央尺及丟乒伉割忡卞撩ヘ仄凶午五卞請恘今木月方丹匹允﹝
匹允井日﹜REPAIR TABLE 抰挓�墊詨及丟乒伉橇須支 MySQL 及澀爛毛譬犖允木壬窒井歹井月井手襞木引六氏﹝

引凶﹜慼及邰豳井日手窒井甲件玄毛丿日木月井手襞木引六氏﹝
﹋http://dev.mysql.com/doc/mysql/ja/repair-table.html 方曰﹌

’MySQL 4.1.1 動嫦﹜犯白巧伙玄匹 REPAIR TABLE 戊穴件玉反田奶瓜伉伕弘卞踏五慇引木月﹝
’REPAIR TABLE 匹反引分 myisamchk 及允屯化及左皿扑亦件毛市田□仄化中卅中﹝

REPAIR TABLE 支 myisamchk 及左皿扑亦件卞肣躲卅澎蟾互悵木化中月第チ嶺手丐曰引允友﹝
酸ゴ卅互日颱互恘卞卅木月及反仇及彶曰引匹及方丹匹允’’’﹝


"SUGIMURA Takashi 錯翹 筑銜" <sugimura@xxxxxxxxxx> wrote:
> 錯翹匹允﹝仇氏卞切反﹝
> 
> 引內﹜棕雁反慼及騷曰匹允﹝
> 
> FreeBSD 5.3-SECURITY
> Pentium 4 2.8GHz / 1GB RAM / 250GB HDD
> MySQL 4.1.11
> 
> REPAIR TABLE 妐匹巨仿□互請凶午五卞﹜升丹覆質允屯五卅及井卞勾中化
> ゾ氏匹中引允﹝仇及氾□皮伙反 MyISAM 匹允﹝
> 
> --------------------------------------------------------------
> mysql> REPAIR TABLE XXXXXXXXXXX \G;
> *************************** 1. row ***************************
>    Table: xxxxxxxxx.XXXXXXXXXXX
>       Op: repair
> Msg_type: error
> Msg_text: Not enough memory for blob at 5154540 (need 2603799)
> *************************** 2. row ***************************
>    Table: xxxxxxxxx.XXXXXXXXXXX
>       Op: repair
> Msg_type: status
> Msg_text: Operation failed
> 2 rows in set (0.84 sec)
> 
> ERROR:
> No query specified
> 
> --------------------------------------------------------------
> 
> MySQL 毛侹午仄化 myisamchk -o 允木壬汊蛙反仄引允互﹜
> DROP INDEX 支 CREATE INDEX 互躲井內﹜撢撙讀卞丐引曰銀尹引六氏﹝
> 
> 仇木分仃及橇須匹反方仁鰻歹日卅中井手仄木引六氏互﹜
> 窒井支木月仇午互丐曰引仄凶日項尹化仁分今中﹝
> 
> Oracle Certified Professional (Gold 9i) 反儅勻化引允及匹﹜
> Oracle 及汊蛙澎賜反域殺咥荸仄化中引允﹝MySQL 卞反引分丐引曰晰木化中引六氏﹝
> 
> 方欠仄仁云友互中仄引允﹝
> 
> ---
> 錯翹 筑銜 <sugimura@xxxxxxxxxx> 
> GnuPG fingerprint: C81B 9835 1C9E BD9B 84BF  9785 0B91 D08B F667 DCED
> 
>