I agree with this - it's hard to get away from the fact that MySQL is the most commonly supported backend that TRAC will run on.
Christian - thank you for the follow up. In my experience the InnoDB engine is a better alternative anyway due to it's support for transactions and referential integrity. I know there is some issue on whether InnoDB will be supported by MySQL in the future but it would seem to be the better choice technologically. The other issue would have to do with support for full text which could be an issue if UTF-8 is not supported in MyISAM. I have never seen the index length problem referred to. I'll keep an eye out for that. On 9/21/07, Alexander Neundorf <[EMAIL PROTECTED]> wrote: > > > On Thursday 20 September 2007 03:29, Christian Boos wrote: > > Jeff Webb wrote: > > > what are the "limitations of mysql" that you refer to? > > > > > > if mysql is not the preferred supported server then is SqlLite the > > > preferred backend? to that end how well does it scale? > > > > SQLite works quite well and if scaling is an issue, the solution is to > > migrate to PostgreSQL. > > The limitations and issues of MySQL that concern us are described here: > > > > http://trac.edgewall.org/wiki/MySqlDb > > With previous Trac versions we had quite often the ugly "Database locked" > error and if I understood this correctly, the reason was that sqlite is > not a > db server but "just" an in-process db. The problem was basically > impossible > to reproduce, it just happened from time to time. > We ended up writing a hackish shell script which tries to detect every > minute > if Trac is locked (using ps, strace and other nice things) and if so > restart > the apache. This way the only workaround we found. > > So I actually hoped that Trac would support MySQL in the future (this is > already installed on most systems, whereas PostgreSQL is not that often > found). > > Bye > Alex > > > > -- Jeff Webb [EMAIL PROTECTED] http://boowebb.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
