Dear Daniel,
Thanks. The slow query log works. :-)
The code doesn't work. It called from a cron4j under Tomcat:
public class SchedulerServletContextListener implements
ServletContextListener {
private static final String SCHEDULER = "cron4j.scheduler";
@Override
public void contextInitialized(ServletContextEvent event) {
ServletContext context = event.getServletContext();
Scheduler scheduler = new Scheduler();
Task slowQueryReport = new SlowQueryReport();
try {
if (Tools.isTest()) {
scheduler.schedule("0 23 * * *", slowQueryReport);
}
} catch (UnknownHostException ex) {
Logger.getLogger(SchedulerServletContextListener.class.getName()).log(Level.SEVERE,
ex.toString(), ex);
}
scheduler.start();
context.setAttribute(SCHEDULER, scheduler);
}
@Override
public void contextDestroyed(ServletContextEvent event) {
ServletContext context = event.getServletContext();
Scheduler scheduler = (Scheduler) context.getAttribute(SCHEDULER);
context.removeAttribute(SCHEDULER);
scheduler.stop();
}
}
public class SlowQueryReport extends Task {
@Override
public void execute(TaskExecutionContext executor) throws
RuntimeException {
StringBuilder report = new StringBuilder();
report.append(getStat("x"));
report.append(getStat("x"));
report.append(getStat("x"));
report.append(getStat("x"));
MailSender.sendDirectMail("sen...@x.hu", "x...@x.hu", "Slow Query Report",
report.toString());
}
private String getStat(String poolName) {
StringBuilder result = new StringBuilder();
Map<String, SlowQueryReportJmx.QueryStats> map =
SlowQueryReportJmx.getPoolStats("jdbc/" + poolName);
if (map == null) {
result.append("No pool: ").append(poolName);
} else {
for (Map.Entry<String, SlowQueryReportJmx.QueryStats> entry
: map.entrySet()) {
result.append(entry.getKey()).append('\t').append(entry.getValue().toString());
}
}
return result.toString();
}
}
Thanks,
Ferenc
On 2013.06.05. 16:54, Daniel Mikusa wrote:
On Jun 5, 2013, at 4:10 AM, Lutischán Ferenc <lutisch...@gmail.com> wrote:
Dear Daniel,
Thanks for your reply.
My Tomcat version is 7.0.35. It is under CentOS 5.8.
My datasource config is:
<Resource name="jdbc/xxx" auth="Container" driverClassName="org.postgresql.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="1" maxIdle="20"
maxActive="20" maxWait="5000" password="xxx" type="javax.sql.DataSource" url="jdbc:postgresql://10.3.76.41/xxx" username="xxx" validationQuery="select 1"
jdbcInterceptors="ConnectionState;SlowQueryReportJmx(threshold=1000)" testOnBorrow="true"/>
There is my java code:
Map<String, SlowQueryReportJmx.QueryStats> map =
SlowQueryReportJmx.getPoolStats("java:comp/env/jdbc/" + poolName);
And where are you trying to run this?
I tried the config with
jdbcInterceptors="ConnectionState;SlowQueryReport(threshold=1000)",
but there is no messages in the Tomcat log files.
With both SlowQueryReport and SlowQueryReportJmx, you should see entries in
your log files when a slow query occurs. In the case of your configuration, a
slow query would be one that lasts longer than one second.
If you have a query that runs for longer than one second, you'll see a log entry at the
WARN level and it'll start with "Slow Query Report SQL=".
If you don't see these…
1.) Make sure that your application is taking a connection from the
connection pool and using that to execute the query.
2.) Make sure that your query is actually running for longer than one second
or for testing purposes lower the threshold so that your query runs longer than
the threshold.
3.) Make sure that your logging configuration is not preventing the entry
from being displayed. The default logging.properties file that is included
with Tomcat should show these messages.
Dan
Thanks,
Ferenc
2013.06.04. 16:20 keltezéssel, Daniel Mikusa írta:
On Jun 4, 2013, at 6:26 AM, Lutischán Ferenc <lutisch...@gmail.com> wrote:
Dear Users,
Please help to me:
How to get SlowQueryReport statistics?
Usually these are logged as WARN messages. Unless you use SlowQueryReportJmx
and then they are logged and sent as JMX notifications.
I tried:
Map<String,SlowQueryReport.QueryStats> map =
SlowQueryReport.getPoolStats("java:comp/env/jdbc/xxx");
and
Map<String,SlowQueryReport.QueryStats> map =
SlowQueryReport.getPoolStats("xxx");
The result in both case was a null map.
Can you elaborate on what you are trying to do here?
Are you using Tomcat?
If so…
1.) What version are you using?
2.) How do you have your data source configured? Please include the
resource tag.
If not…
1.) Are you using the Tomcat's jdbc-pool directly?
2.) How are you setting it up?
3.) How is it configured?
4.) What version are you using?
Dan
Thanks,
Ferenc
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
