[TYPO3-dev] Typo3 Database design question (optimization/indices)

[Ernesto Baschny [cron IT]]

Allan Jacobsen schrieb am 29.03.2006 10:59:

> OK, then either you are unlucky or I am lucky, because I have never seen a
> mysql server (> 4.0) without caching enabled, and I have installed many
> hundred servers, mainly redhat and debian, and for the redhat server
>  we use standard rpm packages from the mysql website, and with their
> sample my.cnf files caching is enabled.

So this is not a MySQL default but a "sample my.cnf".

But you are right, I've checked other machines here (Debian, RedHat) and
the query_cache was indeed enabled. Only SuSE (which are the machines
I've checked) didn't seem to have query_cache enabled by default (so
mysql defaults were being used: "0").

Cheers,
Ernesto


> -----Oprindelig meddelelse-----
> Fra: typo3-dev-bounces at lists.netfielders.de [mailto:typo3-dev-bounces at lists.netfielders.de] På vegne af Ernesto Baschny [cron IT]
> Sendt: 29. marts 2006 10:17
> Til: typo3-dev at lists.netfielders.de
> Emne: Re: [TYPO3-dev] Typo3 Database design question (optimization/indices)
> 
> Hi Allan,
> 
> Allan Jacobsen schrieb am 29.03.2006 09:42:
> 
>> Which version of mysql are you using ?
>> Unless it is version 3.xx you have to explicitly disable caching.
>> Otherwise it will be used.
> 
> "query_cache" is not enabled by default in any MySQL installation I
> know. Default seems to be "query_cache_size = 0":
> 
> http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html
> 
> "The default size is 0, so the query cache is disabled by default."
> 
> Cheers,
> Ernesto