Re: Sharing a Database Between Websites

[Brent Baisley]

show variables like 'query%';
That will show you the setting for mainly your query cache. The 
query_cache_type will tell you if it's on or not.

On Mar 23, 2005, at 3:08 PM, David Blomstrom wrote:
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
There are advantages to one large
table over many
smaller tables. A large table will take advantage of
query caching
better (if you have query cache enabled). Lots of
smaller table would
probably cause the query cache to get flushed more
often.
OK, thanks. I don't foresee my database growing to
over 200 tables in the near future.
How do I determine if I have query cache enabled?
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]