References
Reference NO 1
http://technet.microsoft.com/en-us/library/ms177500(v=sql.105).aspx
Reference NO 2
http://stackoverflow.com/questions/806015/sql-query-joins-multiple-tables-too-slow-8-tables
Reference NO 3
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/
Reference NO 4
http://www.mysqlperformanceblog.com/2012/09/20/a-prototype-lower-impact-slow-query-log/
Reference NO 5
http://my.safaribooksonline.com/book/databases/mysql/9780596101718/query-performance-optimization/slow_query_basics_optimize_data_access
Reference NO 6
http://blogs.mpr.org/developer/2013/06/using-mysqls-slow-query-log-to-pinpoint-sql-performance-bottlenecks/
Reference NO 7
http://techblog.careesma.com/2010/05/27/optimizing-slow-queries-in-mysql/
Reference NO 8
http://erniemiller.org/2011/08/30/slow-mysql-query-ill-give-you-a-hint/
No comments:
Post a Comment