All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Home
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
MySQL Performance Tuning Settings
Note: This blog has been updated for MySQL 5.7 here!In this blog, we’re going to discuss the top ten MySQL performance tuning settings that you can implement after an installation. When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised because in most cases, we only suggest changing a few MySQL perfo
MySQLã®Zero Dateã¸ã®å¯¾å‡¦æ³•
MySQLã®Zero Dateã¸ã®å¯¾å‡¦æ³• MySQLã®0000-00-00 00:00:00ã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„ - ãーã ã„ãªã‚‹ã‚‰ããŒã帳 ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã€MySQLã®ã‚¼ãƒãŒå«ã¾ã‚Œã‚‹æ—¥ä»˜ã‘ã€ã„ã‚ゆるZero Dateã«ã¤ã„ã¦ã®å•é¡Œç‚¹ãŒè‰²ã€…挙ã’られã¦ã„ã‚‹ã®ã‚’見ã‹ã‘ãŸã®ã§ã€æ‰‹çŸã«å¯¾å‡¦æ³•ã‚’è¿°ã¹ã¦ãŠããŸã„。 Zero DateãŒå˜åœ¨ã™ã‚‹ç†ç”±ãªãœãã‚“ãªåŽ„介ãªãƒ‡ãƒ¼ã‚¿ãŒå˜åœ¨ã™ã‚‹ã®ã‹ã¨ã„ã†ã®ã¯ã€é–‹ç™ºã®çµŒç·¯ã‚„互æ›æ€§ã¨ã„ã£ãŸæ·±æ·µãªç†ç”±ã‹ã‚‰ãªã®ã§æ°—ã«ã—ãªã„ã§æ¬²ã—ã„。ã¾ã‚ã€äººé–“ã¯å®Œç’§ã§ã¯ãªã„ã®ã§ã€äººé–“ãŒä½œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ も完璧ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã 。 当然ãªãŒã‚‰SQL標準ã‹ã‚‰å¤–ã‚Œã¦ã„ã‚‹ã‚‚ã®ã¯ã€ä¾‹å¤–çš„ãªä½¿ã„方をã—ãŸã„å ´åˆã‚’除ãã€ä½¿ã†ã¹ãã§ã¯ãªã„。アンãƒãƒ‘ターンも使ã„方次第ã¨ã„ã†è©±ã‚‚ã‚ã‚‹ãŒã€ä¾‹å¤–çš„ãªä½¿ã„æ–¹ã¯åŸºæœ¬çš„ã«è‹¦åŠ´ãŒå¢—ãˆã‚‹ã®ã§ä½¿ã†ã¹ãã§ã¯ãªã„。 SQLモード実ã¯ã€Zero Dateã¯SQLモードã§ç¦æ¢ã§ãる。SQLモー
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ データベース専門家ãŒ8ã¤ã®è¦–点ã§å¾¹åº•æ¯”較ï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBI（アンビ）
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ データベース専門家ãŒ8ã¤ã®è¦–点ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆã比較ã•ã‚Œã‚‹PostgreSQLã¨MySQL。ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ょã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚門家ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ エンジニアã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDB）をé¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚自社サービスã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ルãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“。 ãªã‹ã§ã‚‚よã比較検討ã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQL。ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ンソースRDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„性能ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ょã†ã‹ã€‚ã
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32 - Garbage in, gospel out
èµ·ããŸã“㨠ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã‹ã‚‰ mysql ã«ã¤ãªã”ã†ã¨ã—ãŸã‚‰ä»¥ä¸‹ã®æ§˜ãªã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—繋ã’ãªããªã£ãŸã€‚ $ mysql -uroot ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32 åŽŸå› 1 process ã‚ãŸã‚Šã®è¨±å®¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚ªãƒ¼ãƒ—ン数を超ãˆã¦ã—ã¾ã£ãŸã“ã¨ãŒåŽŸå› ã®æ§˜å。 MySQL 5.6 ã® innodb_file_per_table オプションã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ ON ã«ãªã£ã¦ã„る。 ON ã«ã™ã‚‹ã¨å„テーブルã®ãƒ‡ãƒ¼ã‚¿ã¯ãã‚Œãžã‚Œã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ä¿å˜ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ OSX ã®å ´åˆã€1 process ã‚ãŸã‚Šã®è¨±å®¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚ªãƒ¼ãƒ—ン数ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ 256 ã¨ãªã£ã¦ã„る。 ã“ã®æ•°å—ã¯é€šå¸¸å•é¡Œã«ãªã‚‰ãªã„ãŒã€ parallel ã«
awesome-mysql
awesome-mysql A curated list of awesome MySQL free and opensource software, libraries and resources. This list accepts and encourages pull requests. See CONTRIBUTING Contents Awesome MySQL Analysis Backup Benchmarking Binlog Replication ChatOps Configuration Connectors Deployment Development GUI HA Proxy Replication Schema Security Server Sharding Toolkits Resources E-Books Media Newsletters Analy
MySQL :: MySQL InnoDB Cluster GA is Available Now!
The MySQL Development Team is happy to announce the first GA release of InnoDB Cluster–our integrated, native, full stack HA solution for MySQL. You can see highlights of the changes and improvements made since the RC release here, and you can download the GA packages from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories or from dev.mysql.com. InnoDB Cluster consists of th
MyRocks: A space- and write-optimized MySQL database
At Facebook we use MySQL to manage many petabytes of data, along with the InnoDB storage engine that serves social activities such as likes, comments, and shares. While InnoDB provides great performance and reliability for a variety of workloads, it has inefficiencies on space and write amplification when used with flash storage. A few years ago, we built RocksDB, an embeddable, persistent key-val
On Uber’s Choice of Databases
TranslationsA Japanese translation of this article is available here. A Chinese translation of this article is available here. A few days ago Uber published the article “Why Uber Engineering Switched from Postgres to MySQLâ€. I didn’t read the article right away because my inner nerd told me to do some home improvements instead. While doing so my mailbox was filling up with questions like “Is Postg
DMM inside
ãªã›ã‚™DMMã‹ã‚™web3ã«å‚å…¥ã—ãŸã®ã‹ã€‚Seamoon Protocolã‹ã‚™ç›®æŒ‡ã™æ–°ãŸãªã‚¨ãƒ³ã‚¿ãƒ¡ä½“験ã®æœªæ¥ã¨ã¯
æ ªå¼ä¼šç¤¾ã‚³ãƒãƒ—ラã€ä½ç½®ã‚²ãƒ¼ã§æ¯Žæ—¥ã®ç§»å‹•ã‚’楽ã—ã】
スマホゲームã€ä½ç½®ã‚²ãƒ¼ã®ã‚³ãƒãƒ—ラ｜"Entertainment in Real Life"エンターテインメントã§æ—¥å¸¸ã‚’より楽ã—ãã€ã‚ˆã‚Šç´ 晴らã—ã 未æˆå¹´ä¿è· æŽ¡ç”¨æƒ…å ± ãŠå•ã„åˆã‚ã› ENGLISH ニュースリリース ä¼šç¤¾æƒ…å ± IRæƒ…å ± プãƒãƒ€ã‚¯ãƒ„ リアル連æºäº‹æ¥ CSR コãƒãƒ—ラã¯ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã«ç‰¹åŒ–ã—ãŸãƒ¢ãƒã‚¤ãƒ«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚²ãƒ¼ãƒ ã‚„ä½ç½®æƒ…å ±ã‚µãƒ¼ãƒ“ã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã€Œã‚³ãƒãƒ—ラã€ã‚’é‹å–¶ã™ã‚‹ä¼šç¤¾ã§ã™ã€‚ エンターテインメントã§ãƒãƒƒãƒˆã¨ãƒªã‚¢ãƒ«ã‚’ã¤ãªãŽã€ä¸–ç•Œä¸ã®æ—¥å¸¸ã‚’より楽ã—ãã€ã‚ˆã‚Šç´ 晴らã—ãã™ã‚‹ã“ã¨ã‚’目指ã—ã¦ã„ã¾ã™ã€‚ コãƒãƒ—ラ TOP
雑ãª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
Amazon Aurora - Looking Deeper
Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries regarding this technology. I’ve decided to form my own opinion, and nothing is better than a personal, hands-on experience, which I am going to share. The materials I will refer
Linux performance tuning tips for MySQL
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ページを開ã
Installing MySQL in Docker fails with error message "Can't connect to local MySQL server through socket"
How do I find which transaction is causing a "Waiting for table metadata lock" state?
PostgreSQL and MySQL’s Peaceful Battle for Today’s Demanding Workloads - DZone
The MySQL “swap insanity†problem and the effects of the NUMA architecture
ヤフー社内ã§ã‚„ã£ã¦ã‚‹MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚»ãƒŸãƒŠãƒ¼å¤§å…¬é–‹
MySQL - Documentation
{{#tags}}- {{label}}
{{/tags}}