-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Miguel,
On 5/3/12 2:25 PM, Miguel González Castaños wrote: >> Just the -XX:+HeapDumpOnOutOfMemoryError you already have. >> Tomcat usually doesn't shut down nicely (as evidenced by the >> "pausing" of connectors in your log file) when you get an OOME. >> Are you sure that weekly Tomcat-restart process isn't still >> running? > > Yes, it's still running. Should i disable it? Well, if it's shutting-down your JVM while you're trying to observe it, then maybe you don't want it doing that. *shrug* I'm just saying that Tomcat doesn't usually just decide to shut down for no good reason. > I have set logAbandoned=true. I haven't enabled the removeAbandoned > and the removeAbandonedTimeout just in case. Will I get the info in > the catalina log? Yes. logAbandoned IIRC logs to System.out, so you'll get that stuff in catalina.out. I also recommend setting logAbandonedTimeout to something reasonable. I don't remember the default. > Right now I get the following cronjob forwarded to my email > > /usr/bin/mysqldumpslow -s -t /var/log/mysql-slow.log | mail -s > .... Whoever wrote that didn't read the mysqldump manual. Who knows *what* that's going to give you. > Yes, I have pinpointed several queries that took quite long and > specially subqueries. I forwarded this info to the developer but > she said it was alright. More than a second to run a query seems to > be a lot to me. That depends on what the query does. If it checks permissions to login, that's insane and you should get a new programmer. If it's a reporting query that gathers lots of data then 1 second might not be quite so far-fetched. > The problem is that since the database E/R is not documented, it's > going to take a while to improve the performance of the queries. Look into SchemaSpy. > The developer is quitting so I hope a new developer is more > cooperative and we can work out these things. So you're saying that you're not going to get a lot of good information out of him/her? > In the meantime I will check what I can do. I have also downloaded > mysqltuner script and mysqlfragfinder a long time ago and follow > the output of these tuning scripts. Just rememeber to vet all the recommendations. Don't just read "increase your query cache size" as a recommendation and blindly apply that rule. Many times the query cache is less useful that you might think. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+i5OQACgkQ9CaO5/Lv0PA/GwCgrrZL44k33jhm1AG4rPOefy3n aFgAoKm3mqmr3bvOY1sTyogSPunPL4kt =gl93 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
