Re: Sorting performance vs. MySQL

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