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

¶ÔmysqlµÄorder by¼°limitÓÅ»¯ÒªÊÊÊý¾ÝÇé¿ö¶ø¶¨

ÒÔÏÂÕâÆªÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹ØµÄÁÐÌõ¼þ¹ýÂËËùµÃµ½µÄ½á¹û¼¯ºÜ´óʱ£¬ÓÃ×Ó²éѯ¸ü¿ì
ÐÎʽÈ磺select * from table where column in (select column from table where column=?) order by column_id limit m,n
£¨2£©µ±¹ýÂËËùµÃµ½µÄ½á¹û¼¯ºÜСʱ£¬²»ÓÃ×Ó²éѯ¸ü¿ì(ÒòΪÈç¹ûÓÃ×Ó²éѯ£¬ÏȽøÐÐÅÅÐò£¬¿ÉÄÜÅÅÔÚÇ°ÃæµÄnÌõ¼Ç¼ȫ²»ÊÇÂú×ã×Ó²éѯÌõ¼þµÄ£¬Òò´Ë¿ÉÄÜɨÃè¸ü¶àµÄÐУ»µ«µ±¹ýÂ˵Ľá¹û¼¯ºÜ´óʱ£¬ÅÅÔÚÇ°ÃæµÄÂú×ãÌõ¼þµÄÐгöÏֵĻúÂÊÒ²´ó£¬Òò´Ë¿ÉÄÜɨÃè¸üÉÙµÄÐУ©
ÐÎʽÈ磺select * from table where column=? order by column_id limit m,n


Ïà¹ØÎĵµ£º

mysql source µ¼Èëµ¼³öÊý¾ÝΪÂÒÂë

Ò»¡¢µ¼ÈëÊý¾Ý
1¡¢È·¶¨
Êý¾Ý¿âĬÈϱàÂ룬±ÈÈç±àÂë
Ϊgbk,½«¶ÁÈë;¾¶±àÂëͬÑùÉèΪgbk£¬ÃüÁîΪ£º
           set names gbk;
2¡¢source
d:/20080613.sql µ¼ÈëÊý¾Ý¡£ÑéÖ¤
Êý¾Ý¿â
ÖеÄÊý¾ÝÊÇ·ñ´æÔÚÂÒÂë¡£
3¡¢Èç¹ûÈÔÈ»´æÔÚÂÒÂëÎÊÌ⣬Õâʱºò¾ÍÒª¿¼ÂǸı䵼ÈëÎļþµÄ±à ......

mysqlѧϰ1 ¸ÅÊö¼°ÌØÕ÷

·   ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ 
o  ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
·         Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......

Linux ÏÂMySQL NDBÅäÖÃ

A) Shutdown management node and data node
devmysql3# ndb_mgm -e shutdown
devmysql4# ndb_mgm -e shutdown
B) Shutdown MySQL proccess
devmysql3# mysqladmin shutdown
devmysql4# mysqladmin shutdown
devmysql3 ip: 10.130.30.217
devmysql4 ip: 10.130.30.218
rpm -ivh MySQL-Cluster-gpl-storage ......

linux,nginx,mysql,php°²×°±¸Íü

niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......

MySQL NDB 6.3.20¼¯Èº°²×°

 
MySQL¼¯ÈºÊÇÒ»ÖÖÔÚÎÞ¹²Ïí¼Ü¹¹ÏµÍ³ÀïÓ¦ÓÃÄÚ´æÊý¾Ý¿â¼¯ÈºµÄ¼¼Êõ¡£ÕâÖÖÎÞ¹²ÏíµÄ¼Ü¹¹¿ÉÒÔʹµÃϵͳʹÓ÷dz£±ãÒ˵IJ¢ÇÒÊÇ×îСÅäÖõÄÓ²¼þ¡£
MySQL¼¯ÈºÊÇÒ»ÖÖ·Ö²¼Ê½Éè¼Æ£¬Ä¿±êÊÇÒª´ïµ½Ã»ÓÐÈκε¥µã¹ÊÕϵ㡣Òò´Ë£¬ÈκÎ×é³É²¿·Ö¶¼Ó¦¸ÃÓµÓÐ×Ô¼ºµÄÄÚ´æºÍ´ÅÅÌ¡£Èκι²Ïí´æ´¢·½°¸ÈçÍøÂç¹²Ïí£¬ÍøÂçÎļþϵͳºÍSANÉ豸ÊDz»ÍƼö»ò²»Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ