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

MysqlµÄÈÕÖ¾ÀàÐÍÓëÉèÖá£


1.ÆÕͨlog
¼Ç¼ËùÓÐsql²Ù×÷£¬°üÀ¨select£¬showÓï¾ä¡£
ÉèÖÃ
ĬÈÏÊDz»´ò¿ª´Ëlog¡£
´ò¿ªÊ±¿ÉÒÔÖ¸¶¨Ä¿Â¼£¬²»Ö¸¶¨Ê±±£´æÔÚÊý¾Ý¿â¼Ŀ¼Ï¡£
[mysqld]
log = /data/logs/mysql.log   #´Ë·½Ê½ÎªÖ¸¶¨Îļþ
log = 1                              #´ËÎļþĬÈϱ£´æÔÚÊý¾Ý¿âĿ¼ÏÂ
log-output = TABLE,FILE      #¼ÓÉϴ˲ÎÊý¿ÉÒÔͬʱ°ÑÈÕÖ¾´æ´¢µ½Êý¾Ý±íÖУ¬mysql¿âÏ¡£Ò»°ãΪCVS¸ñʽ £¬µ±È»¿ÉÑ¡ÆäÖÐÒ»¸ö²ÎÊý¾ÍÐÐ
                                            #ĬÈÏÊÇFILEÖµ
2.´íÎóÈÕÖ¾
ÉèÖÃ
[mysqld_safe]  #´Ë½ÚµãÉèÖÃÁË»áÓÅÏȶÁ´Ë½Úµã£¬£Ûmysqld£Ý׎ڵã»áÎÞЧ£¬²»ÖªµÀΪɶ£¿
log-error=/data/logs/mysqld-err.log     #ͬÑù¿ÉÒÔÖ¸¶¨Ä¿Â¼£¬²»Ö¸¶¨Ä¬ÈÏ´æ´¢ÔÚÊý¾Ý¿âĿ¼Ï xxx.err
3.Âý²éÈÕÖ¾
ÉèÖà
[mysqld]
log_slow_queries = /data/logs/mysql-slow.log      #²»Ö¸¶¨Ä¬ÈÏΪ msyql-slow.log
long_query_time = 1                                        #´ËֵĬÈÏΪ10£¬×îСΪ1£¬5.1ÓиögoogleµÄ²¹¶¡¿ÉÒÔ׼ȷµÄºÁÃë¡£
 
log_queries_not_using_indexes = 1                      #ûʹÓÃË÷ÒýµÄ²éѯ£¬´æ´¢¹ý³Ì»áÈÏΪûʹÓÃË÷Òý¶ø¼Ç¼ÏÂÀ´£¬Ä¬ÈÏÊÇ0¡£
4.¶þ½øÖÆÈÕÖ¾
ÌØ±ð˵Ã÷£º ¶þ½øÖÆÈÕÖ¾ ²¢²»¼Ç¼select£¬showµÈ²»¸Ä±äÊý¾ÝµÄsqlÓï¾ä£¬ËüÖ÷Òª¹¦ÄÜÊÇÓÃÓÚ£ºÊý¾Ý»Ö¸´ÓëÊý¾Ý¸´ÖÆ¡£Æä´øÀ´µÄÐÔÄÜÏûºÄÔ¶²»ÈçÆÕͨ ÈÕÖ¾¸ß¡£Ä¬ÈÏÊDz»´ò¿ªµÄ¡£Èç¹ûʹÓÃÊÂÎñÐÍÊý¾ÝÒýÇæInnoDB»áÓÐ×Ô¼ºµÄ¶þ½øÖÆÈÕÖ¾¡£ÌرðÊÇ·þÎñÆ÷ʹÓÃÖ÷´Ó¼Ü¹¹Ê±£¬±ØÐ迪¶þ½øÖÆÈÕÖ¾£¬ÔÚ»úȺÇé¿öÏ¡£
 
ÉèÖÃ
[mysql]
log-bin = mysql-binlog        #Éú³É¸ñʽΪ mysql-binlog.00000X ÐÎʽ¡£ÕâÀﲻҪдÍêÕûĿ¼£¬Ð´¸öÃû×Ö¾ÍÐУ¬ÈÕÖ¾»á´æ´¢ÔÚÊý¾Ý¿âĿ¼Ï¡£
 
ʹÓàshow variables like '%log%';  ÃüÁî¿ÉÒԲ鿴µ±Ç°ÈÕÖ¾Ïà¹ØÉèÖá£
mysql> show variables like 'log%';
+---------------------


Ïà¹ØÎĵµ£º

mysqlÖÐcountº¯Êý×¢ÒâÊÂÏî

񡜧
CREATE TABLE `user` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
ÆäÖÐÓÐÊý¾ÝΪ£º
1 name1 123456
2&nbs ......

jspÁ¬½Ómysql¶ÔÊý¾Ý¿â½øÐвÙ×÷ÂÒÂëµÄ½â¾ö


Èç¹ûjsp²åÈëmysqlÊý¾Ý¿â³öÏÖÂÒÂ룬mysqlÊý¾Ý¿â°²×°Ê±±àÂëÉèΪutf8£¬ÔÚÖ´ÐвåÈëÓï¾äµÄÇ°Ãæ£¨½ô°¤×ÅÖ´ÐÐÓï¾ä£©Ìí¼ÓתÂëÓï¾ä£ºString na="";
                  try{
          &nbs ......

Hibernate²åÈëmysqlÊý¾Ý¿âÖÐÎÄÂÒÂë½â¾ö


ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØÐ°²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬× ......

MySQLÊý¾Ý¿â»·¾³Ê¹ÓÃÈ«¹ý³Ì

Ô­ÎĵØÖ·£ºhttp://blog.csdn.net/wenjava/archive/2009/06/11/4261299.aspx
ÔÚʹÓÃMySQL֮ǰ£¬ÐèÒª½¨Á¢Êý¾Ý¿âµÄ»·¾³À´´´½¨Êý¾Ý±í£¬Ê×ÏÈÎÒÃÇÐèÒª°²×°¸ÃÊý¾Ý¿â»·¾³£¬¼´MySQL¡£
1¡¢ÏÂÔØMySQL
MySQLµÄ¹Ù·½ÍøÕ¾ÊÇhttp://www.mysql.org/£¬Èçͼ2-9Ëùʾ£º
ͼ2-9  MySQL¹Ù·½ÍøÕ¾
µ±Ç°Îȶ¨°æ±¾Îª5.1£¬ÎÒÃÇÑ¡ÓÃMySQL 5.1.22× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ