Yes, if mysql service is configured appropriately, it will log the
queries that take > specific seconds (long_query_time parameter) to
execute in a separate file. The queries in this file can be analysed and
tuned to improve performance.
Additionally, on a non-live server we can even configure the mysql
service to log all queries that do not use index for execution.
Look at long_query_time
<http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sys
var_long_query_time> , log_queries_not_using_indexes
<http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sys
var_log_queries_not_using_indexes> , slow_query_log
<http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sys
var_slow_query_log> and slow_query_log_file
<http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sys
var_slow_query_log_file> in
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysv
ar_long_query_time
for details on how to enable them in mysql.
Thanks and Regards,
Parthasarathy T * Technical Lead * SunGard * Technology Services *
Embassy Icon, #3, 6th Floor, Infantry Road, Bangalore - 560 001,
Karnataka, India * Tel +91 80 3091 3183 * Mobile +91 99450 00394 * Main
+91 80 3091 3000 * Fax +91 80 2222 0511 * www.sungard.com/sts
<http://www.sungard.com/sts>
P Think before you print
CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential, proprietary and privileged information, and unauthorized
disclosure or use is prohibited. If you receive this e-mail in error,
please notify the sender and delete this e-mail from your system.
________________________________
From: Ryan Whitney [mailto:rwhit...@grameenfoundation.org]
Sent: Wednesday, September 02, 2009 2:48 PM
To: mifos-users@lists.sourceforge.net
Subject: [Mifos-users] Tips for troubleshooting Report Performance?
Hello all,
Working on some reports and running into performance issues. What tips
do people have for troubleshooting? I remember reading some threads
about turning on "slow queries log" on the dev list?
Be good to also add this to mifos.org
Thanks,
Ryan
--
Ryan Whitney
Mifos Technical Program Manager
rwhit...@grameenfoundation.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
