[Date Prev][Date Next]
Re: back-sql mysql innodb
> Thanks p.. I did some more testing and you are right. It is a RDBMS
> problem. This is what I found (tested with iSQL and directly on the
> In chronological order:
> 1. SET autocommit=0
> 2. SELECT @@autocommit -> result: 0, it is turned off
> This is standard slapd/back-sql config.
> 3. SELECT * FROM ldap_entries -> 10 results
> 4. Now I change the data directly using a different connection and other
> GUI. I add a record (and commit it).
> 5. SELECT * FROM ldap_entries -> 10 results
> The latter result surprised me. So if data is changed by another
> connection, it will not be refresh data on other connections.
> 6. COMMIT
> 7. SELECT * FROM ldap_entries -> 11 results
> So, in order to refresh data, slapd has to prepend every read operation
> with a COMMIT. This is not logical, is it?
> So, I believe adding a configuration option, for people who want to use
> back-sql with MySQL/InnoDB, could be a handy solution. Where can I add
> this feature request?
You may reference this thread (point to the relevant message from the