Re: Is the new MySQL table cache implemented in InnoDb? #

2002-03-15 Thread Miguel Angel Solorzano

At 14:20 15/03/02 -0600, BD wrote:
Hi!
>The eWeek article http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp 
>that benchmark the various databases including MySQL stated:
>
>"MySQL's great performance was due mostly to our use of an in-memory query 
>results cache that is new in MySQL 4.0.1. When we tested without this 
>cache, MySQL's performance fell by two-thirds."

The query cache feature is independently of the database engine, you
can use it with InnoDB, MyISAM and BDB tables. The mentioned benchmark was
performed with InnoDB and MyISAM tables simultaneously.

Regards,
Miguel

>1) Has this new caching been implemented for InnoDb tables?
>2) If not, will it be implemented for InnoDb tables? Time frame?
>
>TIA
>
>Brent
>

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Is the new MySQL table cache implemented in InnoDb? #

2002-03-15 Thread BD

The eWeek article http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp 
that benchmark the various databases including MySQL stated:

"MySQL's great performance was due mostly to our use of an in-memory query 
results cache that is new in MySQL 4.0.1. When we tested without this 
cache, MySQL's performance fell by two-thirds."

1) Has this new caching been implemented for InnoDb tables?
2) If not, will it be implemented for InnoDb tables? Time frame?

TIA

Brent 


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php