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

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 root ÃÜÂëÍü¼Ç£¿£¿£¿£¿

½ñÌì¸øÐÂÀ´µÄÔ±¹¤Á¬½ÓÊý¾Ý¿â£¬ÐÞ¸ÄÁËÒ»ÏÂmysql rootÓû§µÄÃÜÂ룬ÎÒÏÂÔصÄÊÇ´ò°üµÄredMine£¬Ä¬ÈÏÃÜÂëÊÇ¿Õ£¬ÐÞ¸ÄÃÜÂëÖ®ºóÖØÆôredmine£¬phpAdmin Á´½Ó²»ÉÏmysqlÊý¾Ý¿âÁË£¬ÎÒÒ²ÐÞ¸ÄÁËphpadminÎļþ¼ÐϵÄconfig.inc.phpµÄÃÜÂ룬»¹ÊDz»ÐУ¬Ìáʾ#1130 - Host 'localhost' is not allowed to connect to this MySQL server´íÎó£¬Ã÷ ......

MySQL my.ini ÅäÖÃÎļþÏê½â


¡¡¡¡(1)¡¢back_log£º
¡¡¡¡ÒªÇó MySQL ÄÜÓеÄÁ¬½ÓÊýÁ¿¡£µ±Ö÷ÒªMySQLÏß³ÌÔÚÒ»¸öºÜ¶Ìʱ¼äÄڵõ½·Ç³£¶àµÄÁ¬½ÓÇëÇó£¬Õâ¾ÍÆð×÷Óã¬È»ºóÖ÷Ï̻߳¨Ð©Ê±¼ä(¾¡¹ÜºÜ¶Ì)¼ì²éÁ¬½Ó²¢ÇÒÆô¶¯Ò»¸öÐÂÏ̡߳£
¡¡¡¡back_logÖµÖ¸³öÔÚMySQLÔÝʱֹͣ»Ø´ðÐÂÇëÇó֮ǰµÄ¶Ìʱ¼äÄÚ¶àÉÙ¸öÇëÇó¿ÉÒÔ±»´æÔÚ¶ÑÕ»ÖС£Ö»ÓÐÈç¹ûÆÚÍûÔÚÒ»¸ö¶Ìʱ¼äÄÚÓкܶàÁ¬½Ó£¬ ......

MySql °²×°½Ì³Ì ʵ¼

×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾ÉÏ°²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËһЩÆæ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢° ......

mysql ×ÔÔöÁÐÏà¹ØÎÊÌâÕûÀí

MYSQL×ÔÔöÁÐ
1.¹Ø¼ü×Ö £ºauto_increment
2.×ÔÔöÓ÷¨
Àý:
CREATE TABLE animals ( id mediumint not null auto_increment,
name char(30) not null,
primary key (id));
3.¹ØÓÚ×ÔÔö
Q:Ôõô»ñµÃµ±Ç°µÄ×ÔÔöµÄ×î´óÖµ?
A:select @@identity
Q:Ôõô»ñµÃtableµÄµ±Ç°×ÔÔö×î´óÖµ?
A:select max(id) from table ......

mysql hibernateÖ÷¼üÅäÖÃ

  ÔÚ½üÆÚµÄÏîĿά»¤¹¤×÷ÖУ¬Ê±³£³öÏÖÖ÷¼üÖظ´µÄÒì³£¡£¾­¹ýһϵÁÐ×ÊÁϵIJéѯ֮ºó£¬·¢ÏÖʱhibernateÓ³ÉäÎļþÅäÖÃÎÊÌâ¡£
  mysqlÌṩÖ÷¼ü“×Ô¶¯ÔöÁ¿”µÄÅäÖã¬Ö¸¶¨¸ÃÀàÐ͵ÄÖ÷¼ü£¬mysqlÄܹ»×Ô¶¯¼ÓÒ»¡£
  ÔÚhibernateÓ³ÉäÎļþÖУ¬¹ØÓÚÖ÷¼üµÄÅäÖò»ÄÜÊÇ
<generator class="increment"&g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ