All of Percona’s open-source software products, in one place, to download as much or as little as you need.
How to create/restore a slave using GTID replication in MySQL 5.6
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
ユーザーã«è¨å®šã§ãる権é™ã®ç¨®é¡žã¨ä¸€è¦§
ユーザー㌠MySQL ã«æŽ¥ç¶šã—ãŸã‚ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„テーブルを作æˆã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ルã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ã«ã¯ãã®æ“作ã«å¯¾ã™ã‚‹æ¨©é™ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ MySQL ã«ãŠã‘る権é™ã®ç¨®é¡žã¨æ¨©é™ã®ä¸€è¦§ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒ¬ãƒ™ãƒ«(G) ã‚°ãƒãƒ¼ãƒãƒ«ãƒ¬ãƒ™ãƒ«æ¨©é™ã¯å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é©ç”¨ã•ã‚Œã‚‹æ¨©é™ã§ã™ã€‚ã“ã®æ¨©é™ã¯ mysql.user テーブルã«æ ¼ç´ã•ã‚Œã¾ã™ã€‚ データベースレベル(D) データベースレベル権é™ã¯ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®å…¨ã¦ã®ã‚ªãƒ–ジェクトã«é©ç”¨ã•ã‚Œã‚‹æ¨©é™ã§ã™ã€‚ã“ã®æ¨©é™ã¯ mysql.db テーブル内ã«æ ¼ç´ã•ã‚Œã¾ã™ã€‚ テーブルレベル(T) テーブルレベル権é™ã¯ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ル内ã®å…¨ã¦ã®ã‚«ãƒ©ãƒ ã«é©ç”¨ã•ã‚Œã‚‹æ¨©é™ã§ã™ã€‚ã“ã®æ¨©é™ã¯ mysql.tables_priv テーブル内ã«æ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ カラムレベル(C) カラムレベル権é™ã¯ç‰¹å®šãƒ†ãƒ¼ãƒ–ル内ã®å˜ä¸€ã‚«ãƒ©ãƒ ã«é©ç”¨ã•ã‚Œã‚‹æ¨©
Ansible MySQL User with REQUIRE SSL
I've just begun learning Ansible today, and I'm already making fast progress and on the edge of being able to automate our whole IT stack. That's nice! :) I've however hit a roadblock. We've chosen to take the small performance hit and encrypt ALL MySQL connections using the SSL feature. This is to let our office IP's remotely manage it, and also inter-datacenter. Using the mysql_user module, I ca
Loading half a billion rows into MySQL
We have a legacy system in our production environment that keeps track of when a user takes an action on Causes.com (joins a Cause, recruits a friend, etc). I say legacy, but I really mean a prematurely-optimized system that I'd like to make less smart. This 500m record database is split across monthly sharded tables. Seems like a great solution to scaling (and it is) -- except that we don't need
MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãƒ™ã‚¹ãƒˆãƒ—ラクティス | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ§˜ã€…ãªãƒ‘ターンã¨ã€ãã®åˆ©ç‚¹ãƒ»æ¬ 点ã€æ‰‹é †ã®è§£èª¬ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—実施å‰ã®ã€äº‹å‰èª¿æŸ»ã¨ãƒ†ã‚¹ãƒˆãŒé‡è¦ã§ã‚ã‚‹ã¨ã®æŒ‡æ‘˜ã‚‚。 MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—(訳注 : 原文ã§ã¯upgradeã€ä»¥ä¸‹åŒã˜)ã¯ã©ã“ã‹ã§å¿…è¦ã«ãªã‚‹ã‚¿ã‚¹ã‚¯ã ã—ã€æˆ‘々Percona Supportã§ã‚‚MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãƒ™ã‚¹ãƒˆãƒ—ラクティスã«ã¤ã„ã¦ã®è‰²ã€…ãªè³ªå•ã‚’å—ã‘付ã‘ã¦ã„る。ã“ã®è¨˜äº‹ã§ã¯ã€è‰²ã€…ãªã‚·ãƒŠãƒªã‚ªã«ãŠã‘ã‚‹MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æŽ¨å¥¨ã§ãる方法ã«ç„¦ç‚¹ã‚’当ã¦ã¦ã¿ãŸã„。 MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã¯ãªãœå¿…è¦ã«ãªã£ã¦ã—ã¾ã†ã®ã‹ï¼Ÿãã®ç†ç”±ã¯è‰²ã€…ã ãŒã€æ–°æ©Ÿèƒ½ãŒå¿…è¦ã€ãƒ‘フォーマンスã®æ”¹å–„ã€ãƒã‚°ä¿®æ£ãªã©ãŒã‚ã‚‹ã ã‚ã†ã€‚ã—ã‹ã—ã€ã‚¢ãƒ—リケーションã¨çµ„ã¿åˆã‚ã›ãŸä¸Šã§äº‹å‰ã«åºƒç¯„囲ãªãƒ†ã‚¹ãƒˆã‚’ã—ã¦ãŠã‹ãªã„ã¨ã€ãƒªã‚¹ã‚¯ã®å¤§ãã„
Making MySQL Better at GitHub
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
Percona Database Consulting
All of Percona’s open source software products, in one place, to download as much or as little as you need.
MySQL :: MySQL yum repositories
I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL. Can’t wait? Neither can I. On a fresh install: Download a setup package for your distribution from http://dev.mysql.com/downloads/repo yum localinstall mysql-community-release-distro-release.no
Can't Create a New Thread: Errno 11 Fixes
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
(帰ã£ã¦ããŸ)InnoDBパフォーマンス最é©åŒ–ã®åŸºç¤Ž | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ç†è€…ãŒã€InnoDBã®ãƒ‘フォーマンスãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žã«ã¤ã„ã¦ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„OSã®é¸å®šã‹ã‚‰ãƒ‘ラメータã®æŽ¨å¥¨å€¤ã¾ã§è§£èª¬ã™ã‚‹ã€‚ 最近ã€2007å¹´ã«Peter ZaitevãŒæ›¸ã„ãŸã€ŒInnoDBパフォーマンス最é©åŒ–ã®åŸºç¤Žã€ã¨ã„ã†è¨˜äº‹ã‚’見ã¤ã‘ãŸã€‚ã“ã‚Œã¯ç´ 晴らã—ã„記事ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã€MySQLã¨Percona Serversãã—ã¦ä»Šæ—¥åˆ©ç”¨å¯èƒ½ãªå…¨ã¦ã®åŸºç›¤æŠ€è¡“ã«é–¢ã—ã¦ã€6å¹´è¿‘ãã®é–“ã«ä½•ãŒå¤‰ã‚ã£ã¦ããŸã®ã‹ã‚’見直ã—ã¦ã¿ãŸã„ã¨æ€ã‚ã›ã‚‹ã‚‚ã®ã 。 本当ã«ãŸãã•ã‚“ã®ã“ã¨ãŒå¤‰ã‚ã£ãŸã‚‚ã®ã ï¼ã“ã®è¨˜äº‹ã§ã¯ã€InnoDBã®ä½¿ç”¨ã«åŠ¹æžœçš„ãªãƒ‘ラメータã®å¤šãã«ã€ç‰¹ã«ãƒ‘フォーマンスã®è¦³ç‚¹ã‹ã‚‰ç„¦ç‚¹ã‚’当ã¦ã‚‹ã€‚ç§ã¯ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã€Percona Supportã§ã¯InnoDBパラメータã®é©åˆ‡ãªã‚µã‚¤ã‚ºã«é–¢ã™ã‚‹è³ªå•ãŒãŸãã•ã‚“寄ã›ã‚‰ã‚Œã¦ã„ã‚‹
MHA for MySQL ã®è©±
2. me • Masahiro Nagano • @kazeburo • NHN Japan • Operations Engineer Site Reliability é‹ç”¨ç³»å°å§‘ Perl Monger 2013å¹´3月8日金曜日 3. MHA for MySQLã¨ã¯ • å…ƒDeNA・ç¾facebookã®æ¾ä¿¡ã•ã‚“ã«ã‚ˆã‚‹ MySQLã®master冗長化ツール • Master High Availability ã®ç•¥ • MySQLサーãƒã‚’監視ã—ã¦ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ ã¨ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ã®ãƒžã‚¹ã‚¿ãƒ¼åˆ‡ã‚Šæ›¿ãˆã‚’サãƒãƒ¼ãƒˆ • Proxyåž‹ã§ã¯ãªã„ã®ã§SPOFã«ãªã‚‰ãªã„ • サーãƒã®åˆ‡ã‚Šæ›¿ãˆã¯åˆ¥ã‚¹ã‚¯ãƒªãƒ—トを起動 2013å¹´3月8日金曜日
MySQL :: MySQL 5.6 リファレンスマニュアル :: 11.1.1 数値型ã®æ¦‚è¦
数値データ型ã®ã‚µãƒžãƒªãƒ¼ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚数値型ã®ãƒ—ãƒãƒ‘ティーãŠã‚ˆã³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸è¦ä»¶ã®è¿½åŠ æƒ…å ±ã«ã¤ã„ã¦ã¯ã€ã‚»ã‚¯ã‚·ãƒ§ãƒ³11.2「数値型ã€ãŠã‚ˆã³ã‚»ã‚¯ã‚·ãƒ§ãƒ³11.7「データ型ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸è¦ä»¶ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„。 M ã¯æ•´æ•°åž‹ã®æœ€å¤§è¡¨ç¤ºå¹…を示ã—ã¾ã™ã€‚最大表示幅㯠255 ã§ã™ã€‚セクション11.2「数値型ã€ã§èª¬æ˜Žã—ã¦ã„るよã†ã«ã€è¡¨ç¤ºå¹…ã¯ãã®åž‹ã«å«ã‚ã‚‹ã“ã¨ãŒã§ãる値ã®ç¯„囲ã¨ã¯é–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“。浮動å°æ•°ç‚¹åž‹ã¨å›ºå®šå°æ•°ç‚¹åž‹ã®å ´åˆã€M ã¯æ ¼ç´å¯èƒ½ãªæ¡æ•°ã®åˆè¨ˆã§ã™ã€‚ 数値カラムã«å¯¾ã—㦠ZEROFILL を指定ã™ã‚‹ã¨ã€MySQL ã¯è‡ªå‹•çš„ã«ãã®ã‚«ãƒ©ãƒ ã« UNSIGNED å±žæ€§ã‚’è¿½åŠ ã—ã¾ã™ã€‚ UNSIGNED 属性を許å¯ã—ã¦ã„る数値データ型ã¯ã€SIGNED も許å¯ã—ã¾ã™ã€‚ãŸã ã—ã€ã“ã®ãƒ‡ãƒ¼ã‚¿åž‹ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ç¬¦å·ä»˜ãã«ãªã£ã¦ã„ã‚‹ãŸã‚ã€SIGNED 属性を指定ã—ã¦ã‚‚効果ã¯ã‚ã‚Šã¾ã›ã‚“。 SERIAL 㯠BIGINT U
MySQL :: MySQL 5.6 リファレンスマニュアル :: 11.1 データ型ã®æ¦‚è¦
æ•´æ•°åž‹ (真数値) - INTEGERã€INTã€SMALLINTã€TINYINTã€MEDIUMINTã€BIGINT
ソーシャルゲームã®ãŸã‚ã®MySQL入門 | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚最近ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–部的ã«ã¯ãƒ—ラットフォーム的ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æ供も行ã£ã¦ã„ã¾ã™ã€‚怪盗ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ょã†ã‹ã€‚ 僕ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’見ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”紹介ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10タイトル近ãã¯ãƒ¬ãƒ“ューã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚書ãã¾ã™ã€‚ ソーシャルゲームã®ãŸã‚ã®MySQL入門一覧 ソーシャルゲームã®ãŸã‚ã®MySQL入門 - Technology of DeNA ソーシャルゲームã®ãŸã‚ã®MySQL入門2 - Technology of DeNA 「MySQL
Impact of memory allocators on MySQL performance
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
ランã‚ング
メンテナンス
ãŠçŸ¥ã‚‰ã›
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
conma.me
etcfiles/etc/my.cnf at master · kamipo/etcfiles
MySQL Bootcamp — MySQL Bootcamp 2013 documentation
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬
https://labs.cybozu.co.jp/blog/kazuho/archives/2007/10/innodb_warmup.php
{{#tags}}- {{label}}
{{/tags}}