¡¾×ª¡¿MySQLÓÅ»¯¼òÃ÷Ö¸ÄÏ
Ò»¡¢ÔÚ±àÒëʱÓÅ»¯MySQL
Èç¹ûÄã´ÓÔ´´úÂë·Ö·¢°²×°MySQL£¬Òª×¢Ò⣬±àÒë¹ý³Ì¶ÔÒÔºóµÄÄ¿±ê³ÌÐòÐÔÄÜÓÐÖØÒªµÄÓ°Ï죬²»Í¬µÄ±àÒ뷽ʽ¿ÉÄܵõ½ÀàËÆµÄÄ¿±êÎļþ£¬µ«ÐÔÄÜ¿ÉÄÜÏà²îºÜ´ó£¬Òò´Ë£¬ÔÚ±àÒë°²×°MySQLÊÊÓ¦×Ðϸ¸ù¾ÝÄãµÄÓ¦ÓÃÀàÐÍÑ¡Ôñ×î¿ÉÄܺõıàÒëÑ¡Ïî¡£ÕâÖÖ¶¨ÖƵÄMySQL¿ÉÒÔΪÄãµÄÓ¦ÓÃÌṩ×î¼ÑÐÔÄÜ¡£
¼¼ÇÉ£ºÑ¡ÓýϺõıàÒëÆ÷ºÍ½ÏºÃµÄ±àÒëÆ÷Ñ¡ÏÕâÑùÓ¦ÓÿÉÌá¸ßÐÔÄÜ10-30%¡££¨MySQLÎĵµÈçÊÇ˵£©
1.1¡¢Ê¹ÓÃpgcc£¨Pentium GCC)±àÒëÆ÷
¸Ã±àÒëÆ÷£¨http://www.goof.com/pcg/£©Õë¶ÔÔËÐÐÔÚ±¼ÌÚ´¦ÀíÆ÷ϵͳÉϵijÌÐò½øÐÐÓÅ»¯£¬ÓÃpgcc±àÒëMySQLÔ´´úÂ룬×ÜÌåÐÔÄÜ¿ÉÌá¸ß10%¡£µ±È»Èç¹ûÄãµÄ·þÎñÆ÷²»ÊÇÓñ¼ÌÚ´¦ÀíÆ÷£¬¾Í²»±ØÓÃËüÁË£¬ÒòΪËüÊÇרΪ±¼ÌÚϵͳÉè¼ÆµÄ¡£
1.2¡¢½öʹÓÃÄãÏëʹÓõÄ×Ö·û¼¯±àÒëMySQL
MySQLĿǰÌṩ¶à´ï24ÖÖ²»Í¬µÄ×Ö·û¼¯£¬ÎªÈ«ÇòÓû§ÒÔËûÃÇ×Ô¼ºµÄÓïÑÔ²åÈë»ò²é¿´±íÖеÄÊý¾Ý¡£È´Ê¡Çé¿öÏ£¬MySQL°²×°ËùÓÐÕßÕâЩ×Ö·û¼¯£¬ÈÈÈ»¶ø£¬×îºÃµÄÑ¡ÔñÊÇָѡÔñÒ»ÖÖÄãÐèÒªµÄ¡£È磬½ûÖ¹³ýLatin1×Ö·û¼¯ÒÔÍâµÄËùÓÐÆäËü×Ö·û¼¯£º
--------------------------------------------------------------------------------
%>./configure -with-extra-charsets=none [--other-configuration-options]
--------------------------------------------------------------------------------
1.3¡¢½«mysqld±àÒë³É¾²Ì¬Ö´ÐÐÎļþ
½«mysqld±àÒë³É¾²Ì¬Ö´ÐÐÎļþ¶øÎÞÐè¹²Ïí¿âÒ²ÄÜ»ñµÃ¸üºÃµÄÐÔÄÜ¡£Í¨¹ýÔÚÅäÖÃʱָ¶¨ÏÂÁÐÑ¡Ï¿É¾²Ì¬±àÒëmysqld¡£
--------------------------------------------------------------------------------
%>./configure -with-mysqld-ldflags=-all-static [--other-configuration-options]
--------------------------------------------------------------------------------
1.4¡¢ÅäÖÃÑù±¾
ÏÂÁÐÅäÖÃÃüÁî³£ÓÃÓÚÌá¸ßÐÔÄÜ£º
--------------------------------------------------------------------------------
%>CFLAGS="-O6 -mpentiumpro -fomit-frame-pointer" CXX=gcc CXXFLAGS="-O6 -mpentiumpro -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local --enable-assembler --with-mysqld-ldflags=-all-static --disable
Ïà¹ØÎĵµ£º
½ñÌì´î½¨mysqlÊý¾Ý¿â,Á¬½ÓÁ˰ëÌì,¶¼Ìáʾ10061´íÎó,ÒÔΪÃÜÂë³öÁËÎÊÌâÊÔÁ˰ëÌì,ѹ¸ùÁ¬·þÎñ¶¼Á¬½Ó²»ÉÏ,æ»îÁ˰ë¸ö¶àСʱ,²Å·¢ÏÖÊÇϵͳ²¹¶¡´òÁËÖ®ºó³öÏÖµÄÎÊÌâ(kb967723)
ÓÚÊÇÍøÉÏÕÒÁËÒ»ÏÂ×ÊÁÏ
×î½üÒ»¸ö¿Í»§·þÎñÆ÷µÄMYSQLƵ·±ÌáʾÁ¬½Ó²»ÉÏ£¬ÐÞ¸ÄÁËMYSQLµÄ×î´óÁ¬½ÓÊý»¹ÊÇÕâÑù£¬ÓÚÊÇ¿ªÊ¼ÎÊÍòÄܵÄËÑË÷ÒýÇæ´óÈË£¡ÖÕÓÚÔÚ΢ÈíÕÒµ½ÁË ......
ͨ¹ýÎļþÃû²éÕÒ·¨£º
Õâ¸ö·½·¨ËµÆðÀ´¾ÍºÍÔÚWINDOWSϲéÕÒÎļþÒ»ÑùÈÝÒ×Àí½âÁË¡£Èç¹ûÄã°ÑÕâ¸öÎļþ·ÅÔÚµ¥¸öµÄÎļþ¼Ð
ÀïÃæ£¬Ö»ÒªÊ¹Óó£¼ûµÄ“ls"ÃüÁî¾ÍÄÜ·½±ãµÄ²éÕÒ³öÀ´£¬ÄÇôʹÓÓfind”ÃüÁîÀ´²éÕÒËü¾Í²»Äܸø
ÄãÁôÏÂÉî¿ÌµÄÓ¡Ï󣬱Ͼ¹“find”ÃüÁîµÄÇ¿´ó¹¦Äܲ»Ö¹Õâ¸ö¡£Èç¹ûÖªµÀÁËij¸öÎļþµÄÎÄ ......
µÇ½ÒÔºóÔËÐÐÒÔÏÂÃüÁ¸øÓèÔ¶³Ì·ÃÎʿͻ§¶ËȨÏÞ..
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
remote±íʾÓû§Ãû.
'172.16.21.39' Ô¶³ÌipµØÖ·
password±íʾԶ³ÌµÇ½ÃÜÂë.
ĬÈÏ×´¿öÏ£¬³öÓÚ°²È«¿¼ÂÇ£¬mysqlÊý¾Ý¿âÆÁ±ÎÁËÔ¶³Ì·ÃÎʹ¦ÄÜ¡£ È»¶øÔÚÐí¶à×´¿öÏ£¬ÄãÐèÒªÔÚ¼Ò
»òÕß´Óweb³ÌÐòÈ¥·ÃÎÊ ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
try
{
string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
& ......