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

snomof id:snomof

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

${{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}}

MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨
â€” ããƒ¼ã ã„ï¼ åˆä»£ALF (@soudai1025) 2015, 8æœˆ 24 ã¨ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³æŠ•ã’ã¦è¦‹äº‹ã«åˆºã•ã£ã¦ã‚‹ã®ã§ä»Šã‹ã‚‰è¨˜äº‹æ›¸ãã€‚ ä¸¡ã‚µã‚¤ãƒ‰ã«ã¯ã‹ãªã‚ŠåŽ³ã—ã„è©±ã‚‚ã™ã‚‹ãŒä¿ºã®æœ¬éŸ³ã‚’è´ã„ã¦ãŠã‘ï¼ˆé–¢ç™½å®£è¨€ï¼‰ ã¾ãæ´å²ã®é•·ã„RDBãªã®ã§ãŠäº’ã„ã®æ¯”è¼ƒè¨˜äº‹ã¯æ²¢å±±ã‚ã‚‹ã€‚ ãªã®ã§ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰(MySQL)ã¨ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹(PostgreSQL)ã ã¨ã‹VACUUMã ã£ã¦è©±ã¯ã—ãªã„ã€‚ ã‚€ã—ã‚å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸéš›ã®é•ã„ã‚’ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã™ã‚‹ã€‚ 1. SQLã®é•ã„ åŸºæœ¬çš„ã«MySQLã§ã‚„ã£ã¦ã„ãŸã“ã¨ã¯PostgreSQLå‡ºæ¥ã‚‹ã€‚ ã—ã‹ã—é–¢æ•°ã®æŒ™å‹•ã®é•ã„ã¯å¹¾ã¤ã‹ã‚ã‚‹ã€‚ ä¾‹ãˆã°æ™‚é–“ã‹ã‚‰æ›œæ—¥ã«è©²å½“ã™ã‚‹æ•°å—ã«å¤‰æ›ã—ãŸå ´åˆã« MySQLã€€â†’ã€€date_format(time,"%w")ã€€0ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ PostgreSQLã€€â†’ã€€to_char(time,'D')ã€€1ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ ãªã©æŒ™å‹•ã«äº’æ›æ€§
snomof 2015/08/25
postgres

mysql
ãƒªãƒ³ã‚¯
Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“è€…ã¯ã€MySQLã‚’ã©ã†ä½¿ã„ã€ä½•ã‚’èª²é¡Œã ã¨è€ƒãˆã¦ã„ã‚‹ã‹ï½žMySQL Connect 2013
Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“è€…ã¯ã€MySQLã‚’ã©ã†ä½¿ã„ã€ä½•ã‚’èª²é¡Œã ã¨è€ƒãˆã¦ã„ã‚‹ã‹ï½žMySQL Connect 2013 Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒé›†ã¾ã‚Šã€ãã‚Œãžã‚Œã®ç¤¾å†…ã®MySQLåˆ©ç”¨çŠ¶æ³ã€èª²é¡Œã€ã“ã‚Œã‹ã‚‰æœŸå¾…ã™ã‚‹æ–°æ©Ÿèƒ½ãªã©ã‚’èªžã£ãŸãƒ‘ãƒãƒ«ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ãŒã€9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚ŒãŸMySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ã®3ç•ªç›®ã®åŸºèª¿è¬›æ¼”ã¨ã—ã¦è¡Œã‚ã‚Œã¾ã—ãŸã€‚ ä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚ãƒ˜ãƒ“ãƒ¼ãªMySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ãˆã‚‹4ç¤¾ã¯ã€MySQLã«ã¤ã„ã¦ã©ã®ã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆã¦ã„ã‚‹ã®ã‹ã€åŸºèª¿è¬›æ¼”ã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Current MySQL Usage Models and Future Developments â”€â”€â”€â”€ ã¾ãšã¯ãã‚Œãžã‚Œã®æ‰€
snomof 2013/10/06
Twitter

Facebook

LinkedIn

PayPal

mysql

db

performance
ãƒªãƒ³ã‚¯
Twitterã®ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ï¼Œæ–°ãŸãªãƒ”ãƒ¼ã‚¯ã¸
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ ç¬¬2ç‰ˆ ä½•åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ŒPractical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootã‚’ä½¿ã£ãŸREST APIæ§‹ç¯‰ã®åŸºç¤Žã‚’å¦ã‚“ã ã€‚ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ããƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€é‡è¦ãªå¤‰...
snomof 2013/08/30
twitter

Ruby

MySQL

Java

performance

webservice

rails
ãƒªãƒ³ã‚¯
phpMyAdminã«ãŠã‘ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆå®Ÿè¡Œå¯èƒ½ãªè„†å¼±æ€§3ç¨®ç››ã‚Šåˆã‚ã›
8. configurationã¯ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã•ã‚ŒãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ Copyright Â© 2013 HASH Consulting Corp. 8 configuration=a:1:{s:7:"Servers";a:1:{i:0;a:6:{s:4:"h ost";s:9:"localhost";s:9:"extension";s:5:"mysql";s:1 2:"connect_type";s:3:"tcp";s:8:"compress";b:0;s:9:" auth_type";s:6:"config";s:4:"user";s:4:"root";}}} 9. configurationã‹ã‚‰PHPã‚½ãƒ¼ã‚¹ãŒä½œã‚‰ã‚Œã‚‹ Copyright Â© 2013 HASH Consulting Corp. 9 Array ( [Servers] => Array ( [0] => Array ( [h
snomof 2013/08/03
[

localhost

mysql

php

security

phpMyAdmin
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
snomof 2013/05/16
Rails

mysql

performance
ãƒªãƒ³ã‚¯
Pinterestã¯ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ï¼ˆå‰ç·¨ï¼‰ã€‚QCon Tokyo 2013
4æœˆ23æ—¥ã«éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒQCon Tokyo 2013ã€ã€‚æ€¥é€Ÿã«äººæ°—ã‚µã‚¤ãƒˆã¸ã¨æˆé•·ã—ãŸPinterestãŒã€ãã®è£ã§ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ã‚’Pinterestã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢è‡ªèº«ãŒç´¹ä»‹ã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒScaling Pinterestã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã¤ãã«ã‚·ã‚¹ãƒ†ãƒ ã®ã©ã“ã‹ãŒå£Šã‚Œã¦ã„ã‚‹ Pinterestã€Marty Weineræ°ã€‚ Pinterestã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ãƒ”ãƒ³ãƒœãƒ¼ãƒ‰ã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€Œãƒœãƒ¼ãƒ‰ã€ã‚’ä½œæˆã—ã¦ã€ãã“ã«ç”»åƒãªã©å¥½ããªã‚‚ã®ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã‚·ã‚§ã‚¢ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ã€Œãƒ”ãƒ³ã€ã²ã¨ã¤ã²ã¨ã¤ãŒç”»åƒã‚„ãƒªãƒ³ã‚¯ã«ãªã£ã¦ã„ã‚‹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„ãƒœãƒ¼ãƒ‰ã‚’ãƒ•ã‚©ãƒãƒ¼ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å†ãƒ”ãƒ³ã—ãŸã‚Šã‚¤ã‚¤ãƒã—ãŸã‚Šã€ã‚³ãƒ¡ãƒ³ãƒˆã®å…¥åŠ›ã‚‚ã§ãã‚‹ã€‚
snomof 2013/05/14
webservice

scalability

pinterest

mysql

DB
ãƒªãƒ³ã‚¯
DLNAã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰(MediaTomb) - CentOSã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
[root@centos ~]# wget http://jaist.dl.sourceforge.net/sourceforge/mediatomb/mediatomb-0.12.1.tar.gz â†ã€€MediaTombãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ â€»æœ€æ–°ç‰ˆã®URLã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã§ç¢ºèªã™ã‚‹ã“ã¨ [root@centos ~]# tar zxvf mediatomb-0.12.1.tar.gzã€€â†ã€€MediaTombå±•é–‹ [root@centos ~]# mkdir -p rpm build/{SOURCES,SPECS}ã€€â†ã€€RPMä½œæˆç”¨ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä½œæˆ [root@centos ~]# cp mediatomb-0.12.1/mediatomb.spec rpm build/SPECS/ â†ã€€mediatomb.specã‚’æ‰€å®šã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¸ã‚³ãƒ”ãƒ¼ [root@centos ~]# cp media
snomof 2013/01/14
mediatomb

linux

mysql

dlna

server
ãƒªãƒ³ã‚¯
waj.cc Â» Dumping triggers, routines, and tables in MySQL
snomof 2012/11/09
DB

mysql
ãƒªãƒ³ã‚¯
Transfer data between AWS RDS MySQL db's
What is the best way to transfer data out of one amazon rds mySQL instance into another aws account's RDS mySQL instance? This is for transf erring a website on Heroku to a different owner.
snomof 2012/11/06
mysql

DB

AWS

RDS
ãƒªãƒ³ã‚¯
Installing Rails on OS X Lion with HomeBrew, RVM and Mysql | Ruby, Rails, OSX and Linux fun
Bye Bye Macports, Welcome Homebrew Definition Homebrew: The missing package manager for OS X Why? well, the reality is, macports is not that good anymore. Once you have many packages installed and start updating, everything start to break apart, lotâ€™s of failing packages. Homebrew is very easy to install, itâ€™s fast and simple. That means you can make your own homebrew formula for your package so
snomof 2012/10/27
homebrew

rvm

mysql

programming

brew
ãƒªãƒ³ã‚¯
Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ™‚ã«çŸ¥ã£ã¦ãŠããŸã„ã“ã¨ | Macã¨ã‹ã®é›‘è¨˜å¸³
Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹éš›ã®æ³¨æ„ç‚¹ãªã©ã«ã¤ã„ã¦ã§ã™ã€‚MySQLè‡ªä½“ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«è¡¨ç¤ºã•ã‚Œã‚‹æ³¨æ„æ›¸ãã©ãŠã‚Šã«è¨å®šã™ã‚Œã°å•é¡Œãªã‹ã£ãŸã®ã§ã™ãŒã€èµ·å‹•ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§å°‘ã—ãƒˆãƒ©ãƒ–ã£ãŸã®ã§å‚™å¿˜éŒ²ã§ã™ã€‚ ãã®ä»–ã«ã‚‚ãƒ¡ãƒ¢ã£ã¦ãŠããŸã„ã“ã¨ãŒã‚ã£ãŸã®ã§è¨˜äº‹ã«ã—ã¾ã—ãŸã€‚Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸæ–¹ã®å‚è€ƒã«ãªã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨åˆæœŸè¨å®š ã¾ãšã¯MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒçµ‚äº†ã™ã‚‹ã¨ã€ä¸‹ã®ã‚ˆã†ã«è‰²ã€…ã¨è¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€ãã®é€šã‚Šã«é€²ã‚ã¦ã„ã‘ã°ã¨ã‚Šã‚ãˆãšä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã€ã“ã‚Œã‚‰ã®æ³¨æ„æ›¸ãã¯$ brew info mysqlã‚’å®Ÿè¡Œã™ã‚Œã°ã„ã¤ã§ã‚‚è¦‹ã‚Œã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨å®š ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒæ¸ˆã‚“ã ã‚‰ã€è¡¨ç¤ºã•ã‚ŒãŸå†…å®¹ã«å¾“ã£ã¦é †ã«è¨å®šã—ã¦ã„ãã¾ã™ã€‚æœ€åˆã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹å ´æ‰€ã®è¨å®šã‚’ã—ã¾ã™ã€‚ $ u
snomof 2012/10/27
MySQL

homebrew

Mac OS
ãƒªãƒ³ã‚¯
brew install mysql on macOS
I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysql_install_db. However when I try to connect to the server using: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass' I get: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied
snomof 2012/10/27
MySQL

Mac OS
ãƒªãƒ³ã‚¯
1