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

_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to