PDA

View Full Version : MySQL max_questions

ruadork
02-09-2006, 07:05 PM
I'm currently helping with a site on another host that has a 72,000 queries, per hour, per user MySQL limit.

I'm considering bringing the site to bluehost since that's who I use for my other sites. Anyone know the MySQL limit here? I haven't had any problems with reaching the limit here, but my dbs don't require as much as the one hitting the 72,000 limit (which only happens when I try to export data).
rando
02-09-2006, 09:24 PM
I'm currently helping with a site on another host that has a 72,000 queries, per hour, per user MySQL limit.

I'm considering bringing the site to bluehost since that's who I use for my other sites. Anyone know the MySQL limit here? I haven't had any problems with reaching the limit here, but my dbs don't require as much as the one hitting the 72,000 limit (which only happens when I try to export data).

We don't limit that, we think it's terribly unfair. After all, 100,000 small queries or queries on well-indexed tables will take up less resources than 300-500 horrible queries on written by people who don't know how to index their tables.

What we do limit you on is how many big terrible cpu sucking stuff you can use. queries that take longer than a few seconds to run count towards your cpu quota. Queries that are under that limit don't even count towards the total.
MikeKieffer
02-10-2006, 12:04 PM
That is one of the Main reasons I started hosting with bluehost.com. I was shut down several times by my other provider because of that. My site does a lot of dynamic stuff, but most of them only return small sets of data.
ahwm
03-12-2007, 10:34 PM
I know this is old, but I have a question to add onto this... With iPowerWeb, the limit 50,000 or something like that... We were using x7chat and it worked beautifully until we had 20 people on there.. It died within minutes as I understand it. Though I'm not sure why it would require quite that many...

Anyway, would that be any kind of a problem? I just wanted to check beforehand.
Basil
03-13-2007, 01:22 AM
The limit isn't on the number of queries, it's on the amount of time your queries take up.

A poorly written script will not last long on these servers.