[B! mysql] mlhshinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mlhshino id:mlhshino

mysqlã«é–¢ã™ã‚‹mlhshinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Leopard: How to Install Wordpress
mlhshino 2010/03/29
"define('DB_HOST', 'localhost:/tmp/mysql.sock'); // 99% "

wordpress

mysql

mac

osx

apple

development

tips

tutorial
ãƒªãƒ³ã‚¯
InnoDBã®å¤–éƒ¨ã‚ãƒ¼ã‚’å‰Šé™¤ã™ã‚‹ã€‚ - è€ƒãˆå¾—ã‚‹æœ€é«˜ã‚’å¸¸ã«è¡Œã†
å¤–éƒ¨ã‚ãƒ¼ã®å‰Šé™¤ãŒALTERã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ç„¡ã‹ã£ãŸã‚“ã§èª¿ã¹ã¦ã¿ãŸã‚‰éŽåŽ»ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã«ãƒ’ãƒ³ãƒˆãŒã‚ã£ãŸã€‚ InnoDB ãŒ ALTER TABLE DROP FOREIGN KEY ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚å¤–éƒ¨ã‚ãƒ¼ã‚’ç ´æ£„ã™ã‚‹å ´åˆã¯ã€SHOW CREATE TABLE ã‚’ä½¿ã£ã¦ã€å†…éƒ¨ã§ç”Ÿæˆã•ã‚ŒãŸå¤–éƒ¨ã‚ãƒ¼ ID ã‚’æ¤œå‡ºã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ http://dev.mysql.com/doc/refman/4.1/ja/innodb-news-4-0-13.html -- å¤–éƒ¨ã‚ãƒ¼IDåã‚’å‚ç…§ã™ã‚‹ã€‚ SHOW CREATE TABLE tbl_title;â†‘ã‚’å®Ÿè¡Œã™ã‚‹ã¨â†“ã®çµæžœãŒè¿”ã£ã¦ãã‚‹ã€‚ã“ã®å ´åˆã ã¨å¤–éƒ¨ã‚ãƒ¼IDã¯fk_tbl_title_tbl_categoryã«ãªã‚‹ã€‚ ï¼š CONSTRAINT `fk_tbl_title_tbl_category` FOREIGN KEY (`category_i
mlhshino 2010/02/08
å¤–éƒ¨ã‚ãƒ¼ ID ã‚’æŒ‡å®šã—ã¦å‰Šé™¤ã€‚

mysql

database

development

tips
ãƒªãƒ³ã‚¯
Ruby on Rails + MySQL ã§å…¨æ–‡æ¤œç´¢ - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ Ruby on Rails ã¨ MySQL ã‚’ä½¿ã£ã¦æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã†æ–¹æ³•ã‚’è¨˜è¿°ã™ã‚‹ã€‚Ruby on Rails ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 2.0.2ã€MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.0.67ã€Tritonn ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.0.12ã€Hyper Estraier ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.4.10 ã‚’ä½¿ç”¨ã—ãŸã€‚ã‚µãƒ³ãƒ—ãƒ«ã®æ–‡ç« ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ã€ã‚ã‚‰ã‚†ã‚‹æ—¥æœ¬äººã«ã¨ã£ã¦æ¥µã‚ã¦èº«è¿‘ãªè‘—ä½œæ¨©åˆ‡ã‚Œæ–‡ç« ã§ã‚ã‚‹ã€Žãƒ‰ã‚°ãƒ©ãƒ»ãƒžã‚°ãƒ©ã€ã¨ã€Žé»’æ»é¤¨æ®ºäººäº‹ä»¶ã€ã‚’åˆ©ç”¨ã—ãŸã€‚å‡¦ç†ã®ãŸã‚ã«æ•´å½¢ã—ãŸãƒ‡ãƒ¼ã‚¿ã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã«æ·»ä»˜ã—ã¦ãŠãã€‚ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã§ã¯ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é™¤ãã§ãã‚‹ã ã‘ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã€ãã®çµæžœã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã®æœ€å¾Œã«è¨˜è¼‰ã™ã‚‹ã€‚ ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ Rails ã§ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ will_paginate ã¨ã„ã† plugin ã¯ ActiveRecord ã«æ¨™æº–ã§ã¤
mlhshino 2009/06/14
ãªã‚“ã¨ã„ã†è‰¯è¨˜äº‹ã€‚

rubyonrails

mysql

tritton

search

tips

ruby

development

programming

tutorial

code
ãƒªãƒ³ã‚¯
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨(mysqlhotcopy) - Fedoraã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œãªã†ã€‚ ã“ã“ã§ã¯ã€MySQLå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒ¼ãƒãƒ¼å†…ã®åˆ¥ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¸ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã€‚ [root@fedora ~]# vi mysql-backup.shã€€â†ã€€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆä½œæˆ #!/bin/bash PATH=/usr/local/sbin:/usr/bin:/bin # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª BACKDIR=/backup/mysql # MySQLrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ ROOTPASS=Mysqlrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†ä½œæˆ rm -rf $BACKDIR mkdir -p $BACKDIR # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åå–å¾— DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /` # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— for dbname
mlhshino 2009/03/31
MySQL backup scripts.

backup

development

server

mysql
ãƒªãƒ³ã‚¯
ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã§å¿«é©MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç”Ÿæ´»
MySQL 5.1ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ä¾¿åˆ©ãªæ©Ÿèƒ½ã¨ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚MySQL 5.0ã§ã‚‚åˆ©ç”¨å‡ºæ¥ãŸã®ã ãŒã€å®Ÿé¨“çš„ãªæ©Ÿèƒ½ã¨ã„ã†ä½ç½®ã¥ã‘ã§ã‚ã‚Šã€æè¼‰ã•ã‚Œã¦ã„ãŸã®ã¯GPLç‰ˆã®MySQL Community Serveré™å®šã ã£ãŸã€‚MySQL 5.1ã‹ã‚‰ã¯å…¨ã¦ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®çŠ¶æ…‹ï¼ˆç‰¹ã«çŠ¶æ…‹é·ç§»ã‚„ãƒªã‚½ãƒ¼ã‚¹ã®æ¶ˆè²»çŠ¶æ³ï¼‰ã‚’è©³ç´°ã«åˆ†æžã§ãã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã ã€‚MySQL ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®æ©Ÿèƒ½ã¨ã„ã£ã¦è‰¯ã„ã ã‚ã†ã€‚ã¨ã„ã†ã‚ã‘ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã—ã‚ˆã†ã€‚ MySQLã‚µãƒ¼ãƒã«ãƒã‚°ã‚¤ãƒ³ã—ãŸã‚‰ã€ã¾ãšã¯æ¬¡ã®ã‚ˆã†ã«ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã€‚ mysql> SET profiling=1; ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®æƒ…å ±ãŒè¨˜éŒ²ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚æ¬¡ã«ã€åˆ†æžã—ãŸã„ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã€‚ã‚¯ã‚¨ãƒªã¯ãªã‚“ã§ã‚‚ã„ã„
mlhshino 2009/02/04
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã®ãŸã‚ã«ã€‚

development

tips

tutorial

database

programming

mysql

db

optimization
ãƒªãƒ³ã‚¯
Unexpected database connection problem. Hibernate broken pipe. | kobyleha.com
mlhshino 2008/07/17
Configuration example to prevent broken pipe error.

database

hibernate

java

mysql

tips
ãƒªãƒ³ã‚¯
Scaling Rails Presentation (From Scribd Launch) | PDF | Ruby On Rails | Cache (Computing)
This document summarizes a presentation about scaling Ruby on Rails applications. It discusses how fragment caching can provide a significant performance boost. It also describes how the comâ€¦
mlhshino 2008/05/03
How Scribd scales Ruby on Rails.

mysql

ruby

rubyonrails

scalability
ãƒªãƒ³ã‚¯
Leopardã«MySQL-pythonã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ ãŠåå‰.com ã‹ã‚‰å–å¾—ã•ã‚Œã¾ã—ãŸã€‚ ãŠåå‰.com ã¯ GMOã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚°ãƒ«ãƒ¼ãƒ—(æ ª) ãŒé‹å–¶ã™ã‚‹å›½å†…ã‚·ã‚§ã‚¢No.1ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ â€»è¡¨ç¤ºä¾¡æ ¼ã¯ã€å…¨ã¦ç¨Žè¾¼ã§ã™ã€‚ â€»ã‚µãƒ¼ãƒ“ã‚¹å“è³ªç¶æŒã®ãŸã‚ã€ä¸€æ™‚çš„ã«å¯¾è±¡ã¨ãªã‚‹æ–™é‡‘ã¸ä¸€å®šå‰²åˆã®ã€Œã‚µãƒ¼ãƒ“ã‚¹ç¶æŒèª¿æ•´è²»ã€ã‚’åŠ ç®—ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚
mlhshino 2008/05/03
è§£æ±ºã€‚Port ã§ MySQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŸã‚‰ã“ã†ãªã‚‹ã®ã‹ãªã€‚

mysql

python

tips

tutorial
ãƒªãƒ³ã‚¯
DiggÂ Architecture - High Scalability -
Update 4:: Introducing Diggâ€™s IDDB Infrastructure by Joe Stump. IDDB is a way to partition both indexes (e.g. integer sequences and unique character indexes) and actual tables across multiple storage servers (MySQL and MemcacheDB are currently supported with more to follow). Update 3:: Scaling Digg and Other Web Applications. Update 2:: How Digg Works and How Digg Really Works (wear ear plugs). Br
mlhshino 2008/05/02
How it works and history of Digg.

architecture

database

development

digg

lamp

language

mysql

php

programming

scalability
ãƒªãƒ³ã‚¯
ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢å¢—è¨ - shinno(éˆ´æœ¨æ…Žä¹‹ä»‹)ã®æ—¥è¨˜
é–‹ç™ºè€…ãƒ–ãƒã‚°ã§ã‚‚ã‹ã‹ã‚Œã¦ã¾ã™ãŒã€æœ¬æ—¥5/11ã«ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢å¢—è¨ã‚’è¡Œã„ã¾ã—ãŸã€‚å®Ÿã¯ä»Šæœˆã®å¢—è¨ã¯3ãƒ•ã‚§ãƒ¼ã‚ºã«åˆ†ã‘ã¦å®Ÿæ–½ã—ã¦ãŠã‚Šã€ä»Šå›žã¯ãã®2ãƒ•ã‚§ãƒ¼ã‚ºç›®ã‚’è¡Œã„ã¾ã—ãŸã€‚ã–ã£ã¨æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ãƒ•ã‚§ãƒ¼ã‚º1. æ¤œç´¢DBåˆ†é›¢ + sennaãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ— å…ˆæ—¥ã®å‹‰å¼·ä¼šã§ã‚‚ãŠè©±ã—ãŸã¨ãŠã‚Šã€æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã‚’å®Ÿç¾ã™ã‚‹ã«ã‚ãŸã£ã¦ senna ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ãã®sennaã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒæ˜¨å¹´ã®ã¨ã‚ã‚‹å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã ã£ãŸã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚Šã€ç¨€ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ãŒç ´æã™ã‚‹æ—¢çŸ¥ã®ãƒªã‚¹ã‚¯ã‚’å•ã‚“ã§ã„ãŸãŸã‚ã€ãã®å•é¡ŒãŒè§£æ±ºã•ã‚ŒãŸæ–°ã—ã„sennaã¨ã€æœ€è¿‘sennaã¨ã¯ç‹¬ç«‹ã—ã¦é–‹ç™ºãŒè¡Œã‚ã‚Œã¦ã„ã‚‹MySQLãƒã‚¤ãƒ³ãƒ‡ã‚£ãƒ³ã‚° tritonn ã¸ã®å¤‰æ›´ã‚’ã‚ã‚ã›ã¦è¡Œã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã¾ãŸã€ä»¥å‰ã‹ã‚‰ã®é‹ç”¨ã«å½“ãŸã£ã¦ã€éšœå®³ã®åˆ‡ã‚Šåˆ†ã‘ã‚„ã€æ¤œç´¢ã®è² è·ã®åˆ†é›¢ã‚’ã—ãŸã‹ã£ãŸãŸã‚ã€æ–°ã—ããƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã“ã®å¢—å¼·ã«ã‚ˆã£ã¦æ—¢å˜ã®DB
mlhshino 2007/05/14
senna ã‚ˆã•ã’ã€‚

senna

db

search

mysql

server

development

programming

niconicodouga

niwango
ãƒªãƒ³ã‚¯
gMap 0.7
If you landed here, that means the app you searched for is no longer supported by it's developer. Give your respect and search for alternative apps from MacUpdate collection.
mlhshino 2007/05/03
To manage MySQL databases.

mysql

database

software

tools

applications

formac

mac

osx

apple

development
ãƒªãƒ³ã‚¯
1