Re: Multithreaded?
On Tue, Oct 21, 2003 at 10:13:55AM -0700, Greg(Bear) Casad wrote: All installations of mysql I have run ps -fax will show about 5 mysql proccess running, even at idle. mysql or mysqld? I compiled on a Redhat 9 box, it did find pthreads however ps -fax show 1 mysqld process running. Is it using NTPL? Is there a spot to configure spare proccess? -- Or verify that it is indeed compiled muli-threaded?? The MySQL server (mysqld) is *always* multi-threaded. As far as spares, you might want to look at setting your thread_cache to a non-zero value. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 39 days, processed 1,493,368,938 queries (439/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Multithreaded?
On red hat systems threads show up in a normal processlist. Thoese are threads that your seeing, some for connections others to do some innodb tasks and/or replication. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Greg(Bear) Casad [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 21, 2003 10:14 AM --To: [EMAIL PROTECTED] --Subject: Multithreaded? -- --All installations of mysql I have run ps -fax will show about 5 mysql --proccess running, even at idle. --I compiled on a Redhat 9 box, it did find pthreads however ps -fax --show 1 mysqld process running. --Is there a spot to configure spare proccess? -- Or verify that it is --indeed compiled muli-threaded?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multithreaded?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 21 Oct 2003, Greg(Bear) Casad wrote: All installations of mysql I have run ps -fax will show about 5 mysql proccess running, even at idle. Yep. I compiled on a Redhat 9 box, it did find pthreads however ps -fax show 1 mysqld process running. NPTL (RedHat9 comes with NPTL, among other differences between NPTL and old Linuxthreads was this that the threads show as a single process now). http://people.redhat.com/drepper/nptl-design.pdf (btw, can you get a working mysql 4.0.x statically compiled mysqld version on RedHat9 ? I have problems with statically linked programms on NPTL enabled glibc, including mysql. Please compile a 4.0.x version, run it and try to just enter a session with mysql CLI and exit the session and check if the mysqld has crashed/restarted on your exit, check the uptime by status command thanks!) Is there a spot to configure spare proccess? -- Or verify that it is indeed compiled muli-threaded?? I dont know, Im very curious about that too... - Mihai RUSUEmail: [EMAIL PROTECTED] GPG : http://dizzy.roedu.net/dizzy-gpg.txtWWW: http://dizzy.roedu.net Linux is obsolete -- AST -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/lXWpPZzOzrZY/1QRAoaVAKCmY9lS2sho+m4Qov46HyF38ef5NgCgzOs/ lVFCmBm75xAqgpwTJd0nD5c= =hItY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]