[B! MySQL] rokujyouhitomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rokujyouhitoma id:rokujyouhitoma

MySQLã«é–¢ã™ã‚‹rokujyouhitomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (196)

${{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ã§INå¥ã®ä¸ã«å¤§é‡ã®å€¤ã®å…¥ã£ãŸã‚¯ã‚¨ãƒªãŒãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã‚’èµ·ã“ã™è©± - freee Developers Hub
ã“ã‚“ã«ã¡ã¯ã€freee Developers Advent Calendar 2021ã€19æ—¥ç›®ã®id:shallow1729ã§ã™ã€‚æ˜¨æ—¥ã¯tdtdsã•ã‚“ã§ã€ãƒžã‚¸ã§ã€‘ã‚µã‚¤ãƒãƒ¼æ¼”ç¿’ã‚·ãƒŠãƒªã‚ªã®ä½œã‚Šæ–¹ã€æ€–ã„ã€‘ã§ã—ãŸï¼éšœå®³è¨“ç·´å¾Œã«æ”»æ’ƒæ–¹æ³•ã‚’è§£èª¬ã•ã‚ŒãŸæ™‚ã¯ãƒªã‚¢ãƒªãƒ†ã‚£ã®é«˜ã•ã«é©šãã¾ã—ãŸã€‚ åƒ•ã¯MySQLã‚’ä½¿ã£ã¦ã„ã¦ç™ºç”Ÿã—ãŸä¸æ€è°ãªæŒ™å‹•ã®èª¿æŸ»ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žå•é¡Œã¨ãªã£ãŸã‚¯ã‚¨ãƒª ä»Šå›žè©±é¡Œã«ã™ã‚‹ã‚¯ã‚¨ãƒªã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚·ãƒ³ãƒ—ãƒ«ãªã‚‚ã®ã§ã™ã€‚ SELECT * FROM hoge WHERE id IN (...) MySQLã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼æ¬¡ç¬¬ã§ã™ãŒã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã ã¨ã“ã®INå¥ã®ä¸ã®å€¤ã®æ•°ãŒæ•°ä¸‡ã«ãªã‚‹ã¨é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ã¦ã‚‚ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒç™ºç”Ÿã™ã‚‹äº‹ãŒã‚ã‚Šã¾ã—ãŸã€‚ã“ã®ã‚¯ã‚¨ãƒªãŒãƒ†ãƒ¼ãƒ–ãƒ«ã®ã»ã¨ã‚“ã©ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç¶²ç¾…ã™ã‚‹ã‚ˆã†ãªå ´åˆã‚„é«˜é€Ÿã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤§é‡ã«insertã—ã¦çµ±è¨ˆæƒ…å ±ãŒè¿½ã„ã¤ã‹ãªã„ã‚±ãƒ¼
rokujyouhitoma 2021/12/19
INå¥ã«2^23/2ã‚‚çªã£è¾¼ã‚€ã“ã¨ã¯ãªã„ã‹ãªã€‚ãã®è¦æ¨¡ã®ãƒ‡ãƒ¼ã‚¿é‡æ‰±ã†æ™‚ã«ã¯ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã—ã¦ã€ã‚‚ã£ã¨æ•£ã‚‰ã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ã€‚

MySQL
ãƒªãƒ³ã‚¯
Getting Started Â· Accessing data with MySQL
This guide walks you through the process of creating a Spring application connected to a MySQL Database (as opposed to an in-memory, embedded database, which most of the other guides and many sample applications use). It uses Spring Data JPA to access the database, but this is only one of many possible choices (for example, you could use plain Spring JDBC).
rokujyouhitoma 2021/09/24
MySQL

SpringBoot

Java
ãƒªãƒ³ã‚¯
Macã®homebrewã§mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã¿ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ - Qiita
Macã®ãƒãƒ¼ã‚«ãƒ«ã«ä½œã£ãŸé–‹ç™ºç’°å¢ƒã®mysqlã«æŽ¥ç¶šã¯ã—ãŸã„ã‘ã©ã‚µãƒ¼ãƒãƒ¼ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸããªã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ homebrewã®ç¢ºèª homebrewã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã§ã‚ã‚‹ã“ã¨ãŒå‰æã§ã™ $ brew -v Homebrew 2.2.2 Homebrew/homebrew-core (git revision fdb53; last commit 2020-01-03) Homebrew/homebrew-cask (git revision d9c8; last commit 2020-01-03)
rokujyouhitoma 2021/09/24
MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 23.6.11 NDB Cluster ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ç«¶åˆè§£æ±º
ndb_blob_tool â€” NDB Cluster ãƒ†ãƒ¼ãƒ–ãƒ«ã® BLOB ãŠã‚ˆã³ TEXT ã‚«ãƒ©ãƒ ã®ãƒã‚§ãƒƒã‚¯ãŠã‚ˆã³ä¿®å¾©
rokujyouhitoma 2021/09/08
MySQL

MySQLCluster
ãƒªãƒ³ã‚¯
ISUCON10äºˆé¸ãµã‚Šã‹ãˆã‚Š - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ISUCON10äºˆé¸ãŠã¤ã‹ã‚Œã•ã¾ã§ã—ãŸã€‚ISUUMOã„ã„å•é¡Œã§ã—ãŸãã€‚éŽåŽ»å‡ºé¡Œå´ã‚’æ‹…å½“ã—ãŸã“ã¨ã‚‚ã‚ã‚‹èº«ã§ã‚‚ã€å‚åŠ è€…ã®å®Œå…¨æ”»ç•¥ã«å¯¾ã™ã‚‹æ€–ã‚Œã‚‚ã‚ã£ã¦ä»•æ§˜ãŒè‚¥å¤§åŒ–ã™ã‚‹ãªã‹ä»Šå›žã“ã‚Œã ã‘ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªä»•æ§˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã“ã‚Œã ã‘æ¥½ã—ã‚ã‚‹å‡ºé¡Œã‚’ã—ãŸã®ãƒžã‚¸ã§ã™ã”ã„ã¨æ€ã„ã¾ã—ãŸã€‚ ä»Šå›žã®å•é¡Œã¯MySQLã‹ã¤æ¤œç´¢ãƒ˜ãƒ´ã‚£ãªå•é¡Œã§åƒ•ã®ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã«å‘ã„ã¦ã‚‹å•é¡Œã«ã‚‚é–¢ã‚ã‚‰ãšã€ãšã£ã¨æ‰‹ã‚’å‹•ã‹ã—ã¦ã„ãŸã‚ã‚Šã«åŠ¹æžœã®é«˜ã„æ–½ç–ã«å–ã‚Šçµ„ã‚ãšã€ã‚ã‚‰ãŸã‚ã¦ISUCONã®é›£ã—ã•ã‚’ç—›æ„Ÿã—ãŸã—ã“ã‚ŒãžISUCONãªã®ã ãªã‚ã¨æ€ã„ã¾ã™ã€‚ åƒ•ã®æ–‡ç« èªè§£ãŒé…ãä»•æ§˜ç†è§£ã«ã¨ã¦ã‚‚æ™‚é–“ã‚’è¦ã™ã‚‹ã¨ã„ã†æ€§è³ªã‹ã‚‰ã€ã“ã‚Œã¾ã§ã®ISUCONã§ã¯å¸¸ã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•æ§˜ã‚„æ€§è³ªã‚’ç†è§£ã§ãã‚‹å‰ã«æ™‚é–“çš„åˆ¶ç´„ã‹ã‚‰ã‚ã‚‰ã‚†ã‚‹æ±ºæ–ã‚’è¿«ã‚‰ã‚Œã‚‹ã¨ã„ã†çŠ¶æ³ã«ã‚ã‚Šã€ã“ã®çŠ¶æ³ã§ä»•æ§˜ã‚„æ€§è³ªã‚’ç†è§£ã§ãã¦ã„ãŸã¨ã—ãŸã‚‰ã§ããŸæ£ã—ã„æ±ºæ–ã‚’ã—ã¦ã„ãã®ã¯æœ¬å½“ã«é›£ã—ã„ã¨æ€ã£ã¦ã„ã¦ã€ä»Šå›žãšã£ã¨
rokujyouhitoma 2020/10/22
ISUCON10

ISUCON

MySQL
ãƒªãƒ³ã‚¯
MySQL 8.0.20 ã§HASH JOINãŒåŠ¹ãã‚±ãƒ¼ã‚¹ãŒæ‹¡å¤§ã—ãŸ - mita2 database life
TLDR; MySQL 8.0.20 ã‹ã‚‰ INNER JOIN ã ã‘ã˜ã‚ƒãªãã¦ã€Semi joinã‚„ Left/Right outer join ã§ã‚‚ HASH JOIN ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã‚ˆ MySQL 8.0.20 ã§ã¯ (EXPLAIN ANALYZEã§ã¯ãªãï¼‰EXPLAIN ã§ã‚‚ã€HASH JOINãŒä½¿ã‚ã‚Œã¦ã„ã‚‹ã‹ã€è¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã‚ˆ MySQL 8.0.19 ã‹ã‚‰ã€optimizer_switch ã§ HASH JOIN ã® OFF/ON ãŒã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã§ããªããªã£ãŸã‚ˆ MySQL 8.0.20 Release Note Hash joins are now used any time a nested block loop would be employed. This means that hash joins can be used for the followi
rokujyouhitoma 2020/05/10
MySQL
ãƒªãƒ³ã‚¯
InnoDB
rokujyouhitoma 2020/04/20
MySQL

InnoDB
ãƒªãƒ³ã‚¯
Percona Server ã§ MyRocks ã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆRocksDBï¼‰ã‚’ä½¿ã†
MyRocks ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã¯ï¼Ÿ Facebookç¤¾ãŒé–‹ç™ºã—ãŸMySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚RocksDBã‚’ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«ä½¿ç”¨ã—ã¦ãŠã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«åœ§ç¸®ã‚’ã—ãŸInnoDBã¨æ¯”è¼ƒã—ã¦ã€é«˜ã„åœ§ç¸®æ€§èƒ½ã‚’ã‚‚ã¡ã€é«˜é€Ÿãªæ›¸ãè¾¼ã¿å‡¦ç†ãŒå¯èƒ½ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ Facebookã§ã¯ç‹¬è‡ªã«æ”¹è‰¯ã•ã‚ŒãŸMySQL(5.6ãƒ™ãƒ¼ã‚¹)ã«MyRocksãŒçµ„ã¿è¾¼ã¾ã‚Œã€ä¸€éƒ¨æœ¬ç•ªç’°å¢ƒã§ã‚‚å‹•ã„ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ MyRocksã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ãŠã‚Šã€Percona Server ã‚„ MariaDB ã§ã¯ã“ã‚Œã‚’ãƒžãƒ¼ã‚¸ã™ã‚‹å–ã‚Šçµ„ã¿ãŒé€²ã‚“ã§ã„ã¾ã™ã€‚ Percona Server 5.7.18 ã‹ã‚‰å®Ÿé¨“çš„ãªãŒã‚‰ ã“ã®MyRocks ã‚¨ãƒ³ã‚¸ãƒ³ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€Percona Server ã§MyRocksã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã€åŒã˜ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ InnoDBã¨MyRocksã§
rokujyouhitoma 2020/03/14
MySQL

MyRocks
ãƒªãƒ³ã‚¯
ç¬¬53å›žã€€MySQLï¼† PostgreSQLã®2019å¹´ã®ä¸»ãªãƒ‹ãƒ¥ãƒ¼ã‚¹ã¨ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2020ã§ã®OSS-DBä¼ç”» | gihyo.jp
OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å–ã‚Šå–ã‚Šæ™‚å ± ç¬¬53å›žMySQLï¼† PostgreSQLã®2019å¹´ã®ä¸»ãªãƒ‹ãƒ¥ãƒ¼ã‚¹ã¨ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2020ã§ã®OSS-DBä¼ç”» æœ¬å¹´ã‚‚ã€OSSã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹éƒ¨ä¼šã®ãƒ¡ãƒ³ãƒãƒ¼ã«ã‚ˆã‚‹æœ¬é€£è¼‰ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ä»Šå›žã¯å¹´å§‹æ’ä¾‹ã®MySQLã¨PostgreSQLã®2019å¹´ã®ä¸»ãªãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã¾ãŸã€å¤§é˜ªã¨æ±äº¬ã§é–‹å‚¬ã•ã‚Œã‚‹ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰¹åˆ¥ä¼ç”»ã¸ã®ãŠèª˜ã„ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹å¤§é˜ªï¼æ±äº¬ã§OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰¹åˆ¥ä¼ç”» å…¨å›½ã§é–‹å‚¬ã—ã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ç¥å…¸ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆOSCï¼‰ã®2020å¹´é–‹å‚¬ãŒå§‹ã¾ã‚Šã¾ã™ã€‚å¤§é˜ªï¼ˆ1æœˆï¼‰ã¨æ±äº¬ï¼ˆ2æœˆï¼‰ã§ã€è¤‡æ•°ç¨®é¡žã®OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãã®é–¢é€£æƒ…å ±ã‚’ã¾ã¨ã‚ã¦ãŠè´ãã„ãŸã ã‘ã‚‹ç‰¹åˆ¥ä¼ç”»ã‚’æº–å‚™ä¸ã§ã™ã€‚OSSã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹éƒ¨ä¼šãŒã€ä»–ã®OSSå›£
rokujyouhitoma 2020/01/09
MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
MHA for MySQLã¨DeNAã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®è©±
This document discusses messaging queues and platforms. It begins with an introduction to messaging queues and their core components. It then provides a table comparing 8 popular open source messaging platforms: Apache Kafka, ActiveMQ, RabbitMQ, NATS, NSQ, Redis, ZeroMQ, and Nanomsg. The document discusses using Apache Kafka for streaming and integration with Google Pub/Sub, Dataflow, and BigQuery
rokujyouhitoma 2019/08/09
DeNA

MySQL
ãƒªãƒ³ã‚¯
MySQLã®æœ€å…ˆç«¯ã‚’è¡Œãç¾å ´äººãŒé›†ã† MySQL Casual Talks #6ã«è¡Œã£ã¦ããŸï¼ - ã‚‚ãã‚ã½ã‚ã
TokuDBã¨ã¯TokutekãŒä½œã£ãŸFractalTree(R)Indexã‚’å®Ÿè£…ã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ç‰¹å¾´ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ALTER TABLE(ADD INDEX, ADD COLUMN)ã«å¯¾å¿œ åœ§ç¸®ãŒã‚¤ã‚±ã¦ã‚‹ æ–ç‰‡åŒ–ã—ãªã„ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¤‡æ•°ä½œã‚Œã‚‹ infromation_schema, show engine tokuDB ã§æƒ…å ±ã¿ã‚Œã‚‹ãŒãªã‚Œã‚‹ã®ã«æ™‚é–“ã‹ã‹ã‚‹ foreign keyã¯å¯¾å¿œã—ã¦ãªã„ How TokuDB Fractal TreeTM Indexes Work ãƒ©ãƒ³ãƒ€ãƒ ãƒ©ã‚¤ãƒˆãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹ç¯‰ãŒæ—©ã„ Insertã®TPSã¯ã„ã¤ã¾ã§ã‚‚ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆãŒå¤‰ã‚ã‚‰ãªã„ ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ twitterã¿ãŸã„ãªã“ã¨ã‚’ã‚„ã‚ã†ã¨ã—ãŸ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒã‚¹ã—ã¦timelineãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ timelineãƒ†ãƒ¼ãƒ–ãƒ«ã¯6å„„ä»¶ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºå›³ã£ãŸã‚‰innodb compactã¯60Gå¼±ã€
rokujyouhitoma 2018/11/07
MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 16.6 BLACKHOLE ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
BLACKHOLE ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’å—ã‘å–ã‚‹ã‘ã‚Œã©ã‚‚ç ´æ£„ã—ã¦æ ¼ç´ã—ãªã„ã€Œãƒ–ãƒ©ãƒƒã‚¯ãƒ›ãƒ¼ãƒ«ã€ã¨ã—ã¦æ©Ÿèƒ½ã—ã¾ã™ã€‚ æ¤œç´¢ã¯ã€å¸¸ã«ç©ºã®çµæžœã‚’è¿”ã—ã¾ã™ã€‚ mysql> CREATE TABLE test(i INT, c CHAR(10)) ENGINE = BLACKHOLE; Query OK, 0 rows affected (0.03 sec) mysql> INSERT INTO test VALUES(1,'record one'),(2,'record two'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM test; Empty set (0.00 sec) ã‚½ãƒ¼ã‚¹ã‹ã‚‰ MySQL ã‚’æ§‹ç¯‰ã™ã‚‹å ´åˆã« BLACKHOLE ã‚¹ãƒˆãƒ¬
rokujyouhitoma 2018/11/07
MySQL

BLACKHOLE
ãƒªãƒ³ã‚¯
ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¢—ãˆç¶šã‘ã‚‹diskå®¹é‡ã®å¯¾å¿œäº‹ä¾‹ | ãƒ¡ãƒ«ã‚«ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°
ã“ã‚“ã«ã¡ã¯ã€SRE ã® @masartzã§ã™ã€‚ ä»Šå›žã¯æœ€è¿‘å–ã‚Šçµ„ã‚“ã ã€ãƒ¡ãƒ«ã‚«ãƒªã®ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å®¹é‡å‰Šæ¸›ã®ãŠè©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ TL;DR ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å®¹é‡ã‚’20%ä»¥ä¸Šå‰Šæ¸›ã—ã¾ã—ãŸ ã©ã†ã„ã†çŠ¶æ³ã ã£ãŸã‹ï¼Ÿã€€ä½•ã‚’ã—ãŸã‹ï¼Ÿ ãƒ¡ãƒ«ã‚«ãƒªã§ã¯2017å¹´11æœˆç¾åœ¨ã€å‡ºå“æ•°ã¯1æ—¥100ä¸‡ä»¶ã‚’è¶…ãˆã¦ã„ã¾ã™ã€‚ ãªã®ã§ã€å˜ç´”ã«æ—¥ã€…å¤šãã®ãƒ‡ãƒ¼ã‚¿ãŒå¢—ãˆã¦ã„ã£ã¦ã„ã¾ã™ã€‚ ãã®ãŸã‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã¯å¸¸ã«æ¤œè¨Žã—ã€å–ã‚Šçµ„ã¾ãªã‘ã‚Œã°ãªã‚‰ãªã„èª²é¡Œã§ã™ã€‚ ä»Šå›žæ‰±ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã„ãã¤ã‹ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸ã§å•†å“ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŒã¤ã€ãƒ¡ãƒ«ã‚«ãƒªã®ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãªã‚Šã¾ã™ã€‚ å¢—ãˆç¶šã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾å¿œã™ã‚‹ãŸã‚ã®ã€ãƒ†ãƒ¼ãƒ–ãƒ«åˆ†å‰²ã‚’å¤‰å‰‡çš„ãªå½¢ã§å¯¾å¿œã—ãŸã®ã§ãã®éŽç¨‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ å‰æï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ†å‰²æ–¹æ³• ãƒ¡ãƒ«ã‚«ãƒªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ ä¼šå“¡æƒ…å ±ã‚„å•†å“æƒ…å ±ãªã©ã€åŸºæœ¬è¦ç´ ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ã€é€šçŸ¥ã‚„ãŠçŸ¥ã‚‰ã›ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãªã©ä»˜åŠ çš„ãªæ©Ÿèƒ½
rokujyouhitoma 2018/10/16
MySQL
ãƒªãƒ³ã‚¯
LINEã®MySQLé‹ç”¨ã«ã¤ã„ã¦
1. LINEã®MySQLé‹ç”¨ã«ã¤ã„ã¦Kentaro Kitagawa, IT service center - database department - db1 team DB Tech Showcase 2018 2018/09/20 2. l åŒ—å· å¥å¤ªéƒŽ / Kentaro Kitagawa l LINEæ ªå¼ä¼šç¤¾ l IT Service Center - Database dept.- DB1 Team l ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ l MySQL / Oracle Database / Redis l MySQLé“æ™®è«‹: http://gihyo.jp/dev/serial/01/mysql-road-construction-news Introduction @keny_lala
rokujyouhitoma 2018/09/21
MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã«767byteã¾ã§ã—ã‹ã¤ã‹ãˆãªã„å•é¡Œã¨å¯¾ç– - ãƒãƒžãƒã‚°
Laravel5.4ã§migrationã‚’å®Ÿè¡Œã—ãŸã¨ã“ã‚ã€ã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã—ãŸã€‚ [Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_em ail_unique`(`em ail`)) [Doctrine\DBAL\Driver\PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 b
rokujyouhitoma 2018/05/29
MySQL
ãƒªãƒ³ã‚¯
MySQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆã™ã‚‹ã€ŒCREATE DATABASEã€
MySQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã«ã¯ã€ã€ŒCREATEã€æ–‡ã‚’ä½¿ã„ã¾ã™ã€‚ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã€ŒCREATEã€æ¨©é™ãŒãªã„ã¨å®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚ æ¬¡ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆæ™‚ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãªã©ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå˜åœ¨ã—ãªã‘ã‚Œã°ä½œæˆã™ã‚‹ï¼šIF NOT EXISTS
rokujyouhitoma 2018/05/29
MySQL
ãƒªãƒ³ã‚¯
Mac ã¸ MySQL ã‚’ Homebrew ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ‰‹é † - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
rokujyouhitoma 2018/05/29
â€œbrew install mysqlâ€

Homebrew

MySQL
ãƒªãƒ³ã‚¯
brew services start mysql ã§ mysql ãƒ‡ãƒ¼ãƒ¢ãƒ³ãŒèµ·å‹•ã—ãªã„ã¨æ€ã£ãŸã‚‰ datadir ãŒå¤ã‹ã£ãŸ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
rokujyouhitoma 2018/05/29
Homebrew

MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã«ãªã£ãŸã®ã§mysql_upgradeã§ç›´ã—ãŸ - æœ¬æ—¥ã‚‚ä¹™
ä»Šæ—¥ã‚‚é£½ããšã«éŽåŽ»ã®ãƒ¡ãƒ¢ã‚’æŽ˜ã‚Šèµ·ã“ã—ã¦è¨˜äº‹ã«ã—ã‚ˆã†ã®ã‚³ãƒ¼ãƒŠãƒ¼ã§ã™ã€‚ ãƒ¡ãƒ¢ãŒè‰²ã€…ãªã¨ã“ã‚ã«åˆ†æ•£ã—ã¦ã„ã‚‹ã®ã§è¨˜äº‹ã«ã™ã‚‹ã“ã¨ã§1ã¤ã«ã§ãã‚‹ã®ãŒè‰¯ã„ã§ã™ãã€‚ MySQLã‚’yumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŠã‚Šã€yum update mysqlã—ãŸã‚‰MySQLã®ãƒã‚°ã«ã‚¨ãƒ©ãƒ¼å‡ºã¦ã„ã¾ã—ãŸã€‚ # /var/log/mysqld.log 2015-06-25 15:12:20 30960 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 2015-06-25 15:12:20 30960 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 2015-06-25 15:12:20 3
rokujyouhitoma 2018/05/29
MySQL
ãƒªãƒ³ã‚¯
Mac ã« MySQL 5.7 ã‚’ brew install ã—ã¦è‡ªå‹•èµ·å‹•ã•ã›ã‚‹ | DriftwoodJP
% brew install mysql Updating Homebrew... ==> Downloading https://homebrew.bintray.com/bottles/mysql-5.7.17.sierra.bottle.1.tar.gz ######################################################################## 100.0% ==> Pouring mysql-5.7.17.sierra.bottle.1.tar.gz ==> Using the sandbox ==> /usr/local/Cellar/mysql/5.7.17/bin/mysqld --initialize-insecure --user=**** --basedir=/usr/local/Cellar/mysql/5.7.1
rokujyouhitoma 2018/05/29
MySQL
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸