Amoeba for mysql 1.0.2 beta°æ±¾·¢²¼
ת×Ôhttp://amoeba.meidusa.com/wordpress/?p=24£¬Ò»¸öºÜºÃµÄ¹¤¾ß¡£¡£¡£¡£ÆÚ´ýÑо¿
ÐÞ¸´bugÁбí:
1¡¢ÐÞ¸´ÎÞ·¨½âÎöÅ׳öunknown statement£¨1.0.0ÐÂbug£©¡£½«ÎÞ·¨½âÎöµÃsqlĬÈÏÔÚdefaultPoolÖÐÖ´ÐÐ
2¡¢ÐÞ¸´union¹Ø¼ü×ÖÎÞ·¨½âÎöÎÊÌâ
3¡¢ÐÞ¸´º¯ÊýÇ°Ãæ! ÎÞ·¨½âÎöÎÊÌâ
4¡¢ÐÞ¸´order by ¡¢group by ºóÃæ´ø±í´ïʽµÃsql
ÏÂÔØµØÖ·: http://downloads.sourceforge.net/project/amoeba/Amoeba%20for%20mysql/amoeba-mysql-1.0.2-BETA.zip
Ïà¹ØÎĵµ£º
MYSQLÖг£ÓõÄÃüÁî´óÈ«
Ò»¡¢ Êý¾Ý¿â²Ù×÷µÄÃüÁî
1. ´´½¨Êý¾Ý¿â
Ø create database Name;
2. Ñ¡ÔñÊý¾Ý¿â
Ø use DatabaseName;
3. Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
Ø drop database Name;
4. ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
Ø drop ......
ÓÐʱºòΪÁË·½±ã£¬ÀûÓÃevent/triggerµ÷ÓÃϵͳÍⲿÃüÁ¿ÉÒòΪ°²È«ÎÊÌ⣬mysql×ÔÉí²¢Ã»ÓÐÌṩÏà¹ØÃüÁÕâÀïÌṩ¸öµ÷ÓÃϵͳÃüÁîµÄ×Ô¶¨Ò庯Êýmylab_sys_exec
soÎļþÏÂÔØ:mylab_sys_exec.so ( mysql5.1.34 ²âÊÔͨ¹ý)
¼ÓÔØ:
CREATE FUNCTION mylab_sys_exec RETURNS INTEGER SONAME "mylab_sys_exec.so";
ʹÓÃ:
SELECT myl ......
½øÈëcmd
===================
1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......
·/etc/my.cnfÊÇĬÈϵÄMySQLÅäÖÃÎļþ¡£Ó¦¸Ã¶ÔÕâ¸öÎļþÅäÖÃÐ޸ġ£ËüÊÇΪѧϰĿµÄ¶øÉè¼ÆµÄ¡£
·my-small.cnfÊÇΪÁËСÐÍÊý¾Ý¿â¶øÉè¼ÆµÄ¡£²»Ó¦¸Ã°ÑÕâ¸öÄ£ÐÍÓÃÓÚº¬ÓÐһЩ³£ÓÃÏîÄ¿µÄÊý¾Ý¿â¡£
·my-medium.cnfÊÇΪÖеȹæÄ£µÄÊý¾Ý¿â¶øÉè¼ÆµÄ¡£Èç¹ûÄãÕýÔÚÆóÒµÖÐʹÓÃRHEL,¿ÉÄÜ»á±ÈÕâ¸ö²Ù×÷ϵͳµÄ×îСRAMÐèÇó(25 ......
°´ÕÕ¹Ù·½ÌṩµÄ“UCenter 1.5.0 °²×°Í¼ÎĽ̳̔£¬ÎÒ¿ªÊ¼×°ÉÏphp5,mysql5,apache2.2£¬½á¹ûÔÚhttp://127.0.0.1/ucenter/install/index.phpʱÓöµ½ÁËÁîÈËÓôÃÆµÄÒ»¿Ì£¬
²é²é×ÊÁÏÒ»¿´£¬ÓкܶàÅóÓѶ¼Óöµ½ÀàËÆÇé¿ö£¬¶øÇÒÎʵÄÌû×Óµ½ÏÖÔÚ»¹Ã»Óиø»Ø£¬ÐÄÀíÄÉÃÆÑ½£¬ÎªÉ¶UcenterµÄÌṩ¹«Ë¾“¿µÊ¢´´Ï딵Ŀª·¢ÈËÔ±²» ......