Why is MySQL nearly twice as fast on Linux?

[Chris Elsworth]

On Mon, May 24, 2004 at 11:51:27AM -0400, Daniel Eischen wrote:
> On Mon, 24 May 2004, Chris Elsworth wrote:
> > 
> > So, each of the smackfiles used below was changed to have sql_no_cache
> > in the select. The _i smackfile simply has type=innodb in the create
> > table statement.
> 
> I'm not a DB person; can you post a diff to the smackfile?

root at cluestick:~/super-smack-1.2/smacks# diff select-key.smack_orig select-key_i.smack
23c23
<     )";
---
>     ) type=innodb";
50c50
<   query "select * from http_auth where username = '$word'";
---
>   query "select sql_no_cache * from http_auth where username = '$word'";


And:
root at cluestick:~/super-smack-1.2/smacks# diff update-select.smack_orig update-select_i.smack
23c23
<     )";
---
>     ) type=innodb";
47c47
<   query "select * from http_auth where username = '$word'";
---
>   query "select sql_no_cache * from http_auth where username = '$word'";



-- 
Chris