[Date Prev][Date Next]
(ITS#6612) Back SQL / Mysql / InnoDB
Full_Name: Frederik Bosch
Submission from: (NULL) (220.127.116.11)
Problem Description: using InnoDB as MySQL table engine prevents records from
updating. This is due to the autocommit=0 implementation in InnoDB. There are
two possible solutions.
1. Execute COMMIT before every SELECT statement
2. Disable autocommit
My suggestion is to use the latter one by adding a configuration option for
slapd.conf to enable autocommit. Something like disable_autocommit no|yes, which
defaults to yes (current implementation).
Perhaps, this will have issues for write mode (INSERT), but this backend is
intended for read only usage, isn't it? My C knowledge is too limited to add a
More details can be found in pasted mailing list thread.