List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:October 10 2001 6:00am
Subject:Re: Last try guys! What is with the Spawning processes??
View as plain text  
On Tue, Oct 09, 2001 at 10:36:54PM -0500, Dan Nelson wrote:
> 
> The primary value of MyISAM tables are their speed when selecting
> from them, since they don't support transactions and locking is so
> simple.  But, beware that table data is not cached, so every query
> must do a physical read.

Well, the OS will cache frequently used disk blocks, so there is a
level of caching in place.  It's not MySQL doing the caching, but it's
not quite as bad as having to actually read the disk each time.

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 34 days, processed 742,429,829 queries (252/sec. avg)
Thread
Last try guys! What is with the Spawning processes??Ryan Shrout10 Oct
  • Re: Last try guys! What is with the Spawning processes??Dan Nelson10 Oct
  • Re: Last try guys! What is with the Spawning processes??Ryan Shrout10 Oct
    • Re: Last try guys! What is with the Spawning processes??Dan Nelson10 Oct
      • Re: Last try guys! What is with the Spawning processes??David Turner10 Oct
      • Re: Last try guys! What is with the Spawning processes??Jeremy Zawodny10 Oct
    • Re: Last try guys! What is with the Spawning processes??Michael Bacarella10 Oct
      • Re: Last try guys! What is with the Spawning processes??Jeremy Zawodny10 Oct
  • Re: Last try guys! What is with the Spawning processes??Fournier Jocelyn [Presence-PC]10 Oct