Hi everyone,
Anyone using MySQL as their Jpa Ticket Registry DB? How can I create the
indexes to avoid deadlocks in Mysql?
CREATE INDEX "ST_TGT_FK_I"
ON SERVICETICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
/** Create index on TGT self-referential foreign-key constraint */
CREATE INDEX "TGT_TGT_FK_I"
ON TICKETGRANTINGTICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
Source: https://wiki.jasig.org/display/CASUM/JpaTicketRegistry
Thank you,
Francisco
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
