MySQLµÄ ¸÷°æ±¾Çø±ð
µÚÒ»¸ö MySQL Community Server£¬Õâ¸ö²»ÒªÇ®£¡
µÚ¶þ¸ö MySQL Enterprise Õâ¸öÒªÌÍÇ®£¬²»¹ý¿ÉÒÔ´òµç»°×ÉѯÎÊÌ⣬Ҳ¾ÍÊǵ绰¼¼ÊõÖ§³Ö¡£
µÚÈý¸ö MySQL Cluster£¬Õâ¸öµ¥¶ÀÊÇû·¨Óõģ¬ÒªÔÚ1»ò2µÄ»ù´¡ÉÏÓᣵ±È»ÓÃÀ´Æ½ºâ¶ą̀Êý¾Ý¿âµÄ¡£
µÚËĸö MySQL Workbench£¬ÕâÊǸöºÃ¶«Î÷£¬ÓÃÀ´Éè¼ÆÊý¾Ý¿âµÄ¡£erwinÖªµÀÂð£¿Ëû¾ÍÊÇÕâ¸ö×÷Óá£
MySQL Community Server ÉçÇø°æ±¾ Ó¦¸Ã²»Ìṩ¹Ù·½¼¼ÊõÖ§³Ö
MySQL Enterprise Server MySQLÆóÒµ°æ·þÎñÆ÷
Èí¼þÊÇ×î¿É¿¿¡¢×ȫ¡¢¸üа汾µÄMySQLÆóÒµ¼¶·þÎñÆ÷Êý¾Ý¿â£¬ËüÄܹ»¸ßÐԼ۱ȵØÌṩµç×ÓÉÌÎñ¡¢Áª»úÊÂÎñ´¦Àí(OLTP)¡¢Ç§Õ×¹æÄ£µÄÊý¾Ý²Ö¿âÓ¦Óõȡ£ËüÖ§³ÖACIDÊÂÎñ´¦Àí£¬ÄÜÌṩÍêÕûµÄÌá½»¡¢»Ø¹ö¡¢±ÀÀ£»Ö¸´ºÍÐм¶Ëø¶¨¹¦ÄÜ¡£MySQLÊý¾Ý¿âÒòÆäÒ×ÓÃÐÔ¡¢¿ÉÀ©Õ¹ÐԺ͸ßÐÔÄܵÈÌص㣬³ÉΪȫÇò×îÁ÷ÐеĿªÔ´Êý¾Ý¿â¡£
MySQL Cluster 2̨ÒÔÉÏ mysql¼¯Èº·þÎñÆ÷
MySQL WorkbenchÓÐÁ½¸ö°æ±¾£º
MySQL Workbench Community Edition£¨ÓÖ½ÐMySQL Workbench OSS£¬ÉçÇø°æ£©ºÍMySQL Workbench Standard Edition£¨ÓÖ½ÐMySQL Workbench SE£¬ÉÌÒµ°æ£©¡£MySQL Workbench OSSÊÇÔÚGPLÖ¤ÊéÏ·¢²¼µÄ¿ªÔ´ÉçÇø°æ±¾£¬¶øMySQL Workbench SEÔòÊÇ°´ÄêÊշѵÄÉÌÒµ°æ±¾¡£Æ书ÄÜ·½ÃæµÄ²îÒì¼ûÏÂ±í£¨²»µÃ²»Ëµ£¬Êý¾Ý¿â/Ä£ÐÍͬ²½ÕâÒ»ÖØÒªµÄ¹¦Äܾ¹È»Ö»ÔÚÊշѵÄMySQL Workbench SEÖпÉÓ㬶øÔÚDBDesigner4ÖÐÕâÈ´ÊÇ»ù±¾¹¦ÄÜ£¬ÕâÖÖ“¼ÌÈΔ·½Ê½ÊµÔÚÈÃÈ˶ñÐÄ);
²¹³ä:
.tgzÊÇÔ´Âë°²×°£¬
glibcÊÇÖ¸C±àÒëÆ÷µÄ°æ±¾ÁË¡£
Essentials ¾«¼ò - È¥³ýÁËʵÀýÎļþ
"noinstall.zip”µÄÊÇ˵¸ÃѹËõ°üÀïÃæµÄÎļþÊDz»Óð²×°µÄ£¬Ö±½ÓʹÓá£
------------------------------------------------------------------------------------------------------------------------------
MySQL-3.23.39-1.i386.rpm £º°üº¬ÔËÐÐMySQL·þÎñÆ÷ËùÐèµÄÈ«²¿Îļþ£¬°üÀ¨¿Í»§»ú³ÌÐò
MySQL-3.23.39-1.src.rpm£º°üº¬MySQLµÄËùÓÐÔ´Âë
MySQL-bench-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ²âÊÔMySQLÐÔÄܵijÌÐò£¬ ÕâЩ²âÊÔ³ÌÐòÐèÒªÖ÷·¢ÐеµºÍPerl
MySQL-client-3.23.39-1.i386.rpm£ºÖ»°üº¬¿Í»§»ú³ÌÐò
MySQL-devel-3.23.39-1.i386.rpm“£º°üº¬±àÒë¿Í»§»ú³ÌÐòËùÐèÒªµÄ¿âºÍÍ·Îļþ
MySQL-shared-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ¿Í»§»ú³ÌÐòµÄ¹²Ïí¿â
¹ØÓÚϵͳ°æ±¾£º
Windows Essentials (x86) 6.0.7 £ºEssentials ¾«¼ò£¬¾«¼ò°æ - È¥³ýÁËʵÀýÎļþ
Windows ZIP/Setup.EXE (x86) 6.0.7£º×Ô¶¯°²×°°æ£¬ÏÂÔØÏÂ
Ïà¹ØÎĵµ£º
1Â¥
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëÇ°±ØÐëÃ»Ó ......
MySQL EVENT
À´Ô´£ºhttp://samyu.blog.51cto.com/344284/146011
event_scheduler:
The MySQL event scheduler is a thread that runs in the background looking for events to execute. It spends a lot of time sleeping -- and won't do anything unless the new global variable "event_scheduler" is set t ......
Õ⼸ÌìLinux·þÎñÆ÷ºÜÂý,ºÜ׿±ÕÒ²»µ½½â¾ö°ì·¨!ºó°Ù¶ÈÏà¹Ø×ÖÑÛ,²éÕÒµ½ÊÇMySQLµÄÎÊÌâ,
ÈçÏÂΪ½â¾ö·½°¸
:
Á¬½ÓMySQLËÙ¶ÈÂýµÄ½â¾ö·½·¨.
PHPÔ¶³ÌÁ¬½ÓMYSQLËÙ¶ÈÂý,ÓÐʱԶ³ÌÁ¬½Óµ½MYSQLÓÃʱ4-20Ãë²»µÈ,±¾µØÁ¬½ÓMYSQLÕý³£,³öÏÖÕâÖÖÎÊÌâµÄÖ÷ÒªÔÒòÊÇ,ĬÈÏ°²×°µÄ
MYSQL¿ªÆôÁËDNSµÄ·´Ïò½âÎö,ÔÚMY.CNF(UNIX»òLINUXϵͳÏÂ)»òMY.INI ......