mysql scaling questions

[Kris Kennaway]

Gergely CZUCZY wrote:

>> * Compare to my config file here:
>>
>> http://people.freebsd.org/~kris/scaling/my.cnf
>>
>> The default mysql config has very poor performance for innodb (you need at least innodb_thread_concurrency = 0 to disable some mysql 
>> brain-death).  Maybe tuning is required for myisam also.
>>
>> * Also make sure you are using identical config settings on the two systems.
> http://phoemix.harmless.hu/mysql/ verify yourself. Only the paths are
> updated, but the main parameters are just the same.

You are not in fact using the same config parameters as I am.  When I 
use your config file I see a large performance loss when I run locally 
even with innodb.

Kris