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%';
+---------------------
Ïà¹ØÎĵµ£º
񡜧
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Êý¾Ý¿â³öÏÖÂÒÂ룬mysqlÊý¾Ý¿â°²×°Ê±±àÂëÉèΪutf8£¬ÔÚÖ´ÐвåÈëÓï¾äµÄÇ°Ãæ£¨½ô°¤×ÅÖ´ÐÐÓï¾ä£©Ìí¼ÓתÂëÓï¾ä£ºString na="";
try{
&nbs ......
ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØÐ°²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬× ......
ÔÎĵØÖ·£º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× ......