Date: Wed, 11 Feb 2004 09:31:44 +0800 From: Dung Patrick <dkt@digitalme.com> To: davidxu@viatech.com.cn, Cc: freebsd-threads@freebsd.org Subject: Re: Re: Question about threads [beaver challenge] Message-ID: <1076463104.c8c39f40dkt@digitalme.com>
next in thread | raw e-mail | index | archive | help
Would you please explain this parameter: kern.threads.max_groups_per_proc Patrick -----Original Message----- From: David Xu <davidxu@viatech.com.cn> To: Kris Gale <kris-fbsd@asn.net> Date: Wed, 11 Feb 2004 07:00:15 +0800 Subject: Re: Question about threads [beaver challenge] Kris Gale wrote: >>On Tue, Feb 10, 2004 at 09:54:21AM -0700, Kris Gale wrote: >> =20 >> >>>>1a) Is it stable to use KSE with mySQL? >>>> =20 >>>> >>>Not in my experience. >>>http://lists.freebsd.org/pipermail/freebsd-threads/2004-February/001568.= html >>> =20 >>> >>How did you compile and configure MySQL with KSE? >> >>Did you build it from ports? If so, what version? >>What configuration did you use? >> =20 >> > >MySQL 4.0.17 from ports. KSE entries in libmap.conf. > >I tried it with and without BUILD_OPTIMIZED. I did not BUILD_STATIC, >as I normally do. The DB_DIR was reconfigured. > > =20 > >>How big were the tables that you used? >> =20 >> > >The database powers a complicated web application. There are about >150 tables. Some have a few rows, some have hundreds of thousands >of rows. > > =20 > >>How many queries did you hit the database with? >> =20 >> > >---[ From previous thread]--- >The first time I tried it, we were maintaining a load of about 600 >threads and 300 queries/second and lasted about three hours >before the thread count went through the roof and MySQL became >unresponsive. > >The second time, we were sustaining a load of 1300 threads and >600 queries/second. This only lasted about 30 minutes. >------ > >I wasn't able to see the total number of queries because the >database became unresponsive, but a quick estimate using the >query rates and uptimes above would be several million. > >300 qps * 60 seconds * 60 minutes * 3 hours =3D 3.24 million >600 qps * 60 seconds * 30 minutes =3D 1.08 million > >Kris > > =20 > What's the value of your sysctl kern.threads.max_threads_per_proc and kern.threads.max_groups_per_proc ? Mysql heavily uses system scope thread. David Xu _______________________________________________ freebsd-threads@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-threads To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1076463104.c8c39f40dkt>