mysqlÍøÕ¾ÇÄÈ»¸Ä°æ£¬sun½«³ÉΪһ´úÈ˵ļÇÒä¡£
½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔǰ¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔǰÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇÎ§ÈÆ×ÅÕâ¸ö×éºÏÕ¹¿ª£¬PostgresSQLÒ»Ö±Ìý˵£¬×Ô¼º´ÓÀ´Ã»ÓÐʹÓùý
¸Ð¾õİÉú£¬ÏÖÔÚûÓÐÒ»µã°²È«¸Ð¡£
mysqlËãµÃÉÏÊÇÒ»¸öΰ´óµÄ²úÆ·£¬ÏëÏëºÃ¼¸ÄêǰÔÚÊéµêÎÞÒâ¿´µ½Ò»±¾½éÉÜmysqlµÄÊ飬¸Ð¾õmysql¶àôÃìС£¬¶àô²Ý¸ù
¸ú΢Èí£¬Oracle£¬IBM DBÈçÀ×¹á¶ú£¬¹â»ÔÐÎÏó£¬×Ô¼º¸ù±¾²»Ï÷¿´Ò»ÑÛ£¬ºóÀ´£¬ËµÊµ»°ÎªÁËÉú»î£¬ÎªÁ˳Է¹Ö»ºÃ×öweb¿ª·¢£¬Ê¹ÓÃÁË
phpºÍmysql£¬¾¹ýǰ±²Ö¸µ¼ºÜ¿ì¾ÍÈëÃÅÁË£¬¼ÓµÄphpmyadmin¹¤¾ßʹÓÃmysqlÔ½À´Ô½Ë³ÊÖ¡£ÏÖÔÚÕæ²»¸ÒÐ¡ÇÆmysql¡£
ĿǰmysqlÒ²ÓжàÖÖ¼¯Èº½â¾ö·½°¸£¬ºÜ¶àÍøÂ繫˾¶¼ÊÇʹÓÃmysqlÁË¡£
mysqlµÄδÀ´£¬¿ÉÄÜ
Oracle¼ÌÐø°´ÕÕÏòÅ·Ã˱£Ö¤¿ªÔ´¼¸Ä꣬¼¸Äêºó¾Í¹ØÁË»òÕß°ÑmysqlÁ¹ÔÚÒ»±ß¡£Õâ¸öĿǰһ°ãÕý³£²Â²â¡£
Ò²ÓпÉÄÜmysql·Ö³öÀ´µÍ°æ±¾¼ÌÐøÃâ·Ñ£¬Ñ§redhatÒ»Ñù¡£»¹ÓÐÒ»ÖÖ¿ÉÄÜÊÇmysql°ëËÀ²»»î£¬¾ÍÊÇÓÐһЩºÜÐèÒªµÄ¹¦ÄÜÒªÊÕ·Ñ¡£
Ãâ·Ñʲô¶¼±ðÏë¡£
µ«Ô¸mysql»¹Äܱ£ÁôĿǰ״¿ö¡£
Ïà¹ØÎĵµ£º
Chapter 4. Indexes
Ë÷ÒýÓÐÖúÓÚMySQLÔÚºÆÈçÑ̺£µÄÊý¾ÝÖÐѸËÙÕÒµ½ºÍÈ¡µÃÕýÈ·µÄ¼Ç¼¡£
4.1 Indexing Basics
4.1.1 Index Concepts
Ë÷ÒýÊǰ´ÕÕijÖÖ¹æÔòÅÅÐòµÄ¡£Ë÷ÒýÒ²¾ÍÊÇÎþÉüһЩ¿Õ¼äºÍcpuµÄ¿ªÏúÀ´Ê¹ÄãµÄ²éѯÅܵøü¿ìµã¡£ÁíÍâÌáÐѵÄÊÇ£¬¶ÔÓÚMySQLÀ´½²£¬ÊõÓï“Key”ºÍ“Index”ÊÇ¿ÉÒÔ»¥ÏàÌæ»»µÄ¡£
4. ......
Ò»¡¢ ·ÖÇøµÄ¸ÅÄî
¶þ¡¢ ΪʲôʹÓ÷ÖÇø£¿£¨Óŵ㣩
Èý¡¢ ·ÖÇøÀàÐÍ
ËÄ¡¢ ×Ó·ÖÇø
Îå¡¢ ¶Ô·ÖÇø½øÐÐÐ޸ģ¨Ôö¼Ó¡¢É¾³ý¡¢·Ö½â¡¢ ......
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
È·È ......
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......