[pLog-svn] Database layout

[Mark Wu]

Just have time to reply this thread ...

Mysql Cache is very useful if your table is "read" only .... Or "not change
so often"..

The Mysql cache will build when "select" occurs, but will "clear" when the
"table" update, delete or insert ....

So, if we turn the mysql cache on, it will do a great help on a small site
or the "read only" site ...

If the table change very often ... Then .... It is useless or even worse :(

To lifetype:

1. Mysql cache should do a great help on front page or summary page.
2. But, about the post permalink .... It is useless. Becase the
"read_counter" will changed everytime when post read ... ;(
--> To help with this issue, maybe we have to separate the counter to
different table, and make mysql cache the lt_articles table.
--> Or disable the article counter is a good idea too :) (it up to site
owner)

*** But for a growing site, I think mysql cache is worth to play with .. :)

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon Daley
> Sent: Saturday, May 20, 2006 11:23 PM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] Database layout
> 
> On Sat, 20 May 2006, Oscar Renalias wrote:
> > By the way, does anybody have MySQL's query cache enabled? I was 
> > playing with it a couple of days ago and the results where 
> quite good 
> > (most of the queries were being cached and served a lot faster from 
> > the cache!)
> 
> Debian's defaults are the following. I have not played with 
> the settings at all.
> 
> query_cache_limit   = 1048576
> query_cache_size        = 16777216
> query_cache_type        = 1
> 
> 
> **************************************
> Jon Daley
> http://jon.limedaley.com/
> 
> A fellow can't keep people from having a bad opinion of him, 
> but he can keep them from being right about it. -- Unknown 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn