Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ãµã¤ãã¼ã¨ã¼ã¸ã§ã³ãå ¬å¼ããã°ãã覧ã®çããããã°ãã¯ãã¤ã³ãã©ï¼ã³ã¢ãã¯æ¬é¨ã®é è¤(@strsk)ã§ããæ®æ®µã¯Amebaã®ã½ã¼ã·ã£ã«ã²ã¼ã å ¨è¬ã®ã¤ã³ãã©ãè¦ã¤ã¤ãæ¥æ¬èªã©ããã®åèãããªããå¼ç¤¾ç¤¾å¡ãç´ æã«ã³ã©ç»åãã¤ãã£ãããã¦ãã¾ãã好ããªAAã¯éº»åã§ãã ã¯ããã¨ããããã§ä»åã¯MySQLã¤ã³ããã¯ã¹ãã¥ã¼ãã³ã°ã®åºæ¬çãªæµãã«ã¤ãã¦ã¾ã¨ãã¦ã¿ã¾ããã ã½ã¼ã·ã£ã«ã²ã¼ã ã¯æ´æ°ãåç §ããã¡ããã¡ãå¤ãã§ããæ°ç§ã®ã¬ããªã±ã¼ã·ã§ã³é å»¶ãè´å½çãªã®ã§é©åãªãã¼ãã«ãã¯ã¨ãªã¨ã¤ã³ããã¯ã¹è¨è¨ãéè¦ã§ããï¼ä½ã§ãããã§ããã©ï¼ã¤ã³ããã¯ã¹ãå¤ããªãã¨æ´æ°ã³ã¹ããªã©ãæ¸å¿µããã¾ãããã¤ã³ããã¯ã¹ãæ£ãã使ããã¦ããªãã¯ã¨ãªãæ¾ç½®ãã¦ããæ¹ãæªã§ãããããªãããªã§ãå²ã¨ä¾ãåã£ãããã¦ãããããã¾ããããããããã åæã¨ãã¦ã¯InnoDBãæ³å®ãã¦ãã¾ããMyISAMã¯ã»ã¨ãã©ä½¿ã£ã¦ãã¾ããã
Percona MySQL Webinarsã®çºè¡¨(MYSQLéçºã§ãã£ã¦ãã¾ããã¡ãªè´å½çãªãã¹ã«ã¤ãã¦)ã®QAããç´¹ä»ãã¾ãã æ¬çºè¡¨ã¯SQLã¢ã³ããã¿ã¼ã³èè ã®Bill Karwinããã®çºè¡¨ã§ãã ãªãªã¸ãã«: http://www.percona.com/resources/mysql-webinars/how-avoid-even-more-common-deadly-mysql-development-mistakes July 17, 2014 by Bill Karwin æ°´ææ¥ã«ãMySQLãéçºããä¸ã§ããèµ·ãã(ããã¦è´å½çãª)ãã¹ãã©ã®ããã«åé¿ãããããPercona MySQL webinarsã§çºè¡¨ããããè¦éã®éã¯ããããªã¨ã¹ã©ã¤ããè¦ãçºã«ç»é²ããã°ã¾ã ã覧ã«ããã ããã åå ããã ããçæ§ãããã¦ã¨ããããã°ããã質åããã¦ããã ããããããæã£ã¦ãã
2014-01-19 Chef Soloã§Vagrantä¸ã«MySQLãã¤ã³ã¹ãã¼ã«ãã chef mysql Chef Soloã§Vagrantä¸ã«MySQLãã¤ã³ã¹ãã¼ã«ãã Vagrantã®å°å ¥ã¨ã¡ãã£ã¨ãããµã¼ãã®åæè¨å®ããã¦ã¿ã ãæ¸ãã¦ããã èªåã§ãã¬ã·ããæ¸ãã¦ã¿ããã¨æã, mysqlã®ã¤ã³ã¹ãã¼ã«ãè¡ãã¬ã·ããæ¸ãã¦ã¿ã¾ãã. ãããããªããªãã¾ã¨ã¾ã£ãæ å ±ããã³ã¬ï¼ã¨ãã£ããã®ããªããã èªåèªèº«ã§è²ã ã¨è©¦ããªããã°ãããªããã¨ãå¤ãå¦ç¿ã³ã¹ãã¯é«ãããã¨æãã¾ãã. ã¨ãããããåããã®ãæ¸ãã¦ããã£ã... åãã¦ã®ã¬ã·ãã§ãã, ä¸å¿ githubã«ã¦å ¬éãã¦ã¿ãã®ã§ãè²ã ã¨ãã£ã¼ãããã¯ãã¦é ããã¨å¹¸ãã§ã. MyChef-repo/mysql at master · seka/MyChef-repo ãªããªãæéã¯ããã£ã¦ãã¾ã£ãã®ã§ãã, ä¸åº¦æ¸ãã¦ãã¾
MySQLã®æä¾ãã¦ããYumãªãã¸ããªãå©ç¨ãã¦MySQLã®5.6ããã»ãã¥ã¢ã¤ã³ã¹ãã¼ã«ãããã DBãµã¼ã建ã¦ãããã«ã¯ã²ã¨ã¤ã¯DB欲ãããããç¨ã®ã¦ã¼ã¶ã欲ãã ã¨ãããã¨ã§ãã®ããããã«ãã¼ããChefã¬ã·ãã使ãã¦ã¿ã¾ããã ã夿°ãã«å½ããé¨åã¯é©å®DataBagãªãã使ã£ã¦ããã ãã»ãããã¿ã¼ã§ããããã ã¾ãã¯ã¬ã·ã # add mysql yum repository remote_file "#{chef::config[:file_cache_path]}/mysql-community-release-el6-5.noarch.rpm" do source 'http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm' action :create end rpm_package "mysql-c
profile id: Songmu (ã½ã³ã ã¼) Masayuki Matsuki http://www.songmu.jp/riji/ https://metacpan.org/author/SONGMU ã«ã¤ãã¯æè¡é¨ã½ã¼ã·ã£ã«ã²ã¼ã äºæ¥é¨ äºå¹´åã½ã¼ã·ã£ã«ã²ã¼ã 漬ã ä»å¹´æ°ãã«ä¸ããCPANã¢ã¸ã¥ã¼ã« Riji Puncheur DBIx::Schema::DSL Cache::Redis Config::PL Redis::LeaderBoard DBIx::FixtureLoader SQL::Maker::Plugin::JoinSelect Teng::Plugin::SearchJoined Git::Repository::FileHistory GitDDL::Migrator UnazuSan Plack::Middleware::Woothee Plack::Mi
MySQLã®warningã£ã¦ã æååãé·ãããããåæã«çããã¦ä¿åãã¦ãããã! æ°åã大ããããããé©å½ãªæ°åãä¿åãã¦ãããã!! æ°å¤ã¨ãã¦è§£éã§ããªãæååããã£ããã0ã¨ã¿ãªãã¦æ¯è¼ããã!!! ãªã©ãç¡è¦ããã¨æ»ã¬ç³»ã¡ãã»ã¼ã¸ã§ãããã¨ãå¤ããã ãã©ç¡è¦ãããã¡ãªã®ã§å°ãè ã insertç³»ã®warningã«ã¤ãã¦ã¯sql_modeã®è¨å®ãå¤ãããã¨ã§ã¨ã©ã¼ã«ã§ãããã ãã©ããã®è¨å®ããªããã¦ãªãã£ãããselectãã¤ãã¤ã¿ãããªã±ã¼ã¹ããã£ãããã¦ãª(ï¼Â´Ðï½) ã¨ããããã§ãActiveRecordå´ã§ãã§ãã¯ããã¢ã³ãã¼ããããæ¸ãã¾ãã(for mysql2)ã 1ã¯ã¨ãªå®è¡ãã¨ã«show warningæãã¦ãã®ã§æ¬çªã«ã¯ããããããªãã Mysql2::Clientããªãªã¼ã¹ãã¼ã¸ã§ã³ã«ã¯warning_countããªãã®ã§â¦â¦ãHEAD使ãããæ¬¡ãã¼ã¸ã§ã³
ä¸è¨ã®ãããªã·ã¹ãã ã§ããã©ã¼ãã³ã¹ãè¯ãã㪠SQLite ã使ç¨äºå®ã§ããããã£ã¨éããã®ãç¡ãã確èªã®ããä»ã®ãã¼ã¿ãã¼ã¹ã®ããã©ã¼ãã³ã¹ãè¨æ¸¬ãã¦ã¿ã¾ãããSQL å©ç¨åæã§ãããNoSQL ãå§åçãªæ§è½ãåºãå ´åã¯æ¤è¨ããå¿ è¦ãããã®ã§ KVS ã確èªãã¾ããã ãã¼ã¿ä»¶æ°ã¯ 1 åä»¶ç¨åº¦ãJDBC SQL å©ç¨å¯è½ INSERTãUPDATE ã¯ããã SELECT ã¯ä¸»ãã¼ã¢ã¯ã»ã¹æ§è½ãéè¦ å°æ¥ã¹ã±ã¼ã«ã¢ã¦ãã®ããã®åæ£ã¯ããããããã¹ã¿ã³ãã¢ãã³ã§é ãã®ã¯ã ã ãã¼ã¿ãã¼ã¹ã®ããã©ã¼ãã³ã¹æ¯è¼ è¨æ¸¬ãããã¼ã¿ãã¼ã¹ ãã¼ã¿ãã¼ã¹å ã¿ã¤ã å½¢æ è©å¤ è¨æ¸¬ã«ã¤ãã¦ã®åè SQLite RDB çµã¿è¾¼ã¿ â»2 ããã¡ããAndroidæ¨æº JDBCæä½ â»1 H2 RDB çµã¿è¾¼ã¿ â»2 çµã¿è¾¼ã¿æé JDBCæä½ â»1 Derby RDB çµã¿è¾¼ã¿ â»2 Javaæ¨æºã§
YAPC::Asiaã®ã¹ã©ã¤ãã§äºåãã¦ããéããå®éã«å¼ç¤¾ã®ããã¤ãã®ãµã¼ãã¹ã§ä½¿ã£ã¦ãã my.cnf ãå ¬éãã¾ããã github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»åãå ¬éããçç±ã¯MySQl Beginners Talksã®çºè¡¨ã®ä¸ã§ã触ãã¦ããéãã§ããMySQLã®ã½ã¼ã¹ã³ã¼ãä¸ã«å«ã¾ãããµã³ãã«ã®my.cnfãæè¿ã®ãµã¼ããã¼ãã¦ã§ã¢ãéç¨ã«åããªããªã£ã¦æ¥ã¦ããã¨ããç¶æ³ã§ãèªåã®è¨å®ã«ã¤ãã¤ãèªä¿¡ãæã¦ã¦ããªã人ã¯å°ãªããªãã¯ããããã§å社ç§ä¼ã®ã¿ã¬ç㪠my.cnf ãOpen & Shareãããã¨ã§ãã¢ãã³ãªmy.cnfãä½ãä¸ããäºãã§ããããããªããã¨ããèãã®ä¸ãä»å github ã«ã¦å ¬éãã¾ããã ãã¡ã¤ã«ã¯4ã¤ããããããã MySQL 4.0ã5.1ã5.5ãããã¦ãã¹ãä¸
å®è·µãã¤ããã©ã¼ãã³ã¹MySQL 第2ç ä½è : Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentz,Derek J. Balling,ä¼è¤ç´ä¹(ç£è¨³),ç°ä¸æ å¸(ç£è¨³),åå·è±è(ç£è¨³),æ ªå¼ä¼ç¤¾ã¯ã¤ã¼ãåºç社/ã¡ã¼ã«ã¼: ãªã©ã¤ãªã¼ã¸ã£ãã³çºå£²æ¥: 2009/12/14ã¡ãã£ã¢: å¤§åæ¬è³¼å ¥: 17人 ã¯ãªãã¯: 373åãã®ååãå«ãããã° (46ä»¶) ãè¦ã å®è·µãã¤ããã©ã¼ãã³ã¹MySQLã§ããMySQLéçºè ã«ã¨ã£ã¦ã¯èª°ããç®ãéãã¦ãããæ¹ãè¯ãã¨æ¨è¦ãããæ¬ãªã®ã§éè¦ãªãã¤ã³ãã ããã¾ã¨ãã¦ã¿ããã¨æãã¾ããã¾ã ååããèªãã§ãã¾ãããMySQLã®ç´°ãããã¯ããã¯ãè¼ã£ã¦ãã¦æåã§ããå ¨é¨ã§700ãã¼ã¸è¿ãããæ¬ãªã®ã§æãèªã¿ãããçµæãè¼ãã¦è¡ãã¾ããå 容ã¨ãã¦ã¯å®è·µçãªãã®
Homebrewã§MySQLãã¤ã³ã¹ãã¼ã«ããéã®æ³¨æç¹ãªã©ã«ã¤ãã¦ã§ããMySQLèªä½ã¯ã¤ã³ã¹ãã¼ã«æã«è¡¨ç¤ºãããæ³¨ææ¸ãã©ããã«è¨å®ããã°åé¡ãªãã£ãã®ã§ãããèµ·åã¹ã¯ãªããã§å°ããã©ãã£ãã®ã§åå¿é²ã§ãã ãã®ä»ã«ãã¡ã¢ã£ã¦ãããããã¨ããã£ãã®ã§è¨äºã«ãã¾ãããHomebrewã§MySQLãã¤ã³ã¹ãã¼ã«ããæ¹ã®åèã«ãªãã°ã¨æãã¾ãã MySQLã®ã¤ã³ã¹ãã¼ã«ã¨åæè¨å® ã¾ãã¯MySQLã®ã¤ã³ã¹ãã¼ã«ã ã¤ã³ã¹ãã¼ã«ãçµäºããã¨ãä¸ã®ããã«è²ã ã¨è¡¨ç¤ºãããã®ã§ããã®éãã«é²ãã¦ããã°ã¨ãããã使ããããã«ãªãã¾ãã ã¡ãªã¿ã«ããããã®æ³¨ææ¸ãã¯$ brew info mysqlãå®è¡ããã°ãã¤ã§ãè¦ãã¾ãã ãã¼ã¿ãã¼ã¹ã¨ã¦ã¼ã¶ã¼ã®è¨å® ã¤ã³ã¹ãã¼ã«ãæ¸ãã ãã表示ãããå 容ã«å¾ã£ã¦é ã«è¨å®ãã¦ããã¾ããæåã«ãã¼ã¿ãã¼ã¹ã®ã¤ã³ã¹ãã¼ã«ã¨ãã¼ã¿ãæ ¼ç´ããå ´æã®è¨å®ããã¾ãã $ u
ããã ãè¦ãã°å¤§ä¸å¤«ï¼ã¼MySQLããã©ã¼ãã³ã¹ç£è¦ã®ããï¼ã¯ã¨ãªç·¨ï¼ ããã«ã¡ã¯ãã¤ã³ãã©æ 彿°äººã® nob ã§ãã ãµã¼ãã¼ç£è¦ãã¼ã«ã§ MySQL ãç£è¦ãã¦ããã®ã«ãã¼ã¿ãå¤ããã¦æ´»ç¨ãã¦ããªããã¨ããæ¹ã¯ãã¾ãããï¼ãã®è±å¯ãªãã¼ã¿ãããã©ã¼ãã³ã¹ã»ãã¥ã¼ãã³ã°ã«æ´»ç¨ããªãæã¯ããã¾ãããä»åã¯ãµã¼ãã¼ç£è¦ãã¼ã«ã®ã°ã©ããèªã¿è§£ãã宿¦çµé¨ãå ã«ããããã ãè¦ãã°å¤§ä¸å¤«ãã¨ãããããã¾ã¨ãã¦ã¿ã¾ããã ããã ãè¦ãã°å¤§ä¸å¤«ï¼ãã¯ã¨ãªç·¨ãï¼ã¤ã®ã¤ã¼ã¨ï¼ã¤ã®ã°ã©ã ï¼ãã®ï¼ï¼ç£è¦ãã¼ã«ãä½ãè¦ã¦ããã®ãç¥ã ï¼ãã®ï¼ï¼ç£è¦ã®ãã¢ãã°ã©ãï¼ç¹ã»ãã (Questions, Lock Waits 㨠Transaction Handler) ï¼ãã®ï¼ï¼ã°ã©ãã§ãã§ãã¯ãã SQL ãã¥ã¼ãã³ã° ( Select Type 㨠Handler) ã·ã³ãã«ã§ãå§ãããµã¼ãã¼ç£è¦ã°ã©ãåãã¼ã«
ã¿ãªãã mysqldump ã¯å¥½ãã§ããï¼ èªåã¯ã©ã£ã¡ã§ãããã¾ããã MySQLã§ããããMaster-Slaveæ§æãä½ãæé ã¯ä»¥ä¸ã®ããã«ãªãã¨æãã¾ã MasterããSlaveã¨ãªããµã¼ãã«ä¸è²«æ§ãä¿ã£ãç¶æ ã®ã³ãã¼ããããã®ãã¼ã¿ã®ãã¤ããªãã°ã®ãã¡ã¤ã«ã»ãã¸ã·ã§ã³ãã¡ã¢ã SLAVEã§ãã¼ã¿ããªã¹ãã¢ããMasterã®ãã¹ãåãã¬ããªã±ã¼ã·ã§ã³ã«ä½¿ãã¦ã¼ã¶åã»ãã¹ã¯ã¼ãã¨ã¡ã¢ãããã¤ããªãã°ã®ãã¸ã·ã§ã³ãCHANGE MASTERæã«æ¸¡ããSTART SLAVE ä¸è²«æ§ã®åããã³ãã¼ã使ããããã«mysqldumpãxtrabackupãLVMãªã©ã§ã®ã¹ãããã·ã§ãããå©ç¨ã§ãã¾ããããã£ã¨ãç°¡åãªæ¹æ³ãmysqldumpã ã¨æãã¾ãã mysqldumpã§ä¸è²«æ§ã®ãããã¼ã¿ãã¨ãããã®éã®ãã¤ããªãã°ãã¸ã·ã§ã³ãè¨é²ããã«ã¯ $ mysqldump --single-
11æ25æ¥ããmobidec 2011ãã«ããã¦ã³ãããã¸ã¿ã«ã¨ã³ã¿ãã¤ã³ã¡ã³ãã®ã¹ã¿ã¸ãªITã»ã³ã¿ã¼é·ã§ããæ£å»¶å 弿°ã«ããã»ãã·ã§ã³ã大ãããSNSã²ã¼ã ããã©ã´ã³ã³ã¬ã¯ã·ã§ã³ããæ¯ããã³ããã®ã¯ã©ã¦ãæè¡ã®æ´»ç¨ããè¡ããã¾ããã ãã©ã´ã³ã³ã¬ã¯ã·ã§ã³ã¯ãGREEã§æä¾ããã¦ããæºå¸¯é»è©±åãã®ã«ã¼ãã²ã¼ã ã¿ã¤ãã®RPGããã¬ã¤ã¤ã¼ã¯ãã¨ãªã¢ãã¨ã«ããè¤æ°ã®ã¯ã¨ã¹ããã¯ãªã¢ãã¦ãããã¢ã³ã¹ã¿ã¼ã«ã¼ãããç§å®ããæã«å ¥ããããã«ããã©ã´ã³ã«ã¼ãããéãã¦ããã¾ããã¾ããã»ãã®ãã¬ã¤ã¤ã¼ã¨ããã«ãããã¨ã§ãç§å®ãå ¥æã§ããã¨ããSNSè¦ç´ ãåãå ¥ãããã¦ãã¾ããã2010å¹´9æã®ãµã¼ãã¹éå§å¾ãé 調ã«ãã¬ã¤ã¤ã¼æ°ã伸ã°ããç¾å¨ã§ã¯ç»é²äººæ°ã500ä¸äººãè¶ ãã¦ãã¾ãã ãµã¼ãã¹éå§å½åã¯ç¤¾å ã§ãµã¼ããæ§ç¯ããããã³ãã¨ã³ãã«6å°ã®ãµã¼ããããã¯ã¨ã³ãã«3å°ã®ãã¼ã¿ãã¼ã¹ãµã¼ããããã¦ãã¼ãã
ã¬ããªã±ã¼ã·ã§ã³ã¯MySQLã§æããã使ãããæ©è½ã®ã²ã¨ã¤ã ãã¬ããªã±ã¼ã·ã§ã³ã¯åºæ¬çã«éåæã§ãã¼ã¿ã®è¤è£½ãè¡ãä»çµã¿ã«ãªã£ã¦ããã®ã ããéåææ ã«ã©ããã¦ãéããããªãåé¡ãããããã®ã²ã¨ã¤ãä»åã®ãã¼ããé å»¶ã§ãããã¨ããã¨ãMySQLã®ã¬ããªã±ã¼ã·ã§ã³ã¯ããã«é å»¶ãçãã¦ãã¾ãããã«æãã¦ãã¾ãããç¥ããªããããã®ãããªãã¨ã¯ãªããã»ã¨ãã©ã®å ´åã¯å³åº§ã«ã¹ã¬ã¼ãã®æ´æ°ãè¡ãããã ãªãé å»¶ã¯çºçããã®ããã©ã®ããã«é å»¶ãèµ·ãã¦ãããã¨ã調ã¹ãã®ããã©ã®ããã«åé¿ããã®ãã¨ãããã¨ãæ¬ã¨ã³ããªã§ã¯è§£èª¬ãããããã¾ãé å»¶ã¨ä»ãåã£ã¦ãMySQLã®ã¬ããªã±ã¼ã·ã§ã³ãããå¿«é©ã«éç¨ãã¦ããããã°ã¨æãã ããããé å»¶ã¨ã¯ä½ãMySQLã®ã¬ããªã±ã¼ã·ã§ã³ã¯éåæã§è¡ããããããã¯æºåæã§ãåãã§ãããã¹ã¬ã¼ãã«ããã¦æ´æ°ãèµ·ããã®ã¯ãã¹ã¿ã¼ãããä¸ç¬é ãã¦ãã¾ããããã¯éåæã§ãããæ ã«éã
ãã®ã¨ã³ããªã¯ MySQL Casual Advent Calendar 2011 - MySQL Casual ã®10æ¥ç®ã®è¨äºã§ãã ããã°ãã¯ãtagomorisã§ãããã¨ãã§ããã¿ã´ã¢ãªã¹ã® s ã¯ãã¨ãã® s ã§ã(å®è©±)ãTwitterã§ #ãã¨ã ã¨ããããã·ã¥ã¿ã°ãæµãããã³ãã²ããã«ã³ãã£ã¨ãã¦ã¾ãã RubyããMySQLã«ç¹ãã¨ãã«ã©ãããã®ãã¨ã¨ãããã gem search -r mysql ã¨ãããã¨æãã¾ããããã¦å¤§éã«ããããåºã¦ãã¦ã©ãããã°ãããã ï¼ ã¨ããæ°åã«ãªãã¨æãã¾ããããããæ°åã«ãªã£ããã¨ãããã®ã§ãç¾ç¶ãç°¡åã«ã¾ã¨ãã¦ã¿ã¾ããã ruby-mysql æããã®å®çªã§ãããä½è 㯠id:tmtms ã®ã¨ã¿ãã¾ãã²ããããrubygemsã¨ã使ãããåãã Ruby/MySQL ã¨ããã©ã¤ãã©ãªåã§ç¥ããã¦ãã¾ãããGoogleã§æ¤ç´¢ããã¨ã
EnterpriseZineï¼ã¨ã³ã¿ã¼ãã©ã¤ãºã¸ã³ï¼ç·¨éé¨ã§ã¯ãæ å ±ã·ã¹ãã æ å½ãã»ãã¥ãªãã£æ å½ã®æ¹ã åãã«ãEnterpriseZine DayãSecurity Online DayãDataTechã¨ããã3ã¤ã®ã¤ãã³ããéå¬ãã¦ããã¾ããããããç·¨éé¨ç¬èªã®åãå£ã§ãæ¥çãã¬ã³ããææ°äºä¾ãç¶²ç¾ ãææ°ã®ååãç¥ããã¨ãã§ããå ´ã¨ãã¦ã好è©ãå¾ã¦ãã¾ãã
ã¿ã¤ãã«ã§å 容ãå ¨é¨æ¸ãã¦ãã¾ã£ãã SQL ãç´æ¥ mysql ã³ãã³ãããçºè¡ããå ´åãããã©ã«ãã§ã¯å±¥æ´ã $HOME/.mysql_history ã«æ®ãã¾ããæ¬¡åèµ·åããå ´åã«ãå±¥æ´ãããã®ã¼ããããã§ããããã¨ãã°ãæ¬çªãã¼ã¿ãã¼ã¹ã«ç¹ãã§æ´æ°ãåé¤ç³»ã®æä½ãå®è¡ããããããªå ´åãããã¯å±¥æ´ã«æ®ã£ããã®ãééã£ã¦åå®è¡ãã¦ãã¾ãã¨ã大å¤ãªæ²åãå¼ãèµ·ããå¯è½æ§ãããã¾ãã ã¨ããã¨ã§ã(ç·å¼µããªããæ¬çªã§) åé¤ SQL ãå®è¡ããå ´åãæä½æ¥ã§ .mysql_history ãã¨ãã£ã¿ã§ç·¨éãã¦æ¶ããããã¦ãã¾ããããããã§ããããã³ãã @n0ts ããããã ç´ã«åé¤ç³»SQLå©ããããã£ã¨ãæã«æ±ã 2011-09-01 15:34:46 via YoruFukurou ãã¹ããªèª¤çããªãããã«.mysql_historyãããæ¶ã 2011-09-01 15:36:22
MySQLã®ãã¥ã¼ãã³ã°ã«ããã¦é常ã«éè¦ã¨ãªãã¡ã¢ãª(ãããã¡)é¢é£ã®ãã©ã¡ã¼ã¿ã«ã¤ãã¦ã ãã¥ã¼ãã³ã°ã®ãã¤ã³ã DSASã®ã¨ããDBãµã¼ã(å®ã¡ã¢ãª4GB)ã®å®éã®è¨å®å¤ ãã¾ã¨ãã¦ã¿ã¾ãã ã¾ããå¿ è¦ã¡ã¢ãªã®ç·éã®è¨ç®ãéçå¤ãè¶ãã¦ãªãããã§ãã¯ãã¦ãããã¹ã¯ãªãããç´¹ä»ãã¾ãã æ¯éãåèã«ãã¦ã¿ã¦ãã ããï¼ ã¾ãæåã«æ³¨æç¹ãã ãããã¡ã«ã¯2ã¤ã®ã¿ã¤ããããã¾ãã ã°ãã¼ãã«ãããã¡ ã¹ã¬ãããããã¡ ã°ãã¼ãã«ãããã¡ã¯mysqldå ¨ä½ã§ãã®ãããã¡ã1ã¤ã ã確ä¿ããããã®ã§ã ããã«å¯¾ãã ã¹ã¬ãããããã¡ã¯ã¹ã¬ãã(ã³ãã¯ã·ã§ã³)ãã¨ã«ç¢ºä¿ããããã®ã§ãã ãã¥ã¼ãã³ã°ã®éã«ã¯ã°ãã¼ãã«/ã¹ã¬ããã®éããæèããããã«ãã¾ãããã ãªããªããã¹ã¬ãããããã¡ã«å¤ãã®ã¡ã¢ãªãå²ãå½ã¦ãã¨ãã³ãã¯ã·ã§ã³ãå¢ããã¨ããã«ã¢ãã¨ããéã«ã¡ã¢ãªä¸è¶³ã«ãªã£ã¦ãã¾ãããã§ãã in
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}