Re: FreeBSD Scaling on 6.2-RELEASE?

Francisco Reyes wrote:
What combination of FreeBSD+Mysql will have multiple threads run by
different CPUs?

In the few SMP FreeBSD + Mysql setups (mysql 4.X) that I have at work
I only see mysql in one cpu as reported by top.

I just did the tests highlighted on the thread:
Progress on scaling of FreeBSD on 8 CPU systems

During that you see mysql using 130+% in top as its being scheduled on
more than 1 cpu due it being multi-threaded so this does happen

================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.

In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337
or return the E.mail to postmaster@xxxxxxxxxxxxxxxx
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Mysql speicherverbrauch
    ... CPU states: cpu user nice system irq softirq iowait idle ... das der Server zuviel Swapt. ... # Example mysql config file for very large systems. ... # but will not function as a master if omitted ...
    (de.comp.datenbanken.mysql)
  • RE: performance degradation in 6.2 when adding a second quad core chip
    ... So Benjamin you want to tell, that adding additional CPU decrease the ... 2nd CPU and some additional RAM to one of the my HP Proliant ... DL360 (generaly mysql db server) because due to heavy MySQL usage nearly to ... performance degradation in 6.2 when adding a second quad core ...
    (freebsd-performance)
  • Re: High ActiveRecord CPU Utilization
    ... I was surprised to see the Ruby CPU ... utilization at 93% and the MySQL CPU utilization at 7%. ...
    (comp.lang.ruby)
  • Re: SMP performance degradation with sysbench
    ... Core Solo / Duo, ... MySQL tries to get a mutex but it spends about 16.8% of CPU on 8 core ... threads exceeds the number of CPU cores, ...
    (Linux-Kernel)
  • Re: High ActiveRecord CPU Utilization
    ... I was surprised to see the Ruby CPU ... utilization at 93% and the MySQL CPU utilization at 7%. ... I just ran another test with a short ruby program inserting records directly using the mysql gem and it only took 1.6 seconds, and the CPU utilization was as it should be - the MySQL CPU was ten times as much as Ruby. ...
    (comp.lang.ruby)