Strict Standards: Declaration of action_plugin_blog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/blog/action.php on line 13

Strict Standards: Declaration of action_plugin_indexmenu::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/indexmenu/action.php on line 13

Strict Standards: Declaration of action_plugin_importoldchangelog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldchangelog/action.php on line 8

Strict Standards: Declaration of action_plugin_importoldindex::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldindex/action.php on line 8

Strict Standards: Declaration of action_plugin_include::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/include/action.php on line 19

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 211

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 421

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 594

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/cache.php on line 291

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/auth.php on line 154

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 73
8kbの壁 [開発チーム]

8KBの壁

テーブルの項目が厳しくなったら、text を varchar に変更。
ただし、varchar(86) 86×3=258バイト 以上は text 256バイト の方が容量を食いません

TEXT 型

256バイト x 31 + α で駄目です。

bgm_name30 OK
bgm_name31 NG
drop table test;
CREATE TABLE test (
  bgm_uniqnum bigint(20) unsigned NOT NULL auto_increment,

  bgm_name1 text NOT NULL,
  ・
  ・
  ・
  bgm_name31 text NOT NULL,

  PRIMARY KEY  (`bgm_uniqnum`),
  UNIQUE KEY `bgm_uniqnum` (`bgm_uniqnum`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

varchar(500)

1文字3バイトですね
500バイト x 3 x 6 + α で駄目です

bgm_name5 OK
bgm_name6 NG
drop table test;
CREATE TABLE test (
  bgm_uniqnum bigint(20) unsigned NOT NULL auto_increment,

  bgm_name1 varchar(500) NOT NULL,
  ・
  ・
  ・
  bgm_name6 varchar(500) NOT NULL,

  PRIMARY KEY  (`bgm_uniqnum`),
  UNIQUE KEY `bgm_uniqnum` (`bgm_uniqnum`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

varchar(80)

1文字3バイトですね
80 x 3 x 33 + αで駄目です

bgm_name32 OK
bgm_name33 NG
drop table test;
CREATE TABLE test (
  bgm_uniqnum bigint(20) unsigned NOT NULL auto_increment,

  bgm_name1 varchar(80) NOT NULL,
  ・
  ・
  ・
  bgm_name33 varchar(80) NOT NULL,

  PRIMARY KEY  (`bgm_uniqnum`),
  UNIQUE KEY `bgm_uniqnum` (`bgm_uniqnum`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;
8kbの壁.txt · 最終更新: 2010/07/27 15:47 (外部編集)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 81