2 Replies Latest reply on Jan 4, 2008 2:58 PM by Tim Fox

    mysql persistence performance - high load + deadlocks

    Jonathan Duty Newbie

      ENV:

      JBoss 4.2.2
      JBM 1.4 SP1
      MySQL 5.0.x

      From within an EJB3 slsb we pump about 600,000K messages into a clustered topic daily using XA transactions, which is consumed by 4 separate clustered durable subscriptions (this occurs in a cluster of 3 jboss nodes). When we use persistent messaging we see lots of deadlocks in mysql and a high unix load. When we don't use persistent messaging the deadlocks and high load goes away.

      My question is have you all come across this also and is there any configuration work around to lower the load and deadlocks when using persistent messaging?

      Thanks,
      ~Jonathan