http://www.databasejournal.com/features/mysql/article.php/10897_1382791_3/Optimizing-MySQL-Queries-and-Indexes.htmBy Ian GilfillanYouknow the scene. The database is just too slow. Queries are queuing up,backlogs growing, users being refused connecti

http://www.mysqlperformanceblog.com/2006/09/01/order-by-limit-performance-optimization/ORDER BY … LIMIT Performance OptimizationPosted by peter | Vote on Planet MySQL<br />Suboptimal ORDER BY implementation, especially together with

索引的类型<br />http://www.db110.com/?p=1886<br />索引是在存储引擎中实现的,而不是mysql server级, 但基本的索引类型原理大致类似.<br />以下为主要的索引类型:<br />B树索引:<br />大部分的mysql 存储引擎支持B树索引,Archive engine是一个例外,5.1才支持一个auto_increment列的索引. B树在MYISAM中的实现采用了前缀压缩的技术,这样索引更小,提高性能效率,而innodb则不压缩索引;MYISAM

<br />http://www.informit.com/articles/article.aspx?p=377652<br />Match index types to the type of comparisons you perform.When you create an index, most storage engines choose the index implementationthey Match index types to the type of comparisons y

<br />http://hi.baidu.com/thinkinginlamp/blog/item/eef0cd119239db17b8127b6f.html<br />前记：很多东西看似简单，那是因为你并未真正了解它。<br /><br />Explain命令用于查看执行效果。虽然这个命令只能搭配select类型语句使用，如果你想查看update，delete类型语句中的索引效果，也不是太难的事情，只要保持条件不变，把类型转换成select就行了。<br /><br />explain的语法如下

What if you were a racecar driver and could swap engines with theflip of a switch instead of having to make a trip to the garage? TheMySQL database does something like this for developers; it gives you achoice of database engines and an easy way to s

<br />Q : 怎样查看局域网中所有的用户和IP？   最好使用DOS命令，不知道有没这样的命令？<br /> <br /> <br />A : //怎样查看局域网中所有的用户和IP？   最好使用DOS命令，不知道有没这样的命令？ <br /><br /> 查看所有用户：net   view <br /> 查看所有IP可以写个批处理逐个ping一下用户名<br /> <br />refer to : http://topic.youkuaiyun.com/u/20070725/15/f380d152-e4

http://ronaldbradford.com/blog/tag/show-profile/Posts Tagged ‘show profile’MySQL Query Cache pathMonday, September 28th, 2009Just how effective is the Query Cache on performance? If you are not comfortable reading the MySQL code you can cheat very ea

http://howto-use-mysql-spatial-ext.blogspot.com/This mini tutorial explains how to use the Spatial extensions of MySql 5.x and demonstrates the high performaces that can be obtained if used in the correct way.The tutorial is intended to users who know SQL

<br />http://www.filonov.com/blog/2009/04/02/fogbugz-speed-issue-an-example-of-mysql-slow-queries-troubleshooting/<br />FogBugz speed issue – an example of MySQL slow queries troubleshooting<br /><br />We are using FogBugz application for the bugs and su

http://www.mysqlperformanceblog.com/2007/02/16/using-index-for-order-by-vs-restricting-number-of-rows/Using index for ORDER BY vs restricting number of rows.Posted by peter | Vote on Planet MySQL<br />Oneinteresting problem with MySQ

http://www.databasejournal.com/features/mysql/article.php/10897_1382791_4/Optimizing-MySQL-Queries-and-Indexes.htm<br />The Query Optimizer, OPTIMIZE and ANALYZE<br /> The magic inside MySQL that decides which keys, if any, to use to in the query, is c

http://www.xaprb.com/blog/2006/10/12/how-to-profile-a-query-in-mysql/When people discuss query optimization on MySQL, or say a querydoesn’t perform well, they usually mention execution time. Executiontime is important, but it’s not the only metric to u