Hosting for MYSQL Database with 400 plus threads

Portal Home > Knowledgebase > Articles Database > Hosting for MYSQL Database with 400 plus threads

Posted by josephfrancis, 09-28-2007, 09:59 AM
Hello everyone, I have a website that runs off a mysql database. The first month it hit in excess of 400 threads. Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it? Your thoughts and input would be appreciated. Thanks Joe
Posted by Jakiao, 09-28-2007, 11:31 AM
Don't even bother with a VPS. 400 threads generally means you're fairly active. First: Are you using persistent connections? With that many connections, you'll benefit nicely. What OS are you running? Next, what's the output of "free -m" on this box, and what's the load? Finally, how many queries per second are you running? Thanks!
Posted by josephfrancis, 09-28-2007, 07:02 PM
HI Graham, This site was on a resellers account. It got too big for it quickly. I have no idea if its using persistant connections. How do I check? I have no idea how many queries I was running. Any way to check? Joe
Posted by Jakiao, 09-28-2007, 07:40 PM
You would need to check your script's config or check where it issues the mysql_connect or mysql_pconnect statement to determine if it's using persistent connections. Also, "mysqladmin processlist" will tell you. If you see lots of "Sleep" statements, then you're using pconnect. mysqladmin status That'll get you the queries per second, etc. For both statements you may need to specify a --user= and --password=
Posted by david510, 09-28-2007, 11:15 PM
You can disable persistent connections by making it off in the php.ini file. mysql.allow_persistent = Off

Add to Favourites Print this Article