Shiguredo uses Tailscale to solve the issues that arise with cloud services using bare-metal servers · Tailscale
Contributed by @voluntas. Shiguredo Inc. develops and provides a software package called WebRTC SFU Sora (Sora) and its cloud service. WebRTC (Real-Time Communication) is a technology for exchanging voice, video, and data in real time over P2P. Sora is a WebRTC SFU (Selective Forwarding Unit), which is different from P2P communication in that it delivers audio and video data “via server.†With Sor
MySQLã§è«–ç†å‰Šé™¤ã¨æ£ã—ã付ãåˆã†æ–¹æ³•
24. 削除 フラグ︖ ã¨ã„ã†ã‹ãã‚‚ãã‚‚è«–ç† å‰Šé™¤ ã¨ã‹ 削除 フラグãªã‚“ã¦ã„ã†ã‹ ら話ãŒæŽ´ã¿ã«ãããªã‚‹ スーパーéžè¡¨â½°ãƒ•ãƒ©ã‚°ã¨ã‹è¡¨â½°ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã¨ã‹ã«ã™ã‚Œã°ã„ã„ã‚“ã˜ã‚ƒ ã︖ - ãã†ã™ã‚Œã°ã€ãã‚Œã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã® 属性 ã®â¼€ã¤ãªã®ã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« モデル的ã«ç´å¾—ãŒã„ã é‹å–¶ã®ã¿é–²è¦§å¯èƒ½ãƒ•ãƒ©ã‚°ã¨ã‹ãƒ¦ãƒ¼ã‚¶ãƒ¼éžè¡¨â½°ãƒ•ãƒ©ã‚°ã¨ã‹ã§ã‚‚ã„ㄠステータスãªã‚‰ENUM(Ê»NOT̲DELETEDʼ, Ê»DELETED̲BY̲USERʼ, Ê»DELETED̲BECAUSE̲DMCAʼ, Ê»DELETED̲BECAUSE̲PORNʼ, ..)ã¨ã‹ï¸– ãŸã ã—â€display̲status <> Ê»NOT̲DELETEDʼ“ã¨ã‹ã‚„ã‚‹ã¨æ»ãる。 ã¨ã¯ã„ãˆãã‚“ãªã‚¯ã‚¨ãƒªãƒ¼æµã™ã®ç®¡ç†ç”»â¾¯ã ã‘ã§ã‚ã‚‹ã¹ããªã®ã§ã€ãƒ†ãƒ¼ãƒ–ルスã‚ャンã らã„ã¯è¦šæ‚Ÿã—ã‚ã¨ã„ã†æ°—ã§ã„る。 - 23/33 26. 削除フラグã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãã—ã¦å…¨ã¦ã®(ユーザ
雑ãªMySQLパフォーマンスãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
26. EXPLAIN mysql> EXPLAIN SELECT * FROM table_1 a JOIN `table_2` s ON a.user_id=s.`user_id` AND s.site_i d=120 WHERE app_id=8250G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: a type: ref possible_keys: PRIMARY,ix_table_1,ix2_table_2,ix3_table_1,idx_table_1_06,idx_table_1_07,idx_t able_1_09 key: idx_table_1_06 key_len: 4 ref: const rows: 13496 Ext
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
ã¼ããŒã‹ã‚“ãŒãˆãŸã•ã„ãょã†ã®MySQLã®ç›£è¦–スクリプトをèªã¿è§£ã
{{#tags}}- {{label}}
{{/tags}}