Re: Performance tuning - comparing two computers

[Francis Mariani]

Øystein,

Thanks very much for your response and your suggestions.

MySQL Version info - same for both computers:

innodb_version 1.1.8
protocol_version 10
version 5.5.22-log
version_comment "MySQL Community Server (GPL)"
version_compile_machine x86
version_compile_os Win64

SHOW STATUS LIKE 'HANDLER%' is the same on both PC's, all variable values are zero.

Both EXPLAIN results are the same, except the the new PC "rows" is 140,000 less (PC1: 1,805,004/ PC2: 1,665,117), which I can't "explain", because the select request on both computers read 1,256,327 rows.