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

Ë­ÖªµÀºÃÓÃÒ»µãµÄ mysql µÄ profiler

ÎÒ¿ÉÄÜÊÇÓùßÁË ms sql µÄÄǸö profiler, ÏÖÔÚÏ뿪ʼ¼à²âһϠmysql ¿Í»§¶ËµÄËùÓз¢¹ýÀ´µÄquery¡£ ÓÚÊÇÍøÉÏ¿ªÊ¼ÕÒÁËһЩ£¬
²»¹ý¼òÖ±¶¼Ì«²î¾¢ÁË£¬²»¹âÄÑÓ㬻ù±¾É϶¼²»ÄÜʵʱµÄ¼ì²âµ½¿â»§¶Ë·¢¹ýÀ´µÄÓï¾ä¡£ ÄÄλ֪²»ÖªµÀÓкÃÒ»µãµÄ£¬

°¥Ñ½£¬ÏÖÔÚ¶¼²»ÇóºÃ²»ºÃÓÃÁË£¬Ë­ÄÜ·ÖÏí¸öÄÜʵʱ¼à²âµ½¿Í»§¶Ë·¢¹ýÀ´µÄËùÓÐ Query µÄ¡£
5.11.2. ͨÓòéѯÈÕÖ¾
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#query-log

Õâ¸öÈÕÖ¾ÖÐÄã¿ÉÒÔ¿´µ½ËùÓб»Ìá½»µÄSQLÓï¾ä¡£

5.11.2. ͨÓòéѯÈÕÖ¾
Èç¹ûÄãÏëÒªÖªµÀmysqldÄÚ²¿·¢ÉúÁËʲô£¬ÄãÓ¦¸ÃÓÃ--log[=file_name]»ò-l [file_name]Ñ¡ÏîÆô¶¯Ëü¡£Èç¹ûûÓиø¶¨file_nameµÄÖµ£¬ ĬÈÏÃûÊÇhost_name.log¡£ËùÓÐÁ¬½ÓºÍÓï¾ä±»¼Ç¼µ½ÈÕÖ¾Îļþ¡£µ±Ä㻳ÒÉÔÚ¿Í»§¶Ë·¢ÉúÁË´íÎó²¢ÏëÈ·ÇеØÖªµÀ¸Ã¿Í»§¶Ë·¢Ë͸ømysqldµÄÓï¾äʱ£¬¸ÃÈÕÖ¾¿ÉÄܷdz£ÓÐÓá£
mysqld°´ÕÕËü½ÓÊÕµÄ˳Ðò¼Ç¼Óï¾äµ½²éѯÈÕÖ¾¡£Õâ¿ÉÄÜÓëÖ´ÐеÄ˳Ðò²»Í¬¡£ÕâÓë¸üÐÂÈÕÖ¾ºÍ¶þ½øÖÆÈÕÖ¾²»Í¬£¬ËüÃÇÔÚ²éѯִÐк󣬵«ÊÇÈκÎÒ»¸öËøÊÍ·Å֮ǰ¼Ç¼ÈÕÖ¾¡£(²éѯÈÕÖ¾»¹°üº¬ËùÓÐÓï¾ä£¬¶ø¶þ½øÖÆÈÕÖ¾²»°üº¬Ö»²éѯÊý¾ÝµÄÓï¾ä£©¡£

·þÎñÆ÷ÖØÐÂÆô¶¯ºÍÈÕ־ˢв»»á²úÉúеÄÒ»°ã²éѯÈÕÖ¾Îļþ(¾¡¹Üˢйرղ¢ÖØÐ´ò¿ªÒ»°ã²éѯÈÕÖ¾Îļþ)¡£ÔÚUnixÖУ¬Äã¿ÉÒÔͨ¹ýÏÂÃæµÄÃüÁîÖØÐÂÃüÃûÎļþ²¢´´½¨Ò»¸öÐÂÎļþ£º

shell> mv hostname.log hostname-old.log
shell> mysqladmin flush-logs
shell> cp hostname-old.log to-backup-directory
shell> rm hostname-old.log
ÔÚWindowsÖУ¬·þÎñÆ÷´ò¿ªÈÕÖ¾ÎļþÆÚ¼äÄã²»ÄÜÖØÐÂÃüÃûÈÕÖ¾Îļþ¡£Äã±ØÐëÏÈÍ£Ö¹·þÎñÆ÷È»ºóÖØÐÂÃüÃûÈÕÖ¾Îļþ¡£È»ºó£¬ÖØÆô·þÎñÆ÷À´´´½¨ÐµÄÈÕ


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

Çë½Ì£ºÇ¶Èëʽϵͳ°²×°MySQLÊý¾Ý¿âµÄÎÊÌâ

½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ