Registration: Machine learning & data conference | O'Reilly Strata
We’ve made the very difficult decision to cancel all future O’Reilly in-person conferences. Instead, we’ll continue to invest in and grow O’Reilly online learning, supporting the 5,000 companies and 2.5 million people who count on our experts to help them stay ahead in all facets of business and technology. Come join them and learn what they already know. Become an O’Reilly online learning member
Drizzle in Launchpad
7.2.3 Released on 2012-08-02 Fix for CTRL-Z for shutdowns. Many updates for JSON server. Improvements comp... 7.1.36 and 7.2.2 Released on 2012-05-23 7.1.36 is maintance release. 7.2.2 includes new work enabling SSL connections... 7.2.1 on 2012-05-08 First alpha release. 7.1.35 has been released. on 2012-05-08 7.1.35 is a maintenance release for 7.1. Fremont beta is out! on 2011-10-25 That's right
MySQL :: MySQL 8.0 リファレンスマニュアル :: 11.4.10 空間インデックスã®ä½œæˆ
InnoDB ãŠã‚ˆã³ MyISAM テーブルã®å ´åˆã€MySQL ã§ã¯ã€é€šå¸¸ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’作æˆã™ã‚‹å ´åˆã¨åŒæ§˜ã®æ§‹æ–‡ã‚’使用ã—ã¦ç©ºé–“インデックスを作æˆã§ãã¾ã™ãŒã€SPATIAL ã‚ーワードを使用ã—ã¾ã™ã€‚ 空間インデックスã®ã‚«ãƒ©ãƒ ã¯ã€NOT NULL ã¨å®£è¨€ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ 次ã®å„例ã§ã¯ç©ºé–“インデックスã®ä½œæˆæ–¹æ³•ã‚’示ã—ã¾ã™ã€‚ CREATE TABLE を使用ã™ã‚‹å ´åˆ: CREATE TABLE geom (g GEOMETRY NOT NULL SRID 4326, SPATIAL INDEX(g)); ALTER TABLE を使用ã™ã‚‹å ´åˆ: CREATE TABLE geom (g GEOMETRY NOT NULL SRID 4326); ALTER TABLE geom ADD SPATIAL INDEX(g); CREATE INDEX を使用ã™ã‚‹å ´åˆ: CREATE TABLE
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
6.コンパイル処ç†å¾Œã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’行ㆠシェルプãƒãƒ³ãƒ—トã‹ã‚‰ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’入力ã—ã¦ãã ã•ã„ # make $ su # make install 7.åˆæœŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”Ÿæˆ åˆã‚ã¦MySQLをインストールã™ã‚‹å ´åˆã®ã¿ã€åˆæœŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’生æˆã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ # ./scripts/mysql_install_db mysql_install_dbを実行ã—ãŸãƒ¦ãƒ¼ã‚¶ã¨rootユーザを生æˆã—ã¾ã™ã€‚ 続ã„ã¦mysql_install_dbを実行ã—ãŸãƒ¦ãƒ¼ã‚¶ã¨rootユーザをMySQL上ã«ç”Ÿæˆã—ã¾ã™ã€‚ （ã“ã“ã§ç”Ÿæˆã•ã‚Œã‚‹ãƒ¦ãƒ¼ã‚¶ã¯ã€MySQL上ã§ã®ãƒ¦ãƒ¼ã‚¶ã§ã™ã€‚Linux上ã®ãƒ¦ãƒ¼ã‚¶ã§ã¯ã‚ã‚Šã¾ã›ã‚“） エントリã•ã‚Œã‚‹ãƒ¦ãƒ¼ã‚¶ã®ãƒ‘スワードã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ç©ºæ–‡å—列ã§ã™ã€‚ ãƒã‚¤ãƒŠãƒªã®ã‚ªãƒ¼ãƒŠãƒ¼ã‚’rootã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®æ‰€æœ‰æ¨©ã‚’mysqldを実行ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ã«å¤‰æ›´ã—ã¾ã™ã€‚ # chown -R r
InnoDB Performance Optimization Basics
This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7 and 8.0 have been released since then with some major changes. These guidelines work well for
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
Amazon.co.jp: 実践ãƒã‚¤ãƒ‘フォ-マンスMySQL: Jeremy D.Zawodny (è‘—), Derek J.Balling (è‘—), 林秀幸 (翻訳): 本
landhere.info
{{#tags}}- {{label}}
{{/tags}}