http://kwatch.houkagoteatime.net/blog/2014/12/20/postgresql-features/
tree-tips: MySQLã®å¤–部ã‚ーã¨ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ | MySQL
外部ã‚ーã§ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚’èµ·ã“ã™ã‚µãƒ³ãƒ—ルコード。 drop table if exists child; create table child (id int, pid int, primary key (id, pid))engine=innodb; drop table if exists parent; create table parent (id int, count int, primary key (id))engine=innodb; insert into parent values (1, 0); alter table child add foreign key (id) references parent (id); トランザクションA ------------------------------------- begin; insert into child val
ãƒãƒƒã‚¯å¾…ã¡ã§ãƒãƒžã‚‹å‰ã«çŸ¥ã‚ŠãŸã‹ã£ãŸMySQL InnoDBã®è¡Œãƒãƒƒã‚¯ã¨ãƒ†ãƒ¼ãƒ–ルãƒãƒƒã‚¯ã®æŒ™å‹•
æ•´åˆæ€§ã‚’ã—ã£ã‹ã‚Šã¨ã‚‰ãªã„ã¨ã„ã‘ãªã„処ç†ã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ã‹ã‘ã‚‹ã®ã§ã™ãŒã€ã©ã†ã‚‚トランザクションã®ãƒãƒƒã‚¯å¾…ã¡ã§ã‚¿ã‚¤ãƒ アウトã—ã¦ã—ã¾ã†ã“ã¨ãŒã‚るよã†ã§ã™ã€‚ java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction トランザクションã§ãƒ†ãƒ¼ãƒ–ル全体ã«ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã† è¦ã™ã‚‹ã«ã€ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’実行ã™ã‚‹ãŸã‚ã«ãƒãƒƒã‚¯ã‚’ç²å¾—ã—ãªã‘ã‚Œã°ã„ã‘ãªã„ãŒã€ä»–ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒãƒãƒƒã‚¯ã‚’æ¡ã£ã¦ã„ã¦ã€ãƒãƒƒã‚¯ãŒç²å¾—ã§ããªã„ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã“ã‚Œã®æ ¹æœ¬çš„ãªåŽŸå› ã¯ä½•ã‹ã¨èª¿ã¹ã¾ã™ã¨ã€InnoDBã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’使用ã™ã‚‹ã¨ãã«ã€è¡Œãƒãƒƒã‚¯ã§ã¯ãªãã€ãƒ†ãƒ¼ãƒ–ル全体ã«ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã†å ´åˆãŒã‚ã‚‹ã€ã¨ã„ã†ã¨ã“ã‚ã«ãŸã©ã‚Šç€ãã¾ã—ãŸã€‚ 「InnoDBã§è¡Œãƒãƒƒã‚¯/テーブルãƒãƒƒã‚¯ã«ãªã‚‹æ¡ä»¶ã€ã‚’見ãªãŒã‚‰ã€å°‘ã—試ã—ã¦ã¿ã¾ã™ã€‚ テーブ
percona-xtrabackup:start [Percona DokuWiki]
pt-online-schema-change¶ NAME¶ pt-online-schema-change - ALTER tables without locking them. SYNOPSIS¶ Usage¶ pt-online-schema-change alters a table’s structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. Add a column to sakila.actor: RISKS¶ Percona Toolkit is mature, proven i
MySQLã§ã‚µãƒ¼ãƒ“スåœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ルã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ やテーブルã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“テーブルã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“れらã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„深夜早æœå¸¯ã«ã‚µãƒ¼ãƒ“スをæ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚本日ã¯ãれを無åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ 基本的ãªã‚¢ã‚¤ãƒ‡ã‚¢ メンテナンス対象ã®å…ƒãƒ†ãƒ¼ãƒ–ルをコピーã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ルを作りã¾ã™ 仮テーブルã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ルã«å¯¾ã—ã¦è¡Œã‚れる更新処ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’記録ã—ã¦ãŠãã¾ã™ 仮テーブルã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’仮テーブルã«åæ˜ ã—ã¾ã™ 差分データã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ルã¨ä»®ãƒ†ãƒ¼ãƒ–ルを入れ替ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’考ãˆãŸæ–¹ã¯çµæ§‹ã„らã£ã—ゃるã®ã§ã¯ãªã„ã§ã—ょã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–れるã‹ã©ã†
ç„¡åœæ¢ã§ALTERã§ãã‚‹Percona-Toolkitã®online-schema-change - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
MySQL5.5ã‚’ã¾ã ã¾ã 絶賛利用ä¸ãªç§ã§ã™ã€‚ サービスをé‹ç”¨ã—ã¦ã„ã‚‹ã¨INDEXè¿½åŠ ã‚„ã‚«ãƒ©ãƒ è¿½åŠ ã‚’è¡Œã„ãŸã„è¦æœ›ãŒå¤šã€…発生ã—ã¾ã™ã€‚ ãれも無åœæ¢ã§ã€‚ MySQL5.6ã‹ã‚‰ã¯ç„¡åœæ¢ã§INDEXè¿½åŠ ã‚„ã‚«ãƒ©ãƒ è¿½åŠ ãŒã§ãるオンラインDDLãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã‚«ãƒ©ãƒ è¿½åŠ ã¯ã¾ã 色々制約ãŒã‚ã‚‹ã¿ãŸã„ã§ã™ãŒâ€¦ã€‚ http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html pt-online-schema-change MySQL5.5ã§ã‚‚ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’ã‚„ã‚ŠãŸã„ã®ã§ã€ 有åãªã€ŒPercona-Toolkitã€ã«åŒæ¢±ã•ã‚Œã¦ã„ã‚‹pt-online-schema-changeを利用ã—ã¦ã„ã¾ã™ã€‚ http://www.percona.com/software/percona-toolkit 通常ã¯ãƒãƒƒã‚¯ãŒæŽ›ã‹ã£ã¦ã—ã¾ã†ALTER
CSS-Based Tables: Modern Solutions | Smashing Magazine
Tables have got to be one of the most difficult objects to style in the Web, thanks to the cryptic markup, the amount of detail we have to take care of, and lack of browser compatibility. A lot of time could be wasted on a single table although it’s just a simple one. This article was written back in 2008 when the concept of responsive web design hasn’t been created just yet. You may want to check
jqGrid Demos
jqGrid 4.0 New search module, Tree Grid and SubGrid improvements, new colModel cellattr event and much more... Enjoy Please, support the jqGrid project by clicking on our sponsors ad!
1
メンテナンス
ãŠçŸ¥ã‚‰ã›
障害
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
ECMAScript 6 Tutorial
TechEmpower Framework Benchmarks
料金表ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã„ã‚ã„ã‚ - DesignWalker
{{#tags}}- {{label}}
{{/tags}}