Ticket #305 (closed defect: fixed)

Opened 4 years ago

Last modified 3 years ago

c_imageのMAX_ROWS設定

Reported by: takanashi Assigned to: ebihara
Priority: critical Milestone: OpenPNE2.10alpha1
Component: pne-sysadmin Version: 2.10.x
Keywords: Cc:

Description (Last modified by kunitada)

c_imageのMAX_ROWS設定 画像アップできない不具合の解決

ALTER TABLE c_image ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000;

で。

Change History

11/04/06 00:32:08 changed by takanashi

  • milestone changed from OpenPNE2.6開発 to OpenPNE2.8機能仕様.

11/04/06 00:32:59 changed by takanashi

  • milestone changed from OpenPNE2.8機能仕様 to OpenPNE2.6機能仕様フリーズ.

まちがえた。

11/13/06 10:25:28 changed by takanashi

インストールスクリプトのMAX_ROWSの値を適切なものにする。

11/13/06 14:19:20 changed by takanashi

http://naoya.dyndns.org/~naoya/mt/archives/001565.htmlを参考に。 c_imageを見てみる。

mysql> SHOW TABLE STATUS FROM XXXXX LIKE 'c_image' \G;
*************************** 1. row ***************************
           Name: c_image
           Type: MyISAM
     Row_format: Dynamic
           Rows: 77382
 Avg_row_length: 68022
    Data_length: 5290704080
Max_data_length: 1099511627775
   Index_length: 3497984
      Data_free: 27008316
 Auto_increment: 109286
    Create_time: 2006-07-27 03:42:13
    Update_time: 2006-11-13 13:51:34
     Check_time: 2006-07-27 03:50:54
 Create_options: max_rows=600000 avg_row_length=68641
        Comment:
1 row in set (0.01 sec)

ERROR:
No query specified

Max_data_lengthは1099511627775

01/01/07 23:36:56 changed by takanashi

  • milestone changed from OpenPNE2.6機能仕様フリーズ to OpenPNE2.8機能仕様.

2.8まわし

01/24/07 21:05:13 changed by takanashi

  • priority changed from minor to major.
  • component changed from core@OpenPNE to tuning【チューニング】.

03/22/07 21:26:15 changed by ebihara

  • owner changed from ebihara to openpne.

なんかよく判りませんが僕の担当になっていたんで、いったん外しますね。

03/29/07 12:52:17 changed by takanashi

  • milestone changed from OpenPNE2.8.0 to OpenPNE2.8RC2.

やるよやるよ

04/03/07 18:55:33 changed by tejima

  • owner changed from openpne to nobody.

04/11/07 02:02:16 changed by takanashi

  • milestone changed from OpenPNE2.8beta5 to OpenPNE2.8beta6.

2.8でやるかどうかbeta6で検討。
2.10にまわすかも。

04/16/07 18:15:11 changed by takanashi

  • milestone changed from OpenPNE2.8beta6 to OpenPNE2.10開発タスク.

2.10に渡します。

08/02/07 22:05:16 changed by kunitada

  • milestone changed from OpenPNE2.10開発タスク to OpenPNE2.10.

08/23/07 00:56:27 changed by tejima

  • component changed from 100,000,000PV【1億PVプロジェクト】 to pne-sysadmin.

08/28/07 16:44:42 changed by kunitada

  • owner changed from nobody to ebihara.
  • priority changed from major to critical.
  • description changed.

08/28/07 17:03:53 changed by ebihara

  • status changed from new to assigned.

やります

08/28/07 17:48:32 changed by ebihara

  • owner changed from ebihara to kunitada.
  • status changed from assigned to new.

r3781で対応しました。ご確認ください。

09/02/07 01:54:34 changed by ogawa

  • owner changed from kunitada to ogawa.
  • status changed from new to assigned.
  • version changed from 2.4 to 2.9.x.
  • milestone changed from OpenPNE2.10 to OpenPNE2.9.3.

確認します。

09/04/07 11:41:50 changed by ogawa

  • owner changed from ogawa to ebihara.
  • status changed from assigned to new.

r3817 mysql40の方ではストレージエンジンの指定はTYPEに統一する(MySQL4.0からENGINE使えるらしいが)


ちなみにMySQL5.1のマニュアルによると、「MAX_ROWS と AVG_ROW_LENGTH どちらのオプションも指定しなければ、テーブルの最大サイズはデフォルトで256 TB になります」とのことなので、ここでの指定は必要ないですね。

09/04/07 11:41:56 changed by ogawa

  • status changed from new to closed.
  • resolution set to fixed.