[Koha-bugs] [Bug 24845] Web-based installer consistently fails while creating database tables.

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24845

--- Comment #5 from Dwight Tuinstra <dwight.tuinstra at gmail.com> ---
I was finally able to get the table-creation part of the install to work by
setting the apache2 Timeout value to 30 minutes. To try to speed up mariadb, I
also set innodb_buffer_pool_size to 40M (it was not set initially). I don't
know if that made any difference, I haven't had time to run a comparison. I
also bumped up the virtual machine's memory to 4GB and dedicated 4 CPUs to it.

Actual creation of all 209 tables took over *20 minutes*, or roughly 6 seconds
(an eternity in CPU cyles and disk seek time) per table. Once this was done,
the "Selecting default settings" page took 20 to 30 minutes to finish.

Creating tables and filling in values should not take this long. I'm guessing
there is a problem with the mariadb configuration itself, or some kind of
interaction with the OS (or virtual machine manager) that is slowing down
mariadb. Either way, the documentation or the installer should make the
necessary adjustments or advise the user to do so. A person who runs into these
problems is likely to just abandon their project and spend time looking for
alternatives.

Database performance issues during install also suggest there will be similar
problems during operation.

If the performance issues during install are inescapable, then the installer
should at least give "percent-complete" progress feedback to the user. This
would reassure them and also keep the web session alive.

I am attaching a script for automating the manual, pre-web-installer steps, in
hopes this will make it easier for someone else to duplicate the problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.