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

tekimen id:tekimen

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

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

Debugging mysqlnd.so ï½žmysql_native_passwordãŒå»ƒæ¢ã•ã‚Œã‚‹æœªæ¥ã«å‚™ãˆã¦ï½ž | GREE Engineering
ã“ã‚“ã«ã¡ã‚ã€‚ã›ã˜ã¾ã§ã™ã€‚PHPã«ã¯ç–Žã„ã‚“ã§ã™ãŒã€ä»Šå›žã¯çã—ãPHPã®è©±ã‚’ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« 2023-07-18 ã« MySQL 8.1.0 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ã„ãã¤ã‹æ°—ã«ãªã‚‹å¤‰æ›´ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»Šå›žã¯ The mysql_native_password authentication plugin now is deprecated and subject to removal in a future version of MySQL. CREATE USER, ALTER USER, and SET PASSWORD operations now insert a deprecation warning into the server error log if an account attempts to authenticate using mysql_native_pass
tekimen 2023/07/27
mysql

php

gdb
ãƒªãƒ³ã‚¯
MySQLã§Nested Loopãªã‚¯ã‚¨ãƒªã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã©ã†è¾¿ã£ã¦ã„ã‚‹ã‹ - $shibayu36->blog;
ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³çš„ãªã‚‚ã®ã‚’SELECTã ã‘ã§å®Ÿè£…ã—ã‚ˆã†ã¨æ€ã£ãŸæ™‚ã«ã€Nested Loopãªã‚¯ã‚¨ãƒªã§Using temporary; Using filesortãŒå‡ºã‚‹ã‚ˆã†ãªãã“ãã“é…ã„ã‚¯ã‚¨ãƒªã«ãªã‚‹ã€‚ãã®æ™‚ã«MySQLãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã©ã†è¾¿ã£ã¦ã„ã‚‹ã‹ã‚’çŸ¥ã‚ŠãŸã‹ã£ãŸã®ã§èª¿ã¹ã¦ã¿ãŸã€‚MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯8.0.33ã€‚ ã‚ã¾ã‚Šè‡ªä¿¡ã¯ãªã„ã®ã§ã€ã‚‚ã—é–“é•ã£ãŸè©±ã‚’ã—ã¦ã„ãŸã‚‰æ•™ãˆã¦æ¬²ã—ã„ã€‚ ã©ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’æ¤œè¨¼ã™ã‚‹ã‹ ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã®å–å¾—ãŒã§ãã‚‹ã‚ˆã†ãªã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ•ã‚©ãƒãƒ¼é–¢ä¿‚ãƒ»æŠ•ç¨¿ã®3ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã¯æ¬¡ã®é€šã‚Šã€‚ CREATE TABLE users ( id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL ); CREATE TABLE follows ( id INTEGER PRIMARY KEY AUTO_I
tekimen 2023/07/21
mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
SELECTæ–‡ã§æœ¬ç•ªç’°å¢ƒã‚’è½ã¨ã—ãŸãŠè©± - Qiita
ï¼ˆã“ã®è¨˜äº‹ã¯ åœ°å¹³ç·šã«è¡Œã ã¨ã®ãƒžãƒ«ãƒãƒã‚¹ãƒˆã§ã™ï¼‰ æœ¬ç•ªç’°å¢ƒã§ã‚„ã‚‰ã‹ã—ã¡ã‚ƒã£ãŸäºº Advent Calendarã§ã€ã“ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚„ã‚‰ã‹ã—ã¯ãªã‹ã£ãŸã®ã§ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚’å©ãã“ã¨ã«ã—ã¾ã—ãŸã€‚ ç•ªå¤–ç·¨ã®ã¤ã‚‚ã‚Šã§ãŠæ¥½ã—ã¿ãã ã•ã„ã€‚ ã“ã®è¨˜äº‹ãŒã€æ–°ãŸãªéšœå®³ç™ºç”Ÿã‚’é˜²ãã“ã¨ã«ã¤ãªãŒã‚Œã°å¹¸ã„ã§ã™ã€‚ ä½•ã‚’ã‚„ã£ãŸã®ã‹ ã‚ã‚‹æ—¥ã€ã¡ã‚‡ã£ã¨ã—ãŸèª¿æŸ»ã®ãŸã‚ã«æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç¢ºèªã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ï¼ˆå€‹äººæƒ…å ±ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ã¯ãªã‹ã£ãŸã®ã§ã€å¿…è¦ã§ã‚ã‚Œã°æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒè¨±ã•ã‚Œã¦ã„ã¾ã—ãŸï¼‰ ã‚‚ã—ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒã‚ã‚Œã°ãã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã‚„ã‚Œã°ã‚ˆã‹ã£ãŸã®ã§ã™ãŒã€ç›´è¿‘ã§ã¯ç‰¹ã«äºˆå®šã¯ãªã„ã¨ã®ã“ã¨ã§ã—ãŸã€‚ãã®ãŸã‚ã€ã‚·ã‚¹ãƒ†ãƒ ãŒå‹•ã„ã¦ã„ã‚‹çŠ¶æ…‹ã®ã¾ã¾ä½œæ¥ã‚’ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã”ãå˜ç´”ãª SELECT ã‚’å®Ÿè¡Œã™ã‚‹ã ã‘ã®ã¤ã‚‚ã‚Šã ã£ãŸã®ã§ã€ã‚·ã‚¹ãƒ†ãƒ ã«å½±éŸ¿ãŒãªã„ã¨åˆ¤æ–ã—ãŸãŸã‚ã§ã™ã€‚ ãã®éš›ã€ä¸‡ãŒä¸€ã‚³ãƒ”ãƒšã‚’ãƒŸ
tekimen 2019/12/26
è²´é‡ãªçŸ¥è¦‹ã‚’ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

mysql

sql
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
tekimen 2017/12/22
MySQL

FLOAT

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB
ãƒªãƒ³ã‚¯
https://engineering.mercari.com/entry/2017/12/18/deadlock
tekimen 2017/12/19
MySQL

ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯

PHP

database
ãƒªãƒ³ã‚¯
PHPã®mysqlndã®åœ§ç¸®ãƒ—ãƒãƒˆã‚³ãƒ«ã«ã¤ã„ã¦ã®ãƒ¡ãƒ¢ - hnwã®æ—¥è¨˜
PHP+PDO+MySQLã®ç’°å¢ƒã§ã¯ã€PHP-MySQLé–“ã®é€šä¿¡ã«ã¤ã„ã¦zlibã‚’ä½¿ã£ãŸåœ§ç¸®ãƒ—ãƒãƒˆã‚³ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã®æ©Ÿèƒ½ã¯ã€DBã‚µãƒ¼ãƒã®CPUåˆ©ç”¨çŽ‡ã«ååˆ†ä½™è£•ãŒã‚ã‚Šã€ã‹ã¤PHP-MySQLé–“ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯å¸¯åŸŸãŒé€¼è¿«ã—ã¦ã„ã‚‹çŠ¶æ³ã§æœ‰ç”¨ã§ã™ã€‚ MySQLã®åœ§ç¸®ãƒ—ãƒãƒˆã‚³ãƒ«ã¨ãã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PHP+MySQLã®ç’°å¢ƒã§ã€åœ§ç¸®ãƒ—ãƒãƒˆã‚³ãƒ«ã¯ä¸‹è¨˜ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã§åˆ©ç”¨ã§ãã¾ã™ã€‚ <?php $options = [ PDO::MYSQL_ATTR_COMPRESS => true ]; $db = new PDO($dsn, $user, $pass, $options); MySQLãƒ‰ãƒ©ã‚¤ãƒã¨ã—ã¦mysqlndã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆ*1ã€PHP 5.3.11ï¼ˆ2012å¹´4æœˆãƒªãƒªãƒ¼ã‚¹ï¼‰ä»¥é™ã§ã‚ã‚Œã°åœ§ç¸®ãƒ—ãƒãƒˆã‚³ãƒ«ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ã“ã®ã“ã¨ã¯PHPãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã‚‚ä¸‹è¨˜ã®é€šã‚Šè¨˜è¼‰ãŒã‚ã‚Šã¾ã™ã€‚ PDO::
tekimen 2017/07/26
PHP

mysql
ãƒªãƒ³ã‚¯
Transactd - ãƒ“ã‚ºã‚¹ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³æ ªå¼ä¼šç¤¾
Transactd Plugin 3.0 é«˜é€Ÿã‚¢ã‚¯ã‚»ã‚¹ã€é«˜æ©Ÿèƒ½ã€åˆ†æ•£ã‚¯ã‚¨ãƒªãƒ¼å¯èƒ½ MySQLç”¨NoSQLãƒ—ãƒ©ã‚°ã‚¤ãƒ³ é«˜é€Ÿã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ åž‚ç›´ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° æ°´å¹³ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° åˆ†æ•£ã‚¯ã‚¨ãƒªãƒ¼ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ SQLãƒ©ã‚¤ã‚¯ãªã‚¯ã‚¨ãƒªãƒ¼ Windows Linux Mac OS X C++ PHP Ruby ActiveX DOWNLOAD â†’ Transactd 3.0ã®æ©Ÿèƒ½ New! ã‚¹ã‚ãƒ¼ãƒžãƒ†ãƒ¼ãƒ–ãƒ«ãªã—ã§ã®ã‚¢ã‚¯ã‚»ã‚¹ New! ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®NULLå¯¾å¿œ New! ã™ã¹ã¦ã®MySQL/Mariadbãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®DATEåž‹ã€TIMEåž‹ã€DATETIMEåž‹ã€TIMESTAMPåž‹ã«å¯¾å¿œ New! ãƒ“ãƒƒãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å°‚ç”¨ã‚¯ãƒ©ã‚¹ã®è¿½åŠ New! ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«å¯¾å¿œ New! MySQL5.7 / Mariadb10.1ã¸ã®å¯¾å¿œ Improved! SQLã¨ã®ç›¸äº’é‹ç”¨æ€§ã®å‘ä¸Š Improved! ãƒ†ã‚¹
tekimen 2017/05/13
mysql
ãƒªãƒ³ã‚¯
1