Another change is to make sure our test user has create/drop privileges on
all databases, and to be able to create/drop databases:
grant create, drop on *.* to 'hibernate_orm_test'@'localhost';
We will need similar for the other databases too.
On Tue, Jul 21, 2015 at 6:02 PM Sanne Grinovero <sanne(a)hibernate.org> wrote:
On 20 July 2015 at 17:41, Steve Ebersole <steve(a)hibernate.org>
wrote:
> Sanne for MariaDB (and MySQL if we ever add it) we need to add at least
one
> more setting:
>
> sql-mode="traditional"
I've applied this change.
--Sanne
>
> We could probably get away with less ANSI compliant mode, but after days
> playing with this I just want to cover my bases :)
>
> On Sat, Jul 18, 2015 at 3:37 PM Sanne Grinovero <sanne(a)hibernate.org>
wrote:
>>
>> Thanks, great suggestions!
>> I've applied these and some more.
>>
>> The MariaDB configuration:
>> -
>>
https://github.com/hibernate/ci.hibernate.org/blob/master/roles/mariadb-s...
>>
>> The PosgreSQL configuration files:
>> -
>>
https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-...
>> -
>>
https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-...
>>
>> Both are running with these settings now on each CI slave.
>> Sanne
>>
>> On 18 July 2015 at 00:49, Steve Ebersole <steve(a)hibernate.org> wrote:
>> > [18:45] <sebersole> whoa..
>> > [18:45] <sebersole> sannegrinovero: we definitely need this for
mariadb
>> > on
>> > ci...
>> > [18:46] <sebersole> sync_binlog=0 innodb_flush_log_at_trx_commit=0
>> > innodb_doublewrite=0
>> > [18:46] <sebersole> tests were much faster
>> >
>> > These were suggested to me on the #mariadb list. I added them to my
>> > local
>> > /etc/my.cnf file and the tests were significantly faster.
>> > _______________________________________________
>> > hibernate-dev mailing list
>> > hibernate-dev(a)lists.jboss.org
>> >
https://lists.jboss.org/mailman/listinfo/hibernate-dev