MySqlµÄ±íÀàÐÍ
create database sample;
create table 't_user' (
'id' int(11) not null auto_increment,
'name' varchar(100) not null default '',
primary key ('id')
) type=myisam;
Ñ¡ÏîÖ»ÔÚMySQL 3.23ºÍÒÔºó°æ±¾Öб»ÊµÏÖ¡£
²»Í¬µÄ±íÀàÐÍÊÇ£º
ISAM ÔÀ´µÄ±í´¦ÀíÆ÷
MyISAM ȫжþ½øÖÆ¿ÉÒÆÖ²µÄ±í´¦ÀíÆ÷
HEAP ÓÃÓڸñíµÄÊý¾Ý½ö½ö´æ´¢ÔÚÄÚ´æÖÐ
ûÓÐtype=myisamÓï¾äÒ²ÐУ¬ÒòΪ´Ó3.23°æ±¾ÒÔºó£¬Ä¬È϶¼ÊÇmyisamÀàÐÍ
Ïà¹ØÎĵµ£º
·þÎñÆ÷ÒµÎñÀàÐÍ¶Ô±È ÐÔÄÜÆ¿¾±
DB I/O´ÅÅÌ
ת·¢·þÎñÆ÷ Íø¿¨PPS
¶¯Ì¬WEBǰ̨ CPU
¾²Ì¬WEBǰ̨   ......
PHPеÄÁ¬½ÓMySQL·½·¨mysqli
1. ¿ªÆôPHPµÄAPIÖ§³Ö
£¨1£©Ê×ÏÈÐÞ¸ÄÄúµÄphp.iniµÄÅäÖÃÎļþ¡£
²éÕÒÏÂÃæµÄÓï¾ä£º
;extension=php_mysqli.dll
½«ÆäÐÞ¸ÄΪ£º
extension=php_mysqli.dll
......
µ¼³öÕû¸öÊý¾Ý¿â£ºmysqldump -uÓû§Ãû -pÃÜÂë ÐèÒªµ¼³öµÄÊý¾Ý¿âÃû > µ¼³öÎļþÃû.sql
ÆäËû²ÎÊý£º
-d ²»°üº¬Êý¾Ý£¬Ö»ÓÐÊý¾Ý¿â±í½á¹¹
--add-drop-table ÔÚÿ¸öcreateÓï¾ä֮ǰÔö¼ÓÒ»¸ödrop
--skip-opt ÿÌõ¼Ç¼ֻ¶ÔÓ¦Ò»¸öinsertÓï¾ä ......
http://dev.mysql.com/doc/refman/5.1/zh/index.html
(MySql 5.1 ÖÐÎIJο¼ÊÖ²á)
*------------------------------------------------------------------------------------------
show databases; ÏÔʾÊý¾Ý¿â
drop database Êý¾Ý¿âÃû;ɾ³ýÊý¾Ý¿â
set names 'utf8';ÉèÖÃÊý¾Ý¿â±àÂëΪutf-8
source x:\Êý¾Ý¿âÃû.sql;µ¼È ......