MySQL :: Download MySQL Community Server (Archived Versions)Please note that these are old versions. New releases will have recent bug fixes and features! To download the latest release of MySQL Community Server, please visit MySQL Downloads.
SH2先生ã®RDB比較, ã¶ã£å£Šã‚Œç·¨
SH2 @sh2nd 個人的ã«ãã†ãªã‚“ã ã‚ã†ãªã‚ã¨æ€ã£ã¦ã„ãŸã“ã¨ãŒæ›¸ã„ã¦ã‚ã£ã¦ã€ã¨ã¦ã‚‚è…‘ã«è½ã¡ãŸè¨˜äº‹ / how oracle prevent "partial write" | Oracle Community https://t.co/nHcmvh5ZSA 2014-05-18 13:21:43 SH2 @sh2nd MySQLã®innodb_doublewriteã€PostgreSQLã®full_page_writesã®ã‚ˆã†ãªã€ãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ãŒåŠåˆ†ã—ã‹æ›¸ã‹ã‚Œã¦ã„ãªã„事態を想定ã—ãŸå‡¦ç†ã¯ã€Oracle Databaseã¯ALTER TABLESPACE BEGIN BACKUPã®ã¨ãã«ã®ã¿è¡Œã† 2014-05-18 13:26:55 SH2 @sh2nd ãªã®ã§ã‚µãƒ¼ãƒã‚¯ãƒ©ãƒƒã‚·ãƒ¥æ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ãŒå£Šã‚Œã¦ã„ã¦ã€REDOã‚’é©ç”¨ã—ãŸã ã‘ã§ã¯ç›´ã›ãªã„ã“ã¨ãŒã‚る。ãŸã ãã®å ´åˆOracle Dat
ルークï¼MySQLã§ã¯kamipo TRADITIONALを使ãˆï¼ | ãŠãらãã¯ãã‚Œã•ãˆã‚‚平凡ãªæ—¥ã€…
よãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ 値ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚られる エラーãŒèµ·ããšã«å¤‰ãªå€¤/日付ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ーマãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚れるã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(確ã‹ã«æ˜”デフォルトãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„よã†ã«è¨å®šã¯ã¨ã«ã‹ã厳ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„をコントãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚以å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’書ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸å分ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚らã„ã¾ã—ãŸã€‚ @songmu TRADITI
ムック「データベース徹底攻略〠- MySQL/Redis/MongoDB/Redshift
最近発売ã•ã‚ŒãŸæŠ€è¡“評論社ã®ãƒ ック「データベース徹底攻略ã€ã«å¯„稿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€MongoDBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ 技術ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„プãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€MongoDBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„る方々ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚考ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚記事を寄稿ã—ã¾ã—ãŸã€‚詳細ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚自分ãŒå„技術をç¾æ™‚点ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„内容ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ・MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
MySQL is bazillion times faster than MemSQL
I don’t like stupid benchmarks, as they waste my time. I don’t like stupid marketing, as it wastes my time too. Sometimes I succumb to those things, and now in return I want to waste your time a bit. So, this MemSQL thing, written by some smart guys has been making rounds in press and technical community. Centerpiece of all the communication was: “MemSQL, the database they have developed over the
Membrain | Schooner Information Technology
Membrain The Smart Memcached, Optimized for Flash Memory A software cache is often used, standalone or in front of a database, to increase application performance. Memcached is the most widely-used software cache, powering many high-volume web sites. But traditional memcached has a dark side also shared by the many NoSQL databases available today. With all of them, you need to keep your data in DR
GitHub - vitessio/vitess: Vitess is a database clustering system for horizontal scaling of MySQL.
Vitess is a cloud-native horizontally-scalable distributed database system that is built around MySQL. Vitess can achieve unlimited scaling through generalized sharding. Vitess allows application code and database queries to remain agnostic to the distribution of data onto multiple database servers. With Vitess, you can even split and merge shards as your needs grow, with an atomic cutover step th
MySQL DBマスタã«Fusion-IOを使ã£ã¦ã¿ã¦å›°ã£ãŸã“㨠| Ore no homepage
仕事ã®åˆé–“ã«é›‘記ã§ã™ã€‚ã¾ãŸMySQLã«é–¢ã™ã‚‹è¨˜äº‹ã§ã™ã€‚Fusion-IOã‚’MySQL DBマスタã«ä½¿ã†æ™‚ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–(ã“ã£ã¡ã‚‚Fusion-IO)ãŒè€ãˆã‚‰ã‚Œã‚‹ã‹æ¤œè¨¼ã—ãŸæ–¹ãŒè‰¯ã„よã£ã¦è©±ã€‚ ãŠã‚ŒãŒæ‹…当ã—ã¦ã„るシステムã¯ä»–ã®ã‚·ã‚¹ãƒ†ãƒ ã®æ›´æ–°æƒ…å ±ã‚’ã‹ã集ã‚ã¦ã¾ã¨ã‚るよã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ã™(ã‚ã„ã¾ã„ãªèª¬æ˜Žã§ã™ã¿ã¾ã›ã‚“)。早ã„話ã€æ›´æ–°ç³»ã®å‡¦ç†ãŒã‹ãªã‚Šå¤šã„ã§ã™ã€‚ 更新処ç†ãŒå¤šã„ã¨ãã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ–½ã™ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã®ä¸€ã¤ã«ãƒ‡ãƒ¼ã‚¿åˆ†å‰²ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ãƒžã‚¹ã‚¿ã‚’分割ã—ã¾ãã£ã¦ã‚µãƒ¼ãƒã‚’何åå°ã‚‚ラッã‚ングã—ã¦é‹ç”¨ã™ã‚‹ã®ã¯éª¨ã§ã—ãŸã€‚ãã“ã§ioDriveã®åŠ›ã‚’借りるã“ã¨ã«ã—ã¾ã—ãŸã€‚ioDriveã®åŠ›ã§DBã‚’æ•°å°ã«é›†ç´„ã—ã¦ã—ã¾ãŠã†ã¨ã€‚一応説明ã—ã¦ãŠãã¨ioDriveã¨ã¯Fusion-IO社ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã€PCIe接続ã®è¶…高性能ストレージã§ã™ã€‚詳ã—ãã¯ä¸‹è¨˜ã®ãƒªãƒ³ã‚¯ã‚’å‚照。 http://www.fusionio.com/pla
MySQLã®rootã®ãƒ‘スをリセットã™ã‚‹ - phpspot
1. MySQLã®ãƒ‡ãƒ¼ãƒ¢ãƒ³ãƒ—ãƒã‚»ã‚¹ã‚’åœæ¢ã™ã‚‹ 2. --skip-grant-tables オプションをã¤ã‘ã¦mysqldã‚’å†èµ·å‹• 3. mysql -u root ã§MySQLクライアント立ã¡ä¸Šã’ 4. UPDATE mysql.user SET password=PASSWORD('password') WHERE user='root'; 5. FLUSH PRIVILEGES; ã®å®Ÿè¡Œ MySQLを権é™ç„¡è¦–モードã§ç«‹ã¡ä¸Šã’ã¦ã€ 後ã¯é€šå¸¸ã®ãƒ‘スワード更新ã¨åŒã˜è¦é ˜ã§å‡¦ç†ã™ã‚Œã°ãƒ‘スワードをリセット出æ¥ã¾ã™ã€‚ スãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ PHP&MySQL
MySQLã«ãŠã‘るレプリケーションé…延ã®å‚¾å‘ã¨å¯¾ç–
レプリケーションã¯MySQLã§æœ€ã‚‚よã使ã‚れる機能ã®ã²ã¨ã¤ã 。レプリケーションã¯åŸºæœ¬çš„ã«éžåŒæœŸã§ãƒ‡ãƒ¼ã‚¿ã®è¤‡è£½ã‚’è¡Œã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã ãŒã€éžåŒæœŸæ•…ã«ã©ã†ã—ã¦ã‚‚逃れられãªã„å•é¡ŒãŒã‚る。ãã®ã²ã¨ã¤ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã€é…延ã§ã‚る。ã¨ã„ã†ã¨ã€MySQLã®ãƒ¬ãƒ—リケーションã¯ã™ãã«é…延ãŒç”Ÿã˜ã¦ã—ã¾ã†ã‚ˆã†ã«æ„Ÿã˜ã¦ã—ã¾ã†ã‹ã‚‚知れãªã„ãŒã€ãã®ã‚ˆã†ãªã“ã¨ã¯ãªã„。ã»ã¨ã‚“ã©ã®å ´åˆã¯å³åº§ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ›´æ–°ãŒè¡Œã‚れる。 ãªãœé…延ã¯ç™ºç”Ÿã™ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«é…延ãŒèµ·ãã¦ã„ã‚‹ã“ã¨ã‚’調ã¹ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’本エントリã§ã¯è§£èª¬ã—ãŸã„。ã†ã¾ãé…延ã¨ä»˜ãåˆã£ã¦ã€MySQLã®ãƒ¬ãƒ—リケーションをより快é©ã«é‹ç”¨ã—ã¦ã‚‚らãˆã‚Œã°ã¨æ€ã†ã€‚ ãã‚‚ãã‚‚é…延ã¨ã¯ä½•ã‹MySQLã®ãƒ¬ãƒ—リケーションã¯éžåŒæœŸã§è¡Œã‚れる。ã“ã‚Œã¯æº–åŒæœŸã§ã‚‚åŒã˜ã§ã‚ã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãŠã„ã¦æ›´æ–°ãŒèµ·ãã‚‹ã®ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚ˆã‚Šã‚‚一瞬é…ã‚Œã¦ã—ã¾ã†ã€‚ã“ã‚Œã¯éžåŒæœŸã§ã‚ã‚‹ãŒæ•…ã«é€ƒã‚Œ
Art of MySQL Replication.
1. Art Of MySQL Replicaton 〜 10 å¹´ã®æ´å²ã‚’誇るレプリケーションã®å¦™æŠ€ã€œ 奥野 幹也 @nippondanji mikiya (dot) okuno (at) gmail (dot) com 2. å…è²¬äº‹é … ◠本プレゼンテーションã«ãŠã„ã¦ç¤ºã•ã‚Œã¦ã„る見解ã¯ã€ ç§è‡ªèº«ã®è¦‹è§£ã§ã‚ã£ã¦ã€ã‚ªãƒ©ã‚¯ãƒ«ãƒ»ã‚³ãƒ¼ãƒãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ ã®è¦‹è§£ã‚’å¿…ãšã—ã‚‚åæ˜ ã—ãŸã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“。ã”了 承ãã ã•ã„。 3. 自己紹介 ◠今日ã¯å€‹äººã¨ã—ã¦æ¥ã¦ã„ã¾ã™ã€‚ – http://nippondanji.blogspot.com/ – Twitter: @nippondanji â— ç¾è·ã¯ MySQL サãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€‚ – 2000 å¹´ã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ズ入社 – 2007 å¹´ã« MySQL KK ã¸è»¢è· – 気付ãã¨ã¾ãŸã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ズã«ãƒ»ãƒ»ãƒ» – ç¾åœ¨ã¯æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã«åœ¨å¸ã€‚ â—
MySQL Binary Log API Presentation - OSCON 2011
The document outlines an API for reading the MySQL binary log. It discusses how the API allows applications to connect to the MySQL server and read binary log events such as queries, row changes, and other events. It provides examples of using the API to iterate through events, read specific event data, and create custom event handlers to process the replication stream. The API is designed to be s
mixi ã®å¹´æœ«å¹´å§‹å¯¾ç– 2009-2010 - mixi engineer blog
ã“ã‚“ã«ã¡ã¯ã€‚パートナーサービス部ã®åŠ 藤和良ã§ã™ã€‚ 2008年末ã«ã€mixi ã®å¹´æœ«å¹´å§‹å¯¾ç–ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã—ãŸã€‚今回ã¯ã€ã“ã“æ•°å¹´ã®å¹´æœ«å¹´å§‹å¯¾ç–ã®æ©ã¿ã¨ã€ä»Šå¹´ã®å¯¾ç–ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚実をã„ã†ã¨ã€è¨è¨ˆã‚‚実装も自分ã˜ã‚ƒãªã‹ã£ãŸã‚Šã™ã‚‹ã®ã§ã™ãŒã€ã“ã®ã¾ã¾æ´å²ã«åŸ‹ã‚‚ã‚Œã¦ã„ãã®ã‚‚悲ã—ã„ã®ã§ã€é–¢ä¿‚å„所ã«å–æã—ã¦ã¿ã¾ã—ãŸã€‚ 2008年末をãµã‚Šã‹ãˆã‚‹ ã¾ãšã¯ã€2008年末をãµã‚Šã‹ãˆã£ã¦ã¿ã¾ã—ょã†ã€‚ ã‚ã®ã“ã‚ã¯ã¾ã mixi ã®æ©Ÿèƒ½ã‚‚å°‘ãªãã€å¹´æœ«å¹´å§‹ã®è² è·ã¯ä¸»ã«æ—¥è¨˜ã«é›†ä¸ã—ã¦ã„ã¾ã—ãŸã€‚ãã“ã§å½“時㯠ID Generator ã®æ”¹å–„ - mod_perl ã‚’ã‚ã„ã ã«ã¯ã•ã‚“㧠MySQL ã¸ã®æŽ¥ç¶šæœ¬æ•°ã‚’æ¸›ã‚‰ã™ æœ€æ–°æƒ…å ±DBã¸ã®æ›¸ãè¾¼ã¿ã‚’éžåŒæœŸã« - Q4M ã‚’ã¤ã‹ã£ã¦è² è·ã‚’時間軸ã§åˆ†æ•£ã™ã‚‹ ã¨ã„ã†2ã¤ã‚’日記ã«å®Ÿè£…ã—ãŸã®ã§ã—ãŸã€‚ ã—ã‹ã—ã€2008年末ã‹ã‚‰2009å¹´ã®ãŠæ£æœˆã«ã‹ã‘ã¦ã€mixi ã¯ã¾ãŸã‚‚日記ã«
Kazuho at Work: Q4M - 0.6 release and benchmarks
Today I have uploaded Q4M (a Queue for MySQL) 0.6, which is basically a performance-improvement from previous releases. Instead of using pread's and a small user-level cache, Q4M (in default configuration) now uses mmap for reads with a reader/writer lock to improve concurrency. I also noticed that it would be possible to consume a queued row in one SQL statement. SELECT * FROM queue_table WHERE q
q4m ã® configure ã®ã‚ªãƒ—ションã«ã‚ˆã‚‹é€Ÿåº¦ã®é•ã„ - kameidã®å‚™å¿˜éŒ² - Sharpen the Saw!
q4m ã® configure ã®ã‚ªãƒ—ション変更ã«ã‚ˆã£ã¦ã©ã®ç¨‹åº¦ãƒ‘フォーマンスã«é•ã„ãŒå‡ºã‚‹ã®ã‹æ¯”較ã—ã¦ã¿ãŸã€‚ Intel(R) Xeon(TM) CPU 2.80GHz x 4 CPU OS : Debian(Etch) ã¾ãšã¯ã€default 状態。 ./configure --with-mysql=/home/kameid/mysql-5.1.30/ --prefix=/usr/local/mysql 暗黙的ã«ã€ä»¥ä¸‹ã®ã‚ªãƒ—ションを指定ã—ã¦ã„ã‚‹ã“ã¨ã«ãªã‚‹ã€‚ --with-sync=yes commit to disk at checkpoints (default) --with-delete=pwrite use pwrite for row deletions (default) t/05-multireader..........................ok 1/4 Mul
ランã‚ング
ランã‚ング
ãŠçŸ¥ã‚‰ã›
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Oracle/MySQL Engineering in Launchpad
MySQL :: MySQL 8.0 リファレンスマニュアル :: 23.1.1 NDB Cluster ã®ã‚³ã‚¢æ¦‚念
http://www.mysqlpracticewiki.com/index.php/MySQL_Cluster%E3%81%AE%E3%83%A1%E3%83%A2%E3%83%AA%E3%82%B5%E3%82%A4%E3%82%BA%E8%A6%8B%E7%A9%8D%E3%82%82%E3%82%8A
United States
Good night, Posterous
{{#tags}}- {{label}}
{{/tags}}