Preventing a long-running query from monopolizing CPU of DBMS through jdbc
"Ralf Hauser" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <001501c68357$0b57e1a0$2201a8c0@AcerRalf> |
Hi all,
In a tomcat web application with a commons-dbcp connection pool, for maintenance purposes, we are regularly (cron-job) executing some heavy-duty queries that can easily take an hour or so. In the meantime, we would like to have some minimum response time for other tasks all the same.
While on the tomcat-side, I can easily set the enclosing struts-action thread on a low thread-priority level for the time of the execution of that query, it is unclear how to prevent the mysqld from taking 99% of the CPU and basically starving all other queries that may come in from a few late-night/early-morning users...
Any hints how to do this in jdbc?
Regards
Ralf
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/[email protected]