6:11 p.m.
Howdy!
While working on rebasing the migration PR I've noticed that Lukas moved my
'category_seq' generator to the shiny-new 'enhanced-sequence' generator.
Does anyone remembers the reasoning for the change? I'm asking because we
do want a sequence-style generator BUT with individual sequence-like tables
when using mysql. The reason for this is SEVERE contention with InnoDB
tables under load - something that is prone to happen when you go with the
`hibernate_sequence` magic table.
I might be missing something.....HALP? :)
[]'z
2:07 a.m.
I think it was a recommendation from Gunnar, on the Hibernate-dev channel
On Thu, May 14, 2015 at 1:11 AM, Douglas Campos <qmx(a)qmx.me> wrote:
Howdy!
While working on rebasing the migration PR I've noticed that Lukas moved
my 'category_seq' generator to the shiny-new 'enhanced-sequence'
generator.
Does anyone remembers the reasoning for the change? I'm asking because we
do want a sequence-style generator BUT with individual sequence-like tables
when using mysql. The reason for this is SEVERE contention with InnoDB
tables under load - something that is prone to happen when you go with the
`hibernate_sequence` magic table.
I might be missing something.....HALP? :)
[]'z
_______________________________________________
aerogear-dev mailing list
aerogear-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev
--
Matthias Wessendorf
blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
11:15 p.m.
Heya qmx!
we was in the middle of switching from pure orm.xml to hbm.xml (in order to
allow column indexing in JPA 2.0),
when we found out the 'sequence' generator does not really work with MySQL
(the MySQL adapter complains about not supporting that configuration).
https://github.com/aerogear/aerogear-unifiedpush-server/commit/2a8fc6b70b...
So Gunnar recommended 'enhanced-sequence' which should basically be a
sequence that use fallback strategy and it should be compliant with how
Hibernate operates for JPA 2.0 sequence configuration.
I would be perfectly happy with any solution that would allow us to use the
same strategy as before, but the problem is we didn't find one.
Do someone has any suggestions?
~ Lukas
On Thu, May 14, 2015 at 1:11 AM, Douglas Campos <qmx(a)qmx.me> wrote:
Howdy!
While working on rebasing the migration PR I've noticed that Lukas moved
my 'category_seq' generator to the shiny-new 'enhanced-sequence'
generator.
Does anyone remembers the reasoning for the change? I'm asking because we
do want a sequence-style generator BUT with individual sequence-like tables
when using mysql. The reason for this is SEVERE contention with InnoDB
tables under load - something that is prone to happen when you go with the
`hibernate_sequence` magic table.
I might be missing something.....HALP? :)
[]'z
_______________________________________________
aerogear-dev mailing list
aerogear-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev
3511
days inactive
3516
days old
2 comments
3 participants
participants (3)
-
Douglas Campos -
Lukáš Fryč -
Matthias Wessendorf