Mailinglist Archive: opensuse (911 mails)

< Previous Next >
Re: [opensuse] Best FS fo PostgreSQL/MariaDB
  • From: Vojtěch Zeisek <vojtech.zeisek@xxxxxxxxxxxx>
  • Date: Thu, 03 Dec 2015 17:03:47 +0100
  • Message-id: <4415890.CY28akrYKr@veles>
Dne Čt 3. prosince 2015 10:51:10, Anton Aylward napsal(a):
On 12/03/2015 07:52 AM, Vojtěch Zeisek wrote:
Also there are several, I'd say
ordinary, webs using CMS like Drupal.

The you are going to get a lot of searches of the FIND WHERE AND nature,
where one of the AND is going to be the user id. That is a problem for
indexing, which again gets back to reads of the database.


Most CMSs do logging, but whether you choose to log to the database or
the file system depends on the options offered by the CMS. How you use
the logs will be of importance here. Using them for accounting/billing
seems wasteful when the function is better implemented n the application.

They are set to log into the database (not system), but usage of logs is
extensive, basically just for statistics.

Some CMSs do various kinds of caching of their own, again you have
options of how much of that can be in memory.

Yes, Drupal has it.

Check out 'memcached' and 'redis'.

Of course, tuning of the application itself is the most important step...

Vojtěch Zeisek

Komunita openSUSE GNU/Linuxu
Community of the openSUSE GNU/Linux
< Previous Next >
Follow Ups