Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚÖØÐÂapacheºóÎÞ·¨ÔØÈëmysqlÀ©Õ¹½â¾ö°ì·¨

ÍøÉϺܶàдÔÚwindowsÏÂÎÞ·¨ÔØÈëmysqlÀ©Õ¹½â¾ö°ì·¨£¬µ«ÊÇÔÚliunxϵľÍû¼¸¸ö£¬ÒÔÏÂÊÇÔÚliunxϵĽâ¾ö°ì·¨
 ÖØ×°ºóphp²»»á×Ô¶¯°Ñmysql.soÀ©Õ¹¼ÓÉÏÈ¥,Òª
sudo vim /etc/php5/apache2/conf.d/pdo.ini
¼ÓÈëextension=mysql.so¾Í¿ÉÒÔÁË
ÆäʵҲ¿ÉÒÔÔÚ /etc/php5/apache2/php.iniÖмÓÈë
Ò²¿ÉÒÔÔÚ/etc/php5/apache2/conf.d/Öжà¼ÓÒ»¸ömysql.iniÀïÃæ¼ÓÈëextension=mysql.so


Ïà¹ØÎĵµ£º

MySQLµÄ²éѯÓÅ»¯ºÜɵ

select id from message where author_id in (select followed_id from Relation where follower_id=1) order by id desc   ºÍ ·Ö±ðÖ´ÐÐ $userlist = select followed_id from Relation where follower_id=1 ÔÙ select id from message where author_id in ($userlist) order by id desc   ¾¹È»ÓÐÁ½¸öÊýÁ ......

ʹÓÃÅú´¦ÀíºÍLOADµ¼ÈëÊý¾Ýµ½MySQLÊý¾Ý¿â

    ǰһƪÎÄÕÂÖÐ˵µ½ÁËLOADÃüÁÕâÀï¾ÍÀ´ÏêϸµÄ¸ø×Ô¼º£¬Ë³±ãÒ²¸ø´ó¼Ò½²½âÏÂLOADÃüÁîºÍÅú´¦ÀíµÄÊý¾Ýµ¼È빦ÄÜ¡£ÓõÄʱºò¸Ð¾õMySQLÓÃÆðÀ´ÕæµÄ±È½Ï×ÌÈ󡣡£¡£¡£
         Åú´¦Àíµ¼ÈëÎļþ£¬´ÓsqlÎļþµ¼ÈëÊý¾Ýµ½Êý¾Ý¿âÖÐ £¬Åú´¦ÀíÊÇÒ»Öַǽ»»¥Ê½ÔËÐÐmysql³ÌÐòµÄ·½·¨£¬ ......

Mysql ¶¨Òå×ֶεij¤¶È

 
Mysql Öж¨Òå×ֶκóµÄÊý¾ÝµÄÓô¦£º
int(1)ºÍint(10)ËÆºõûÓÐʲô²î±ð£¬¶¼±íʾ×î´óËĸö×Ö½ÚµÄÕûÐÍÊý¾Ý¡£
ÀýÈ綨ÒåÒ»¸öÃû×ÖΪtestµÄ±í:
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(1) NOT NULL,
  `ids` int(10) default NULL,
  `c` char(1) default NULL,
  `cs` ......

ͨ¹ýshow status À´ÓÅ»¯MySQLÊý¾Ý¿â

 
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
1, ²é¿´MySQL
·þÎñÆ÷ÅäÖÃÐÅÏ¢
mysql> show variables;
mysql> show variables;
2, ²é¿´MySQL·þÎñÆ÷ÔËÐеĸ÷ÖÖ״ֵ̬
mysql> show global status;
mysql> show global status;
3, Âý²éѯ
mysql> show variables like '%slow%';  
+--------------- ......

PenroseÁ¬½ÓMysql½â¾ö·½°¸

 ×î½üÒ»Ö±ÔÚ½øÐÐPenroseÁ¬½ÓMysqlµÄ³¢ÊÔ£¬¿É×ÜÊÇÌáʾÎÞ·¨Á¬½Óµ½Mysql£¬ÎÞÂÛÊǼì²é¶Ë¿ÚÊÇ·ñ¿ªÆô£¬ÉèÖÃMysqlÔ¶³Ì·ÃÎÊȨÏ޵ȶ¼²»¹ÜÓ㬺óÀ´ÔÚPenroseµÄ¹ÙÍøÕÒµ½Ò»¸ö½¨Á¢ÑùÀýÊý¾Ý¿â¼°ÉèÖÃÔ¶³ÌÁ¬½ÓµÄÎĵµ£¬Ã»Ïëµ½Ò»¾Ù³É¹¦£¬Í´¿ì°¡£¡
ÏÂÃæ¾Í°ÑÎĵµºÍ´ó¼Ò¹²Ïíһϣ¡£¨ÊÇÓ¢ÎÄ£¬´ó¼Ò¾Í´ÕºÏ×Å¿´Ï°ɣ¡ÒòΪ×î½ü¸ãPenroseÌ«ÀÛÁË£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ