Linuxϰ²×°MySQLÊý¾Ý¿â¹¥ÂÔ
1.MySQL¼ò½é
MySQLÊÇÒ»¸ö¹ã·ºÊ¹ÓõĽṹ»¯²éѯÓïÑÔ£¨SQL£©Êý¾Ý¿â·þÎñÆ÷¡£ºÍÆäËûSQL·þÎñÆ÷Ò»Ñù£¬MySQLÌṩÁË·ÃÎʺ͹ÜÀíSQLÊý¾Ý¿âµÄ·½·¨£¬µ«ÊÇ£¬MySQLͬʱҲÌṩÁË´´½¨Êý¾Ý¿â½á¹¹ÒÔ¼°ÔÚÕâЩ½á¹¹ÖÐÌí¼Ó¡¢Ð޸ĺÍɾ³ýÕâЩ½á¹¹µÄ¹¤¾ß¡£
MySQLÊý¾Ý¿âÏà¹ØµÄÈí¼þ°üÖ÷ÒªÓÐÒÔϼ¸ÖÖ£º
£¨1£©mysql£ºÕâ¸öÈí¼þ°üÖаüº¬ÁËÐí¶àMySQL¿Í»§¶Ë³ÌÐò£¨ÔÚ/usr/binÖУ©¡¢¼¸¸ö¿Í»§¶Ë¹²Ïí¿â¡¢Ä¬ÈϵÄMySQLÅäÖÃÎļþ£¨/etc/my.conf£©¡¢Èô¸Éʾ·¶ÅäÖÃÎļþ¡¢Ö§³Ö¼¸ÖÖ²»Í¬ÓïÑÔµÄÎļþºÍÎĵµ£¨/usr/share/mysql£©¡£
£¨2£©mysql-server£ºÕâ¸öÈí¼þ°ü°üº¬MySQL·þÎñÆ÷ÊØ»¤½ø³Ì£¨mysqld£©ºÍmysqldÆô¶¯½Å±¾£¨/etc/init.d/mysqld£©¡£¸ÃÈí¼þ°ü»áͬʱ´´½¨ÉèÖÃMySQLÊý¾Ý¿âËùÐèµÄ¸÷ÖÖ¹ÜÀíÎļþºÍĿ¼¡£
£¨3£©mysql-devel£ºÕâ¸öÈí¼þ°ü°üº¬Óпª·¢MySQL³ÌÐòËùÐèµÄ¿âÎļþºÍÍ·Îļþ¡£
£¨4£©php-mysql£ºÕâ¸öÈí¼þ°ü°üº¬Ò»¸ö¹²Ïí¿â£¬ÔÊÐíPHP³ÌÐò·ÃÎÊmysqlÊý¾Ý¿â£¬ËüÔÊÐíÓû§ÔÚÍøÒ³ÖÐÌí¼Ó¿É·ÃÎÊMySQLÊý¾Ý¿âµÄPHP½Å±¾¡£
°²×°MySQLÊý¾Ý¿â£¬ÖÁÉÙÐèÒª°²×°mysql°üºÍmysql-server°ü£¬·½±ãÆð¼û£¬¿É²ÉÓÃÃüÁװģʽ¡£
Fedora Linux²Ù×÷ϵͳÖпÉʹÓÃÈçϵÄÃüÁ
yum install mysql
yum install mysql-server
Ubuntu²Ù×÷ϵͳÖпÉʹÓÃÈçÏÂÃüÁ
sudo apt-get install mysql
sudo apt-get install mysql-server
2. ÏÂÔØMySQLµÄ°²×°Îļþ£¬ÊÖ¶¯°²×°£¨RPM°ü°²×°Ä£Ê½£©
°²×°MySQLÖÁÉÙÐèÒª°²×°ÏÂÃæÁ½¸öÎļþ£º
MySQL-server-5.0.9-0.i386.rpm
MySQL-client-5.0.9-0.i386.rpm
ÏÂÔØµØÖ·Îª£ºhttp://dev.mysql.com/downloads/mysql/5.0.htm£¬´ò¿ª´ËÍøÒ³£¬ÏÂÀÍøÒ³ÕÒµ½“Linux x86 RPM downloads”ÏÕÒµ½“Server”ºÍ“Client programs”ÏÏÂÔØÐèÒªµÄÉÏÊöÁ½¸örpmÎļþ¡£
3. ÊÖ¶¯°²×°MySQL
rpmÎļþÊÇRed Hat¹«Ë¾¿ª·¢µÄÈí¼þ°²×°°ü£¬rpm¿ÉÈÃLinuxÔÚ°²×°Èí¼þ°üʱÃâ³ýÐí¶à¸´ÔÓµÄÊÖÐø¡£¸ÃÃüÁîÔÚ°²×°Ê±³£ÓõIJÎÊýÊÇ –ivh ,ÆäÖÐi±íʾ½«°²×°Ö¸¶¨µÄrmpÈí¼þ°ü£¬V±íʾ°²×°Ê±µÄÏêϸÐÅÏ¢£¬h
Ïà¹ØÎĵµ£º
Linux Socket ѧϰ£¨Ê®£©
ÔÚÌ×½Ó¿ÚÉÏʹÓñê×¼I/O
ÔÚÇ°ÃæÕ½ڵÄÀý×Ó´úÂëÖÐÎÒÃÇÒѾʹÓÃÁËread(2)»òÊÇwrite(2)ϵͳµ÷ÓÃÔÚÌ×½Ó¿ÚÉÏÖ´ÐжÁÈ¡ºÍдÈë²Ù×÷¡£Õâ¸ö¹æÔòµÄÒ»¸öÀýÍâ¾ÍÊÇrecvfrom(2)ºÍsendto(2)º¯Êý£¬ÕâÁ½¸öº¯ÊýÓÃÀ´¶ÁдÊý¾Ý±¨¡£È»¶ø£¬Ê¹ÓÃreadºÍwritteº¯Êýµ÷ÓÃÈ´ÓÐһЩ³ÌÐòÉϵÄȱµã¡£
ÕâÒ»ÕÂÎÒÃǽ«»áÌÖÂÛÒÔÏÂÄÚÈÝ ......
½ñÌìÔÚÔËÐÐsphinxµÄʱºò£¬Ìáʾ˵
./searchd: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
ÎÒ±àÒë°²×°µÄʱºòÃ÷Ã÷ÓÐÖ¸¶¨mysqlµÄlib¿â°¡£¬ÉÏÍø²éµ½ÊÇÒòΪmysqlµÄlib²»ÔÚϵͳµÄlib·¾¶ÖУ¬½â¾ö°ì·¨ÈçÏ£º
ÔÚ/etc/ld.so.confÏÂÃæ¼ÓÒ»ÐÐ/usr/loc ......
Ò»¡¢ÓÃvi filename´ò¿ªÎļþ£º
¶þ¡¢»ù±¾ÖªÊ¶£ºvi ¿ÉÒÔ·ÖÈýÖÖ״̬£ºÃüÁîģʽ£¨command£©¡¢²åÈëģʽ£¨insert£©ºÍÄ©ÐÐģʽ£¨last line£©
£¨1£©ÃüÁîģʽ£º´ò¿ªÎļþʱĬÈÏÊÇÃüÁîģʽ£¬¿ØÖÆÆÁÄ»¹â±êµÄÒÆ¶¯¡¢×Ö·û¡¢×Ö»òÕßÐеÄɾ³ý£¬Òƶ¯ &nb ......
ÓÉÓÚҪʹÓõ½log4cppµÄ¿â£¬¶ølog4cµÄ×ÊÁÏÊǷdz£µÄÉÙ£¬Ò²ÀÁµÃÈ¥Ñо¿ËüµÄÓ÷¨£¬ÓÚÊǾ;ö¶¨ÊÔÊÔ»ìºÏ±à³ÌÕßÍæÒâ¡£
Ê×ÏÈÏÈÒýÓÃÏÂC++ËüµÄfather: StroustrupµÄһƪÎÄÕ¡¶C++ Style and Technique FAQ¡·£¨http://www2.research.att.com/~bs/bs_faq2.html£©ÀïµÄһС¸öÆ ......
fg¡¢bg¡¢jobs¡¢&¡¢ctrl + z¶¼ÊǸúϵͳÈÎÎñÓйصģ¬ËäÈ»ÏÖÔÚ»ù±¾Éϲ»ÔõôÐèÒªÓõ½ÕâЩÃüÁµ«Ñ§»áÁËÒ²ÊǺÜʵÓõÄ
Ò»¡£& ×î¾³£±»Óõ½
Õâ¸öÓÃÔÚÒ»¸öÃüÁîµÄ×îºó£¬¿ÉÒÔ°ÑÕâ¸öÃüÁî·Åµ½ºǫִ́ÐÐ
¶þ¡£ctrl + z
¿ÉÒÔ½«Ò»¸öÕýÔÚǰִ̨ÐеÄÃüÁî·Åµ½ºǫ́£¬²¢ÇÒÔÝÍ£
Èý¡£jobs
²é¿´µ±Ç°ÓжàÉÙÔÚºǫ́ÔËÐеÄÃüÁî
ËÄ¡£fg
......