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

[Allan Jacobsen]

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.


Best regards/MVH
Allan Jacobsen
Infrastruktur, Dansk Tipstjeneste A/S
Korsdalsvej 135, 2605 Brøndby

-----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


> -----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 09:37
> Til: typo3-dev at lists.netfielders.de
> Emne: Re: [TYPO3-dev] Typo3 Database design question (optimization /indices)
> 
> Marc Wöhlken [quadracom] schrieb am 28.03.2006 21:45:
> 
>>> In my tests, I see no difference in the "parse-time" (shown by TYPO3 at
>>> the bottom of the page, if debug is on) when calling some typo3-page
>>> with and without those indexes with "&no_cache=1".
> 
>> Do you have mysql query cache enabled? How much memory do you use for
>> caching?
>> 
>> As you cant't measure any differences it may be the way that you have a
>> relatively small Typo3 site and a large query cache. In this case most
>> querys would come from cache and be delivered in virtually no time.
>> 
>> In situations like this your Typo3 site would not really benefit from
>> indexes.
> 
> True, the site I tested is not very big. But I have no query-cache enabled.
> 
> Cheers,
> Ernesto
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev


-- 
cron IT GmbH
Dipl.-Inf. Ernesto Baschny
Nobelstr. 15, D-70569 Stuttgart

Tel: +49 711 6868 909-33
Fax: +49 711 6868 909-10

Fingerprint: E918 7A64 9C50 CD35 67A9  752C 1C70 EE8B 915F 6438
_______________________________________________
TYPO3-dev mailing list
TYPO3-dev at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev