Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

Hi Anton, *,

On Wed, Apr 13, 2011 at 6:41 PM, Anton Meixome <> wrote:

Sorry Christian, my english is not fluent and that's reason for not
comment in retaill the problems.
Perhaps Friedel can help more here. I think he was supporting the pootle's instalation, that is rolling perfectly.

Well, they have tons of RAM (IIRC the server has 12GB of RAM, and is
only used for pootle) available and can put the whole database into
RAM without problem, then the drawbacks on how pootle uses the
database, and also the drawback of having table locks with myISAM
doesn't impact performance that much.

But we're running pootle inside a VM, and there is not enough ram on
the host to allow file caching in this magnitude.

The problem is that when it needs to access the disk to read the
database, it can easily come to a point where user A requests data
that is on block a on the disk, and  user B requests data that is on
block b, but both are not in RAM at the same time, so it has to
constantly read stuff from disk - and that is slow. Even worse is when
some lengthy process is run over the whole database (like when
uploding files and regenerating statistics, and similar)

Can I suggest temporaly hide Help files? Is possible that diff and
mess functions in .po overload the server.

I now tweaked both mysql's parameters as well as the setup of the
virutalbox VM so that now parts of the databse can be cached by the
host, so that the VM doesn't need to do real disk i/o anymore (at
least now to a much lesser extent).

While not completely eliminating wait times (for example when
mysqldump is running, it locks the table and thus during mysqldump no
other accesses to the table are possible), those waiting times should
now much shorter (as mysqldump completes faster, all other slow
operations also should complete faster, thus it is less likely to get
into a "I want block A, but other user wants B, yet another one wants
D" at the same time.


Unsubscribe instructions: E-mail to
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.