People, I'm running a postfix server with mysql on a FreeBSD machine. This mail server holds about 500 virtual domains and 6000 virtual accounts.
Using the command mysql -e "show processlist;"|wc -l I get the current amount of mysql conns. It floats at about 150-200 simultaneous connections on mysql. When it hits 240 connections I get the error: ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug This happens too often for a production machine. There are 2GB RAM, double-Xeon, 150GB RAID5, etc. For instance, we replicated mysql on another 2 machines, so we keep balancing the load by hand on those 3 machines. Each supports 240 mysql connections. I already have tweaked a little FreeBSD's kernel with the following: kern.osrelease: 4.6.2-RELEASE kern.maxusers: 512 kern.maxproc: 8212 kern.maxfiles: 131072 kern.maxfilesperproc: 65536 kern.maxprocperuid: 7390 kern.ipc.nmbclusters: 65536 kern.ipc.maxsockets: 65536 Also, I'm using softupdates and async on disks (SCSI Ultra-3 w/ hardware raid5). I have pulled kern.maxusers to 2048 but machine begun to crash, so I kept on 512. Any idea why? If anybody has any idea about how to increase the number of concurrent conns of mysql, please help me. I've searched mysql, freebsd and postfix sites, forums archives and could not find howto solve this. Please, this machine is in production and I must solve this to pull more 15.000 accounts into this machine! Any idea, help or anything will be appreciated. If you need more info, pelase ask. Thanks in advance. -- Marcio Merlone --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
