Hi,
On Tue, Feb 23, 2010 at 12:51 AM, Yang Zhang <yanghatespam@gmail.com> wrote:
> When running the query in MySQL InnoDB:
>
> $ vmstat 10
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu------
> r b swpd free buff cache si so bi bo in cs us sy id wa st
> 0 13 13733604 83020 5648 2193884 3 3 936 168 2 1
> 4 2 89 5 0
> 1 12 13749952 80164 5600 2178032 0 4354 908 4379 3586 2638
> 0 1 38 60 0
> 0 19 13762228 80576 5556 2145220 208 3527 1280 3690 3668 2635
> 1 1 39 59 0
> 0 19 13778632 79420 5560 2135228 52 4186 1046 4191 3682 2418
> 0 1 37 62 0
[snip]
> I'm guessing the swap numbers are because MySQL uses mmap?
InnoDB doesn't use mmap.
Baron