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

[Peter Niederlag]

Hi,

Ernesto Baschny [cron IT] schrieb:
> Hi Allan,
[...]
> "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."

But maybe it is handled different by *nix distributions? At least my box
shows:

---- snipp mysql-default my.cnf on debian-distribution: -------------

oregon:~# cat /etc/mysql/my.cnf | grep cache
query_cache_limit       = 1048576
query_cache_size        = 16777216
query_cache_type        = 1

mysql> SHOW VARIABLES LIKE 'have_query_cache';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| have_query_cache | YES   |
+------------------+-------+

--------------------snapp-------------------------------------------

Greets,
Peter
-- 
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *
http://www.typo3partner.net * professional services network *