Ubuntu Server9 Mysql °²×°ÈçÏÂ
Òª°²×° MySQL£¬¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²×°Íê³É£¬MySQL ·þÎñÆ÷Ó¦¸Ã×Ô¶¯Æô¶¯¡£Äú¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÒÔÏÂÃüÁîÀ´¼ì²é MySQL ·þÎñÆ÷ÊÇ·ñÕýÔÚÔËÐУº
sudo netstat -tap | grep mysql
µ±ÄúÔËÐиÃÃüÁîʱ£¬Äú¿ÉÒÔ¿´µ½ÀàËÆÏÂÃæµÄÐУº
tcp 0 0 localhost.localdomain:mysql *:* LISTEN -
Èç¹û·þÎñÆ÷²»ÄÜÕý³£ÔËÐУ¬Äú¿ÉÒÔͨ¹ýÏÂÁÐÃüÁîÆô¶¯Ëü£º
sudo /etc/init.d/mysql restart
½øÈëmysql
mysql -uroot -p
(ÊäÈëmysqlµÄrootÃÜÂë)
ÅäÖà MySQL µÄ¹ÜÀíÔ±ÃÜÂ룺
sudo mysqladmin -u root password newpassword
Ïà¹ØÎĵµ£º
×î½ü£¬ÏîÄ¿ÖÐÓõ½mysql£¬ÓÉÓÚÊý¾ÝÁ¿·Ç³£´ó£¬Ã¿ÌìµÄÊý¾ÝÁ¿ÔÚ°ÙÍò¼¶£¬¿¼Âǵ½mysqlÊý¾Ý¿â´¦ÀíÐÔÄÜÒÔ¼°Êý¾ÝÊôÐÔ£¬¾ö¶¨±£´æ×ã¹»¶àµÄ²éѯÊý¾Ý¼´¿É£¬¾àµ±Ç°Ê±¼ä×î¾ÃÔ¶µÄÊý¾ÝÖ±½Óɾ³ý£¬ÎÞÐè½øÐб¸·Ý¡£
Í·ÄÔÖÐð³öµÄµÚÒ»¸öÏë·¨¾ÍÊÇ£¬ÄÜ·ñÀûÓÃmysqlÖеĴ¥·¢Æ÷£¬¼ì²éÊý¾Ý±í´óС£¬Èç¹û³¬¹ýÔ¤É賤¶È£¬Ôòɾ³ý²¿·ÖÊý¾Ý¡£
CREATE TRIGGER ......
The MySQL 5.0 Archive Storage Engine
http://dev.mysql.com/tech-resources/articles/storage-engine.html
Ìص㣺
1.²»Ö§³ÖÈκÎË÷Òý£¬µ«Ê¹Óòéѯ»º´æ
2.¸ù¾Ýmysql¹¤³ÌʦµÄ˵·¨£¬µ±±í´óС´ïµ½1.5Gʱ£¬±íɨÃèarchiveʱ¼äÉÙÓÚmyisam±í
3.Èç¹ûÄãÏë¸Ä±äÆäËû´æ´¢ÒýÇæµÄ±íµ½archiveÒýÇ棬ÇëÏÈdropÏÂÈκÎË÷Òý
4.myisam¿ÉÒÔÓ ......
´æ´¢ÒýÇæ Ö§³ÖË÷Òý myisam b-tree,r-tree,full-text,²»Ö§³Öhash innodb b-tree(clustered-index) merge b-tree,r-tree memory b-tree,hash archive ÎÞË÷Òý ......
ÓÐʱºòʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÃüÁîÐе¼È뱸·Ýʱ»á³öÏÖ“MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) server has gone away”´íÎó£¬Õâ¿ÉÄÜÊÇÒòΪÆäÖÐһЩinsertÓï¾äµÄ´óС³¬³öÁËMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)Ä¿Ç°ÉèÖõĻº³åÇø´óС¡£
½â¾ö°ì·¨
1.ʹÓÃphpmyadmin ±¸·ÝMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄʱºò£¬Ö»Ñ¡Ôñ
Êý¾Ý:
......
½üÈÕ£¬ÓÐÒ»¸öÏîÄ¿ÐèҪͨ¹ýOAϵͳ£¨Dominoƽ̨£©ÏòÒ»¸öMySQLÓ¦ÓòåÈë¼Ç¼£¬ÒòΪƽ̨ÊÇwindowsƽ̨£¬ËùÒÔ²ÉÓÃÁËODBCÁ¬½Ó·½Ê½£¬ÔÚOA·þÎñÆ÷ÉÏ°²×°ÁËMyODBC-3.51.11-1Çý¶¯£¬ÅäÖÃÁËODBCÇý¶¯Êý¾ÝÔ´Ö®ºó£¬²åÈë¼Ç¼³É¹¦£¬µ«²»ÂÛÊDzåÈëÖÐÎÄÄÚÈÝ£¬»¹ÊÇ´ÓMySQLÖжÁÈ¡ÖÐÎÄÄÚÈÝ£¬¶¼ÊÇÂÒÂ룬ÔÚÍøÉϲéÔÄÁ˸÷ÖÖ×ÊÁÏ£¬³õ²½ ......