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

hibinotatsuya id:hibinotatsuya

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

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

ç¬¬167å›žã€€M1æè¼‰Macã®Dockerã§MySQLã‚’å‹•ã‹ã—ã¦ã¿ã‚‹ | gihyo.jp
2020å¹´11æœˆã«ç™ºè¡¨ã•ã‚ŒãŸMacBook Airã‹ã‚‰æè¼‰ã•ã‚Œã¦ã„ã‚‹M1ãƒãƒƒãƒ—ã¨ã„ã†CPUãŒã‚ã‚Šã¾ã™ã€‚ã“ã¡ã‚‰ã¯å¾“æ¥ã®Macã«æè¼‰ã•ã‚Œã¦ã„ãŸCPUãŒx86/64ã®å‘½ä»¤ã‚»ãƒƒãƒˆã¨ã¯ç•°ãªã‚Šã€ARMã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ã¨ã„ã†é•ã„ãŒã‚ã‚Šã¾ã™ã€‚ç™ºå£²ã‹ã‚‰1å¹´ä»¥ä¸ŠãŸã¡ã€ã‚¤ãƒ³ãƒ†ãƒ«è£½ã®CPUã‚’æè¼‰ã—ãŸMacãŒãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã‹ã‚‰ç„¡ããªã£ãŸã®ã§ã€æ¬¡ã‚‚ã—Macã‚’è³¼å…¥ã™ã‚‹ã¨ãªã‚‹ã¨M1ãƒãƒƒãƒ—æè¼‰ã®Macã‚’è³¼å…¥ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€ãã®éš›ã«å•é¡ŒãŒèµ·ã“ã‚ŠãŒã¡ãªDockerã§ã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰ã«ã¤ã„ã¦ã€ç´¹ä»‹ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Dockerã§MySQLã‚’å‹•ã‹ã—ã¦ã¿ã‚‹ ã¾ãšã¯ã€dockerã‚³ãƒžãƒ³ãƒ‰ã§MySQLã‚’æŒ‡å®šã—ã¦å‹•ã‹ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ % docker run -p 3307:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest Unable
hibinotatsuya 2023/12/01
mysql

mac
ãƒªãƒ³ã‚¯
[Laravel] FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸå…¨æ–‡æ¤œç´¢ â€“ ç«¯ãã‚Œãƒ—ãƒã‚°ãƒ©ãƒžã®å‚™å¿˜éŒ²
Laravelã§FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸæ¤œç´¢ã‚’è¡Œã†ãŸã‚ã®ãƒ¡ãƒ¢ã€‚ã–ã£ãã‚Šã€‚ ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ¤œç´¢å¯¾è±¡ãƒ¯ãƒ¼ãƒ‰ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰(keywords)ã‚’å®šç¾©ã—ã¦ã€FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ¯ã‚‹ã€‚ class CreateArticlesTable extends Migration { public function up() { Schema::create('articles', function (Blueprint $table) { $table->increments('id'); .... $table->string('keywords');ã€€//æ¤œç´¢å¯¾è±¡ãƒ¯ãƒ¼ãƒ‰ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ $table->timestamp('published_at'); } DB::statement('ALTER TABLE articles ADD FULLTEXT(
hibinotatsuya 2023/01/12
Laravel

mysql
ãƒªãƒ³ã‚¯
Bulk insertã§ã‚‚20æ™‚é–“ä»¥ä¸Šã‹ã‹ã£ã¦ã„ãŸMySQLã¸ã®ã‚¤ãƒ³ã‚µãƒ¼ãƒˆå‡¦ç†ã‚’1æ™‚é–“ä»¥å†…ã«ã™ã‚‹ - ã‚¨ãƒ ã‚¹ãƒªãƒ¼ãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°
ã“ã®è¨˜äº‹ã¯ã‚¨ãƒ ã‚¹ãƒªãƒ¼ Advent Calendar 2022ã®30æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ å‰æ—¥ã¯ id:kijuky ã«ã‚ˆã‚‹ ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ã®Googleã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®ä¼‘æš‡äºˆå®šä¸€è¦§ã‚’ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆ+GASã§ä½œã£ãŸ ã§ã—ãŸã€‚ AIãƒ»æ©Ÿæ¢°å¦ç¿’ãƒãƒ¼ãƒ ã®åŒ—å·(@kitagry)ã§ã™ã€‚ ä»Šå›žã¯MySQLã¸ã®ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã‚’20å€ä»¥ä¸Šé«˜é€ŸåŒ–ã—ãŸè©±ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»•äº‹ã‚’ã¡ã‚ƒã‚“ã¨ã—ã¦ã‚‹ã‹è¦‹å¼µã‚‹çŒ« TL; DR ã¯ã˜ã‚ã« ä»Šå›žã®ãƒ†ãƒ¼ãƒ–ãƒ« ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ç„¡åŠ¹åŒ–ã™ã‚‹ è¿½è©¦ LOAD DATA INFILE è¿½è©¦ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ£è¦åŒ– ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä¸€æ™‚çš„ã«å‰¥ãŒã™ ã¾ã¨ã‚ We are hiring!! TL; DR ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ã‚ªãƒ•ã«ã™ã‚‹ LOAD DATA INFILEã‚’ä½¿ã† ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä¸€æ™‚çš„ã«æ¶ˆã™ ã¯ã˜ã‚ã« AIãƒ»æ©Ÿæ¢°å¦ç¿’ãƒãƒ¼ãƒ ã§ã¯ã‚µã‚¤ãƒˆãƒˆãƒƒãƒ—ã‹ã‚‰ã‚¢ãƒ—ãƒªã«è‡³ã‚‹ã¾ã§å¤šãã®æŽ¨è–¦ã‚·ã‚¹ãƒ†ãƒ ãŒã‚ã‚Šã¾ã™ã€‚ ãã“ã§ã¯æŽ¨è–¦ãƒ
hibinotatsuya 2022/12/31
mysql
ãƒªãƒ³ã‚¯
PostGISãƒ¦ãƒ¼ã‚¶ãŒMySQL 8ã®ç©ºé–“æ‹¡å¼µæ©Ÿèƒ½ã‚’å°‘ã—è§¦ã£ã¦ã¿ãŸ
ã¯ã˜ã‚ã« https://www.slideshare.net/yoyamasaki/mysql-57gis-80822317 ã‚’è¦‹ã¦ã€Œã©ã†ã‚‚MySQLã®ç©ºé–“æ‹¡å¼µã®æ©Ÿèƒ½ãŒéšåˆ†è‰¯ããªã£ãŸã€ã‚ˆã†ã ã¨çŸ¥ã‚Šã¾ã—ãŸã€‚ã¾ãŸã€https://www.slideshare.net/NorvaldRyeng/mysql-80-gis-are-you-ready ã§ã€ã‚‚ã†å°‘ã—è¸ã¿è¾¼ã‚“ã èª¬æ˜Žã‚‚ã‚ã‚Šã¾ã—ãŸã€‚ ã“ã‚Œã¯ã¡ã‚‡ã£ã¨è§¦ã£ã¦ã¿ãªã‘ã‚Œã°ã„ã‘ãªã„ã¨æ€ã£ãŸæ¬¡ç¬¬ã§ã™ã€‚ ä½¿ç”¨ã—ãŸã‚‚ã® åŸºæœ¬çš„ã« MySQL 8.0.3-rc Windows x64ç”¨ zipç‰ˆã‚’ä½¿ã„ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¯ http://www.uetyi.com/server-const/entry-1650.html ã‚’è¦‹ã¾ã—ãŸã€‚ ST_Transf orm()ã®è¨˜è¿°ã§ã¯ã€MySQL 8,0.20 Windows x64ç”¨ zipç‰ˆã‚‚ä½¿ç”¨ã—ã¦ã„ã¾ã™(
hibinotatsuya 2022/11/14
mysql

map
ãƒªãƒ³ã‚¯
GoogleMapã‚’ä½¿ã£ãŸãƒ—ãƒãƒ€ã‚¯ãƒˆä½œæˆã®ãŸã‚ã«SRIDã€ç·¯åº¦çµŒåº¦ã€GeoHashã€Geometryã‚’MySQL8.0ã§ç†è§£ã™ã‚‹ - orug8mâ€™s blog
æ¦‚è¦ï¼†ç›®çš„ MySQL8.0ã®Geoé–¢æ•°ã‚’ä½¿ã†ã¨ã€ãƒ¬ã‚³ãƒ¼ãƒ‰åŒå£«ã®è·é›¢è¨ˆç®—ã€Polygonã®ä¸ã«PointãŒå«ã¾ã‚Œã¦ã„ã‚‹ã‹ãªã©ã‚‚SQLã§è¨ˆç®—ã§ãã‚‹ã¨ã„ã†ã“ã¨ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ åœ°å›³ã‚’Webã‚¢ãƒ—ãƒªã«ä¹—ã›ã‚‹ã¨ãã®SRIDã¯ã©ã‚Œã‹ã€Â GeoHashã€ Geometryåž‹ã¨ã¯ãªã«ã‹ã€Â Google Mapã®ä»•æ§˜ã®ç†è§£ãŒé€²ã‚€ã¨å¹¸ã„ã§ã™ã€‚ å¾ŒåŠã§ã¯å®Ÿéš›ã«SQLã‚’å©ã„ã¦ã€GeoHashã€POINTåž‹ä¸¡æ–¹ã§ãƒ¬ã‚³ãƒ¼ãƒ‰é–“ã®è·é›¢ã‚’æ¸¬ã£ã¦ã¿ã¦ã„ã¾ã™ã€‚ å‹•ä½œç¢ºèªã—ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ MySQL 8.0.20 Ruby on Rails 6.0.3.2 äº‹å§‹ã‚ Google Mapã«ãƒ”ãƒ³ã‚’ç½®ããƒ—ãƒãƒ€ã‚¯ãƒˆã‚’ä½œã£ã¦ã„ã¾ã—ãŸã€‚ ï¼ˆã‚¤ãƒ¡ãƒ¼ã‚¸ï¼šæµ…è‰å¯ºã‹ã‚‰200ãƒ¡ãƒ¼ãƒˆãƒ«ä»¥å†…ã«ã‚ã‚‹è¦³å…‰ã‚¹ãƒãƒƒãƒˆã®ãƒ”ãƒ³ã‚’ç«‹ã¦ã‚‹ã€ç‰ï¼‰ ã‚„ã‚ŠãŸã„ã“ã¨ MySQLã«åœ°ç‚¹ã®æƒ…å ±ã‚’ä¿å˜ã—ã¦ã€FEã‹ã‚‰RoRãªã©APIçµŒç”±ã§åœ°ç‚¹ã‚’å–å¾—ã—ãŸã„ã€‚ SRIDã¨ã„ã†æ¦‚å¿µã‚’çŸ¥ã‚ŠãŸã„ã€æ´»
hibinotatsuya 2022/11/11
mysql

map
ãƒªãƒ³ã‚¯
ã€MySQLã€‘Geometryåž‹(å¹³é¢ç©ºé–“ãƒ‡ãƒ¼ã‚¿åž‹)ã‚’ä½¿ã£ã¦ã¿ãŸ
ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«æµ®å‹•å°æ•°ç‚¹ã‚’æ‰±ãˆã‚‹åž‹ã§ã‚‚ç·¯åº¦çµŒåº¦ã¯ç®¡ç†ã§ãã€Geometryåž‹ã‚’ä½¿ã£ã¦ä½ç½®æƒ…å ±ã‚’ç®¡ç†ã™ã‚‹å¿…è¦ã¯ãªã„ã€‚ ã—ã‹ã—ã€ã‚·ã‚¹ãƒ†ãƒ ã®è¦ä»¶ã«ã‚ˆã£ã¦ã¯Geometryåž‹ã®æ–¹ãŒã‚ˆã„å ´åˆã‚‚ã‚ã‚‹ãŸã‚ã€ä½¿ç”¨ç”¨é€”ã‚’ç´¹ä»‹ã—ã‚ˆã†ã‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¡ãƒªãƒƒãƒˆãƒ»ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ â€»ä½¿ã£ã¦ã¿ã¦ã®æ„Ÿæƒ³ ãƒ¡ãƒªãƒƒãƒˆ åœ°ç‚¹é–“ã®è·é›¢ã‚’æ±‚ã‚ã‚‹ã“ã¨ãŒã§ãã‚‹ ã“ã‚Œã«å°½ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ãŸã è·é›¢ã‚’æ±‚ã‚ã‚‹ã ã‘ã§ã¯ãªãã€ã€Œæ±‚ã‚ãŸè·é›¢å†…ã®ã€‡ã€‡ã‚’æŠ½å‡ºã€ã€Œè‡ªåˆ†ã®ä½ç½®ã‹ã‚‰æœ€çŸã®è·é›¢ã«ã‚ã‚‹ã€‡ã€‡ã‚’æŽ¢ã™ã€ãªã©å¿œç”¨ãŒå¯èƒ½ã§ã‚ã‚‹ã€‚ ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ ä»–ã®åž‹ã¨é•ã£ã¦ç‰¹æ®Šãªä½¿ã„æ–¹ã«ãªã‚‹ ä»–ã®åž‹ã®ã‚ˆã†ã«å˜ç´”ãªINSERTã‚„SELECTã¯ä½¿ç”¨ã§ããªã„ã®ã§ã€MySQLä¸Šã§å®Ÿè¡Œã§ãã‚‹å½¢å¼ã«SQLã‚’ä½œæˆã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ MySQLä¸Šã§ç›´æŽ¥å®Ÿè¡Œã™ã‚‹å ´åˆã¯å•é¡Œãªã„ã‹ã‚‚ã—ã‚Œãªã„ãŒå®Ÿéš›ã«é‹ç”¨ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ãã‚“ãªã“ã¨ã‚’ã™ã‚‹ã¯ãšã¯ãªã„ã€‚ ä½•ã‚‰ã‹ã®è¨€èªžã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ç”¨ã—ã¦ç”»é¢ç‰ã‚’ç”Ÿæˆ
hibinotatsuya 2022/11/11
mysql
ãƒªãƒ³ã‚¯
ã€ä½ç½®æƒ…å ±ã€‘MySQLã®geometryåž‹ã‚’ä½¿ã£ã¦ç·¯åº¦çµŒåº¦ã®2ç‚¹é–“è·é›¢ã‚’kmã§è¨ˆç®—ãƒ»ç®—å‡ºã™ã‚‹æ–¹æ³•ã€ST_GEOMFROMTEXTã€‘
ã€ä½ç½®æƒ…å ±ã€‘MySQLã®geometryåž‹ã‚’ä½¿ã£ã¦ç·¯åº¦çµŒåº¦ã®2ç‚¹é–“è·é›¢ã‚’kmã§è¨ˆç®—ãƒ»ç®—å‡ºã™ã‚‹æ–¹æ³•ã€ST_GEOMFROMTEXTã€‘
hibinotatsuya 2022/11/10
mysql
ãƒªãƒ³ã‚¯
MySQL InnoDB ã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’ã‚µã‚¯ãƒƒã¨è©¦ã—ã¦ã¿ã¾ã—ãŸ
ã“ã‚“ã«ã¡ã¯ã€GMOã‚¢ãƒ‰ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ã®K.Mã§ã™ã€‚ æœ€è¿‘ã¯ä¹…ã—ã¶ã‚Šã«MySQLã‚’ä½¿ã£ã¦ã¾ã™ã€‚ ãã†ã„ãˆã°MySQLã¨ã„ãˆã°ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.7ã‹ã‚‰InnoDBã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã«æ—¥æœ¬èªžãƒ‘ãƒ¼ã‚µãƒ¼ãŒæè¼‰ã•ã‚Œã¨ã¦ã‚‚ä½¿ã„ã‚„ã™ããªã£ãŸã¨èžã„ã¦ã„ãŸã®ã§ã€æœ¬æ—¥ã¯ãã‚Œã‚’è©¦ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»¥å‰ã¯ã‚µãƒ¼ãƒ“ã‚¹ã§æœ¬æ ¼çš„ãªå…¨æ–‡æ¤œç´¢ã‚’ã‚„ã‚ŠãŸã„ã¨æ€ã£ãŸã‚‰ã€Elasticsearchãªã©å°‚ç”¨ã®å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç«‹ã¦ãŸã‚Šã¨ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢æ§‹æˆãŒä¸€æ®µãƒªãƒƒãƒã«ãªã‚‹ã‚ˆã†ãªå°è±¡ã‚‚ã‚ã‚Šã¾ã—ãŸãŒã€ã‚‚ã†å°‘ã—ãŠæ‰‹è»½ã«ã€æ—¢å˜RDBMSã‹ã‚‰SELECTã—ã¦ãã‚‹ãã‚‰ã„ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã‚¹ãƒ¢ãƒ¼ãƒ«ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸã„ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ã‚‚çµæ§‹ã‚ã‚Šãã†ã§ã™ã€‚ ãã†ã„ã£ãŸã¨ãã«æ¤œè¨Žã§ãã‚‹ä¸€ã¤ã®é¸æŠžè‚¢ã«ãªã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ æ—¢å˜ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ¤œç´¢ã—ã¦ã¿ã¾ã™ MySQL5.7ã‹ã‚‰æ—¥æœ¬èªžãƒ‘ãƒ¼ã‚µãƒ¼ã¨ã—ã¦N-gramã¨MeCabãŒä½¿ãˆã¾ã™ã€‚ç‰¹ã«N-gramã®å ´åˆã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰
hibinotatsuya 2022/01/06
mysql
ãƒªãƒ³ã‚¯
Data Models
Data Models: A Comprehensive Guide to Structuring Information for Optimal Insights and Decision-Making In the realm of data management, the use of effective data models plays a pivotal role in organizing and representing information in a structured and meaningful way. Data models serve as the blueprint for databases, facilitating efficient data storage, retrieval, and analysis. This article delves
hibinotatsuya 2021/04/21
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶ä½œæˆ [memo] - Qiita
GRANT SELECT ON [DB name].* to 'username'@'localhost' IDENTIFIED BY 'jaLMw8&5nfzN_#4y';
hibinotatsuya 2021/03/26
mysql
ãƒªãƒ³ã‚¯
MySQL ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªæ”¹å–„ åˆå¿ƒè€…å‘ã‘ - Qiita
Register as a new user and use Qiita more conveniently You get articles that match your needsYou can efficiently read back useful informationWhat you can do with signing up
hibinotatsuya 2021/03/26
mysql
ãƒªãƒ³ã‚¯
MySQLã§ãƒãƒƒã‚¯ã‚’ç‰¹å®šã—ã€å¼·åˆ¶çµ‚äº†ã™ã‚‹
MySQLã§ãƒãƒƒã‚¯ãŒç™ºç”Ÿã—ã¦ã„ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’ç‰¹å®šï¼ˆï¼‹å¼·åˆ¶çµ‚äº†ï¼‰ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ã‚ˆãå¿˜ã‚Œã‚‹ã®ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ é–“é•ã£ã¦ã„ã‚‹ã¨ã“ã‚ã¯ãƒžã‚µã‚«ãƒªãŠå¾…ã¡ã—ã¦ã„ã¾ã™ã€‚ ãƒãƒƒã‚¯çŠ¶æ…‹ã®ç¢ºèªæ–¹æ³• 1.ä»¶æ•°ã ã‘ mysql> SELECT trx_rows_locked FROM information_schema.INNODB_TRX; +-----------------+ | trx_rows_locked | +-----------------+ | 1 | +-----------------+ 1 row in set (0.00 sec) mysql> SHOW ENGINE INNODB STATUS\G ... ------------ TRANSACTIONS ------------ Trx id counter 709 Purge done for trx's n:o < 708
hibinotatsuya 2021/03/15
mysql
ãƒªãƒ³ã‚¯
MySQL ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDL(ãƒãƒƒã‚¯ãªã—ã«ã‚ˆã‚‹ã‚µãƒ¼ãƒ“ã‚¹ç„¡åœæ¢ã§DDLã‚’æµã™æ–¹æ³•) ãƒ‘ã‚¿ãƒ¼ãƒ³é›† - Qiita
è·å ´ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ã‚ˆã‚Šå‹‰å¼·ã—ãŸã»ã†ãŒã‚ˆã„ã¨æ„Ÿã˜ãŸã®ã§ã‚¤ãƒ³ãƒ—ãƒƒãƒˆã—ãŸã“ã¨ã‚’Qiitaã«ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã—ã¦ã¿ãŸã€‚ ä»¥ä¸‹ã®ãƒªãƒã‚¸ãƒˆãƒªã§å®Ÿè·µã‚‚åˆã‚ã›ã¦è¡Œã£ãŸã€‚ è¨˜äº‹ã®ä¸ã§å‡ºã¦ãã‚‹ã‚³ãƒ¼ãƒ‰ãªã©ã¯ã“ã¡ã‚‰ã§å‚ç…§ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ https://github.com/d0riven/learning_online_ddl_pattern ä»Šå›žã¯MySQLã¨ã„ã†DBMSã«é™å®šã—ã¦ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ãŒã€ä»–ã®DBMSã§ã‚‚ä½¿ãˆã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã„ãã¤ã‹ã‚ã‚‹ã¯ãšãªã®ã§PostgreSQLã‚„Oracleã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹äººãŒèªã‚“ã§ã‚‚ãŸã‚ã«ãªã‚‹ã¨ã¯æ€ã†ã€‚ æƒ³å®šèªè€… MySQLã‚’æ™®æ®µã‹ã‚‰è§¦ã£ã¦ã„ã‚‹äºº å¯ç”¨æ€§ã®é«˜ã•ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹ç”¨ãƒ»é–‹ç™ºã—ã¦ã„ã‚‹äºº å¤ãã‹ã‚‰ã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã®ãŸã‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¶³å›žã‚Šã‹ã‚‰æ‰‹ã‚’ã¤ã‘ã¦ã„ããŸã„äºº ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã®ã‚„ã‚Šæ–¹ã‚’çŸ¥ã‚‰ãªã„äººãƒ»çŸ¥ã£ã¦ã„ã¦ã‚‚è‰²ã€…ãªãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹
hibinotatsuya 2020/04/08
mysql
ãƒªãƒ³ã‚¯
MySQL8.0ã§Sequel Proã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
hibinotatsuya 2019/03/30
sequel pro

mysql
ãƒªãƒ³ã‚¯
LINEã®MySQLé‹ç”¨ã«ã¤ã„ã¦ ä¿®æ£ç‰ˆ
1. LINEã®MySQLé‹ç”¨ã«ã¤ã„ã¦Kentaro Kitagawa, IT service center - database department - db1 team DB Tech Showcase 2018 2018/09/20 2. ï¬ åŒ—å· å¥å¤ªéƒŽ / Kentaro Kitagawa ï¬ LINEæ ªå¼ä¼šç¤¾ ï¬ IT Service Center - Database dept.- DB1 Team ï¬ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ ï¬ MySQL / Oracle Database / Redis ï¬ MySQLé“æ™®è«‹: http://gihyo.jp/dev/serial/01/mysql-road-construction-news Introduction @keny_lala
hibinotatsuya 2018/09/22
mysql

LINE
ãƒªãƒ³ã‚¯
ã€Dockerã€‘MySQL8.0ç³»ã‚’ä½¿ã†æ™‚ã«ç™ºç”Ÿã™ã‚‹å•é¡Œã«ã¤ã„ã¦ - websandbag ãƒ–ãƒã‚°
æ–°ã—ã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€éŽåŽ»ã«åŒã˜ã‚ˆã†ãªæ§‹æˆã‚’Dockerã§ä½œã£ã¦ã„ã‚Œã°Dockerfileã‚’æµç”¨ã—ã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ ä»Šå›žã¯ã€æœ€æ–°ã®MySQLã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½¿ã†éš›ã«ç™ºç”Ÿã™ã‚‹å•é¡Œã«ã¤ã„ã¦è¨˜è¼‰ã—ã¦ã„ãã¾ã™ã€‚ ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ã“ã®è¨˜äº‹ã§å¾—ã‚‰ã‚Œã‚‹ã“ã¨ MySQLã®å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‹ã‚‰ã€8.0ç³»ã«ç§»è¡Œã—ãŸéš›ã«ç”Ÿã˜ã‚‹å•é¡Œã«ã¤ã„ã¦ã‚ã‹ã‚‹ã€‚ ä¹…ã—ã¶ã‚Šã«MySQLã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½¿ã£ãŸã‚‰ã‚¨ãƒ©ãƒ¼ãŒèµ·ããŸæ™‚ã®å¯¾å‡¦æ–¹æ³•ãŒã‚ã‹ã‚‹ ç’°å¢ƒ ãƒ„ãƒ¼ãƒ« ç¨®é¡ž ãƒãƒ¼ã‚¸ãƒ§ãƒ³ Docker 18.03.1 ãƒ©ã‚¤ãƒ–ãƒ©ãƒª ç¨®é¡ž ãƒãƒ¼ã‚¸ãƒ§ãƒ³ laravel 5.5 çŠ¶æ³ Laravelã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã£ã¦ã„ã¾ã™ã€‚ Dockerã§ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ã¯ã€Apacheã¨MySQLãã‚Œãžã‚Œã®æœ€æ–°ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ MySQLã®Dockerfileã¯ä¸‹è¨˜ã§ã™ã€‚ FROM mysql COPY ./docker-entrypoint-initd
hibinotatsuya 2018/07/25
mysql
ãƒªãƒ³ã‚¯
Hemebrewã§å…¥ã‚ŒãŸMySQLã®my.cnfã‚’è¨å®š - ã»ã’ã»ã’ï¼ˆä»®ï¼‰
å¿˜ã‚Œã‚‹ã®ã§ãƒ¡ãƒ¢ my.cnfãŒèªã¿è¾¼ã¾ã‚Œã‚‹å ´æ‰€ã‚’èª¿ã¹ã‚‹ $ mysql --help | grep my.cnf /etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnfèªã¿è¾¼ã¾ã‚Œã‚Œã‚‹é †ç•ªã¯å·¦ã‹ã‚‰ ã‚ã‚“ã¾ã‚Šç’°å¢ƒã‚’æ±šã™ã®ã¯å¥½ãã˜ã‚ƒãªã„ã®ã§ /usr/local/etc/my.cnf ã«ç½®ãã¾ã™ Homebrewã§å…¥ã‚ŒãŸMySQLã®my-xxx.cnfã®å ´æ‰€ $ find /usr/local/Cellar/mysql -name "my*.cnf" /usr/local/Cellar/mysql/5.5.27/mysql-test/suite/federated/my.cnf /usr/local/Cellar/mysql/5.5.27/mysql-test/suite/rpl/my.cnf /usr/local/Cellar
hibinotatsuya 2018/07/25
mysql

homebrew
ãƒªãƒ³ã‚¯
Account Suspended
hibinotatsuya 2018/07/25
mysql
ãƒªãƒ³ã‚¯
phpã‹ã‚‰MySQL 8.0ã¸PDOã§æŽ¥ç¶šæ™‚ã€ŒSQLSTATE[HY000] [2054] The server requested authentication method unknown to the clientã€
phpã‹ã‚‰MySQL 8.0ã¸PDOã§æŽ¥ç¶šæ™‚ã€ŒSQLSTATE[HY000] [2054] The server requested authentication method unknown to the clientã€ Ubuntu 18.04ã«nginx + phpã®å‹•ä½œç’°å¢ƒã‚’ä½œæˆã—ãŸã‚Šã€ MySQL 8.0ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚Šã—ã¦ã¿ã¾ã—ãŸã€‚ Ubuntu18.04 Server + nginx + php-fpmã®å‹•ä½œç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ MySQL 8.0ã‚’Ubuntu Server 18.04ã¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL 8.0 å¤–éƒ¨(ä»–ã®ç«¯æœ«)ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ ä»Šå›žã¯ã€ã“ã®ç’°å¢ƒã‚’åˆ©ç”¨ã—ã¦php 7.2ã‹ã‚‰MySQL 8.0ã«æŽ¥ç¶šã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ æŽ¥ç¶šãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ç¢ºèªç”¨ã®ã‚µãƒ³ãƒ—ãƒ« phpã‹ã‚‰mysqlã¸æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ æŽ¥ç¶šç¢ºèªç”¨ã«ã“ã‚“ãªã‚µ
hibinotatsuya 2018/07/25
MySQL
ãƒªãƒ³ã‚¯
120å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ã®é‡‘èžè³‡ç”£ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒžãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã®MySQLæ´»ç”¨ã®ã“ã‚Œã¾ã§ã¨ã“ã‚Œã‹ã‚‰ // Speaker Deck
#dbts2017 #DBAæŽ¡ç”¨ #ãƒžãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ http://www.db-tech-showcase.com/dbts/tokyo ç¾åœ¨ #500ä¸‡äººçªç ´ #å®¶è¨ˆç°¿ã‚¢ãƒ—ãƒªã‚·ã‚§ã‚¢No1 ã®ãƒžãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã§ã¯ã€120å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¶…ãˆã‚‹é‡‘èžè³‡ç”£é–¢é€£ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã£ã¦ã„ã¾ã™ã€‚ ãâ€¦
hibinotatsuya 2017/09/06
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 æ¬¡ã®ãƒšãƒ¼ã‚¸