Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?

2007-09-18 Thread Kris Kennaway
Philip M. Gollucci wrote: Is it worth having the port remove that recommendation from the /usr/local/share/mysql/*.cnf files ? It probably is worth it, yeah. Kris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listin

Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?

2007-09-18 Thread Kris Kennaway
Philip M. Gollucci wrote: Philip M. Gollucci wrote: my.cnf innodb_thread_concurrency = 8 You want '0' or performance will suck. There's a basic architectural flaw in how mysql handles non-zero concurrency values here (innodb accesses are serialized by a global mutex that protects a counter to

Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?

2007-09-18 Thread Philip M. Gollucci
Kris Kennaway wrote: > libthr has been around (and performing better than libkse) since the 5.x > days and has been recommended for use since 6.0. Yeah I knew it had been around -- missed the recommend part. >> sysctl kern.timecounter.choice >>kern.timecounter.choice: TSC(-100) ACPI-fast(1

Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?

2007-09-18 Thread Philip M. Gollucci
Philip M. Gollucci wrote: >>> my.cnf >>> innodb_thread_concurrency = 8 >> You want '0' or performance will suck. There's a basic architectural >> flaw in how mysql handles non-zero concurrency values here (innodb >> accesses are serialized by a global mutex that protects a counter to >> check if i