MySQLÅäÖÃÎļþmy.cnfÖÐÎİæ
À´×Ô: http://www.phpv.net/html/1666.html
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, ֻʹÓÃInnoDB, ACID, ÉÙÁ¿µÄÁ¬½Ó, ¶ÓÁиºÔØ´ó
#TYPE: SYSTEM
#END CONFIG INFO
#
# ´ËmysqlÅäÖÃÎļþÀý×ÓÕë¶Ô4GÄÚ´æ
# Ö÷ҪʹÓÃINNODB
#´¦Àí¸´ÔÓ¶ÓÁв¢ÇÒÁ¬½ÓÊýÁ¿½ÏÉÙµÄmysql·þÎñÆ÷
#
# ½«´ËÎļþ¸´ÖƵ½/etc/my.cnf ×÷Ϊȫ¾ÖÉèÖÃ,
# mysql-data-dir/my.cnf ×÷Ϊ·þÎñÆ÷Ö¸¶¨ÉèÖÃ
# (@localstatedir@ for this installation) »òÕß·ÅÈë
# ~/.my.cnf ×÷ΪÓû§ÉèÖÃ.
#
# ÔÚ´ËÅäÖÃÎļþÖÐ, Äã¿ÉÒÔʹÓÃËùÓгÌÐòÖ§³ÖµÄ³¤Ñ¡Ïî.
# Èç¹ûÏë»ñϤ³ÌÐòÖ§³ÖµÄËùÓÐÑ¡Ïî
# ÇëÔÚ³ÌÐòºó¼ÓÉÏ"--help"²ÎÊýÔËÐгÌÐò.
#
# ¹ØÓÚ¶ÀÁ¢Ñ¡Ïî¸ü¶àµÄϸ½ÚÐÅÏ¢¿ÉÒÔÔÚÊÖ²áÄÚÕÒµ½
#
#
# ÒÔÏÂÑ¡Ïî»á±»MySQL¿Í»§¶ËÓ¦ÓöÁÈ¡.
# ×¢ÒâÖ»ÓÐMySQL¸½´øµÄ¿Í»§¶ËÓ¦ÓóÌÐò±£Ö¤¿ÉÒÔ¶ÁÈ¡Õâ¶ÎÄÚÈÝ.
# Èç¹ûÄãÏëÄã×Ô¼ºµÄMySQLÓ¦ÓóÌÐò»ñÈ¡ÕâЩֵ
# ÐèÒªÔÚMySQL¿Í»§¶Ë¿â³õʼ»¯µÄʱºòÖ¸¶¨ÕâЩѡÏî
#
[client]
#password = [your_password]
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# *** Ó¦Óö¨ÖÆÑ¡Ïî ***
#
# MySQL ·þÎñ¶Ë
#
[mysqld]
# Ò»°ãÅäÖÃÑ¡Ïî
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# back_log ÊDzÙ×÷ϵͳÔÚ¼àÌý¶ÓÁÐÖÐËùÄܱ£³ÖµÄÁ¬½ÓÊý,
# ¶ÓÁб£´æÁËÔÚMySQLÁ¬½Ó¹ÜÀíÆ÷Ï̴߳¦Àí֮ǰµÄÁ¬½Ó.
# Èç¹ûÄãÓзdz£¸ßµÄÁ¬½ÓÂʲ¢ÇÒ³öÏÖ"connection refused" ±¨´í,
# Äã¾ÍÓ¦¸ÃÔö¼Ó´Ë´¦µÄÖµ.
# ¼ì²éÄãµÄ²Ù×÷ϵͳÎĵµÀ´»ñÈ¡Õâ¸ö±äÁ¿µÄ×î´óÖµ.
# Èç¹û½«back_logÉ趨µ½±ÈÄã²Ù×÷ϵͳÏÞÖÆ¸ü¸ßµÄÖµ,½«»áûÓÐЧ¹û
back_log = 50
# ²»ÔÚTCP/IP¶Ë¿ÚÉϽøÐмàÌý.
# Èç¹ûËùÓеĽø³Ì¶¼ÊÇÔÚͬһ̨·þÎñÆ÷Á¬½Óµ½±¾µØµÄmysqld,
# ÕâÑùÉèÖý«ÊÇÔöÇ¿°²È«µÄ·½·¨
# ËùÓÐmysqldµÄÁ¬½Ó¶¼ÊÇͨ¹ýUnix sockets »òÕßÃüÃû¹ÜµÀ½øÐеÄ.
# ×¢ÒâÔÚwindowsÏÂÈç¹ûûÓдò¿ªÃüÃû¹ÜµÀÑ¡Ïî¶øÖ»ÊÇÓôËÏî
# (ͨ¹ý "enable-named-pipe" Ñ¡Ïî) ½«»áµ¼ÖÂmysql·þÎñûÓÐÈκÎ×÷ÓÃ!
#skip-networking
# MySQL ·þÎñËùÔÊÐíµÄͬʱ»á»°ÊýµÄÉÏÏÞ
# ÆäÖÐÒ»¸öÁ¬½Ó½«±»SUPERȨÏÞ±£Áô×÷Ϊ¹ÜÀíÔ±µÇ¼.
# ¼´±ãÒѾ´ïµ½ÁËÁ¬½ÓÊýµÄÉÏÏÞ.
max_connections = 100
# ÿ¸ö¿Í»§¶ËÁ¬½Ó×î´óµÄ´íÎóÔÊÐíÊýÁ¿,Èç¹û´ïµ½ÁË´ËÏÞÖÆ.
# Õâ¸ö¿Í»§¶Ë½«»á±»MySQL·þÎñ×èÖ¹Ö±µ½Ö´ÐÐÁË"FLUSH HOSTS" »òÕß·þÎñÖØÆô
# ·Ç·¨µÄÃÜÂëÒÔ¼°ÆäËûÔÚÁ´½ÓʱµÄ´íÎó»áÔö¼Ó´ËÖµ.
# ²é¿´ "Aborted_connects" ״̬À´»ñȡȫ¾Ö¼ÆÊýÆ÷.
max
Ïà¹ØÎĵµ£º
mysql
·þÎñÆ÷ÖÐÓÐÁù¸ö¹Ø¼üλÖÃʹÓÃÁË×Ö·û¼¯µÄ¸ÅÄî,
ËûÃÇÊÇ£º
client
¡¢connection
¡¢database
¡¢results
¡¢server,
a
¡¢ÆäÖÐclient
Êǿͻ§¶ËʹÓõÄ×Ö·û¼¯£¬Ï൱ÓÚÍøÒ³ÖеÄ×Ö·û¼¯ÉèÖÃÈçÏÂ
<
meta http-equiv
=
"Content-Type"
content
=
"text/html;charset=utf ......
Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
¡¡¡ ......
×î½ü¹«Ë¾×¼±¸Ê¹ÓÃÏîÄ¿¹ÜÀíµÄÍøÕ¾DotProject£¬¹«Ë¾ËäÈ»²»´ó£¬µ«ÊÇÇ£Éæµ½µÄÒµÎñÒ²ÊǺܸ´Ôӵģ¬ËùÒÔÐèÒª¶¨Ê±È¥±£´æÊý¾Ý¿âµÄÐÅÏ¢ÒÔ·ÀÖ¹Êý¾Ý¿â±ÀÀ£»òÕ߯äËûµÄÔÒòÔì³ÉµÄÊý¾ÝËðʧ£¬ÕâÑù¾ÍÐèÒª½øÐÐÊý¾Ý¿âµÄ±¸·Ý¡£
DotProjectʹÓõÄÊÇMysqlÊý¾Ý¿â£¬±¸·ÝMysqlÊý¾Ý¿âµÄÒ»¸ö±È½ÏºÃµÄ·½·¨¾ÍÊÇ ......
¡¡¡¡(1)¡¢back_log£º
¡¡¡¡ÒªÇó MySQL ÄÜÓеÄÁ¬½ÓÊýÁ¿¡£µ±Ö÷ÒªMySQLÏß³ÌÔÚÒ»¸öºÜ¶Ìʱ¼äÄڵõ½·Ç³£¶àµÄÁ¬½ÓÇëÇó£¬Õâ¾ÍÆð×÷Óã¬È»ºóÖ÷Ï̻߳¨Ð©Ê±¼ä(¾¡¹ÜºÜ¶Ì)¼ì²éÁ¬½Ó²¢ÇÒÆô¶¯Ò»¸öÐÂÏ̡߳£
¡¡¡¡back_logÖµÖ¸³öÔÚMySQLÔÝʱֹͣ»Ø´ðÐÂÇëÇó֮ǰµÄ¶Ìʱ¼äÄÚ¶àÉÙ¸öÇëÇó¿ÉÒÔ±»´æÔÚ¶ÑÕ»ÖС£Ö»ÓÐÈç¹ûÆÚÍûÔÚÒ»¸ö¶Ìʱ¼äÄÚÓкܶàÁ¬½Ó£¬ ......