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

mysqlÖеÄSQL·ÖÎö¹¤¾ß

Another Look at MySQL 5.1's SQL Diagnostic Tools
http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html Êý¾Ý¿âµÄÐÔÄܾö¶¨ÒòËØ£º
£¨1£©Êý¾Ý¿âµÄÉè¼Æ
£¨2£©SQL´úÂë ¿ÉÒÔÓÃÒÔϼ¸ÖÖ·½·¨À´½â¾öһЩÐÔÄÜÎÊÌ⣺
£¨1£©Ë÷Òý
£¨2£©Ë®Æ½·ÖÇø
£¨3£©ÁÐÊÊÓ¦µÄ±í
column-oriented dbms£¨http://en.wikipedia.org/wiki/Column-oriented_DBMS#Implementations£©
Ò»°ã±íÊý¾ÝÎļþÊǰ´Ðд洢£¬È磺ijһ±í±»¶¨ÒåΪid,name,desc£¬Ôò°´Ðд洢Ϊ£º
1,name1,desc1;2,name2,desc2;¡­
¶ø°´Áд洢Ϊ£º
1,2;name1,name2;desc1,desc2;¡­ Êý¾Ý¿âÐÔÄÜ·ÖÎö·½·¨£º
Bottleneck analysis – what is my database, user community, and SQL code waiting on?
Workload analysis – who's logged on and what work are they performing?
Ratio analysis – what do rules-of-thumb statistics say about my performance? Ïà¹ØµÄ·ÖÎöÃüÁ
mysqlÈÕÖ¾·ÖÎöÂý²éѯÈÕÖ¾£¬Ò»°ãÈÕÖ¾£¬´íÎóÈÕÖ¾
ÈÕÖ¾¿ÉÒÔ´æÔÚ±íÖУ¬Ò²¿É´æÔÚÊý¾ÝÎļþÖÐ
Ö¸¶¨ÈÕÖ¾´æÔÚÄÄ£ºset global log_output='table'(CSV (comma separated value) engine) or 'file'
ÈÕÖ¾´æµÄ±í£ºmysql.general_log£¨Ò»°ãÈÕÖ¾£©ºÍmysql.slow_log£¨Âý²éѯÈÕÖ¾£©
Ö¸¶¨ÈÕÖ¾´æµÄÎļþ£º
SET GLOBAL general_log_file=¡¯/tmp/general.log¡¯;
SET GLOBAL slow_query_log_file=¡¯/tmp/slow.log¡¯;
¿ªÆô/¹Ø±ÕÂý²éѯÈÕÖ¾£ºset global slow_query_log=1/0;
Âý²éѯµÄthreshold£ºset global long_query_time=1;£¨Ã룩
¿ªÆô/¹Ø±Õ²éѯÈÕÖ¾£ºset global general_log=1/0;
¿ªÆô²éѯprofile£ºset profiling=1;
ÏÔʾËùÓÐprofile£ºshow profiles\G


Ïà¹ØÎĵµ£º

DataGridView¿Ø¼þÓëSQL¶à±íÁ¬½Ó~£¡

Ò»¸ö×î¼òµ¥µÄ´úÂë¶Î£º
string sql = string.Format("select Consult_Info.CName,Consult_Record.RTime,Consult_Record.RContent,Emp_Info.EName,CMode.Mode from Consult_Info inner join Consult_Record on(Consult_Info.CID = Consult_Record.CID) inner join Emp_Info on(Emp_Info.EID=Consult_Record.EID) inner join ......

Óà PHP µ÷Óà MySQL ´æ´¢¹ý³Ì

    MySQL 5.0 ÒÔÉÏÖ§³Ö´æ´¢¹ý³Ì¡£
    PHP 5.0 ÒÔÉ쵀 mysqli ϵÁк¯Êý¿ÉÒÔÖ§³Ö²Ù×÷ MySQL µÄ´æ´¢¹ý³Ì¡£
    ÒÔÏÂÊÇһЩ¼òµ¥µÄ´æ´¢¹ý³ÌºÍÓà PHP µ÷ÓõÄʾÀý¡£     Ò»¡¢·µ»Øµ¥¸öÊý¾Ý: 1: <?php
2: header("Content-Type:t ......

CentOS+Apache+Mysql+Php°²×°¼°ÓÅ»¯ÅäÖÃС¼Ç


±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......

mySQLµÄÖÐÎÄ×Ö·û´¦Àí

1.Ê×ÏÈ£¬ÉèÖÃÊý¾Ý¿âÖ§³ÖÖÐÎÄgb2312/gbk¡£
¾ßÌå·½·¨£º
´ò¿ªmySQLÎļþ¼Ð£¬ÐÞ¸Ämy.iniÅäÖÃÎļþ¡£
[client]
port=3306
default-character-set=gb2312
ÒÔ¼°
[mysqld]쵀
default-character-set=gb2312
Ð޸쬱£´æ£¬ÖØÆô¡£ÈôÉèΪSystem·þÎñ£¬¿ÉÒÔÔÚ¿ØÖÆÃæ°å-¹ÜÀí¹¤¾ß-·þÎñÖÐÕÒµ½mySQL·þÎñ£¬ÖØÆô¡£
2.±£Ö¤Web ......

PHP´æÈ¡SQL ServerÊý¾Ý¿â

1.Ñ¡Ôñ²Ù×÷µÄÊý¾Ý¿â
Á¬½Óµ½·þÎñÆ÷Ö®ºó£¬Ê×ÏÈÐèҪѡÔñÒª½øÐвÙ×÷µÄÊý¾Ý¿â¡£Ê¹ÓÃPHPµÄMSSQLÀ©Õ¹¿âÖеÄmssql_select_db()º¯Êý¼´¿ÉʵÏÖÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£¸Ãº¯Êý¸ñʽÈçÏ£º
bool mssql_select_db(string database_name[,resource link_identifier)
¸Ãº¯Êý¸÷²ÎÊýÒâÒ壺
a. ²ÎÊý database_nameΪָ¶¨µÄ·þÎñÆ÷ÉÏ¿ÉÓõÄÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ