View Full Version : MySQL on magnatar down?
tedherman
3-19-03, 07:15 PM
Is MySQL on magnatar.powweb.com down?
I also had another question. Let's say you were to run a query that was five lines long. Would this count as 5 'questions'? I know they limited 'max_questions' or queries to 36,000 an hour. Can anyone tell me?
HalfaBee
3-19-03, 07:28 PM
Yes mysql on magnatar is down :(
Do mean do a query like
mysql_query( "select * ....;select count(*); select now();" );
being 3 selects in 1 mysql query?
It would probably count as 3 I don't know if it would even work.
HalfaBee
Fixed. Sorry for any inconvenience.
tedherman
3-19-03, 10:14 PM
Thanks, yeah it's back up.
By query I mean, well here's a multiline query, tell me if it's one query or counts as three queries:
INSERT INTO table1 (name,userid,userlevel) VALUES ("John","1","5")
INSERT INTO table1 (name,userid,userlevel) VALUES ("Fred","2","3")
INSERT INTO table1 (name,userid,userlevel) VALUES ("Alan","3","3")
Is this three queries or one?
HalfaBee
3-20-03, 06:06 AM
INSERTS are not counted in your query count.
These are unlimited.
If they were included in the querycount you could never restore your DB.
HalfaBee
tedherman
3-20-03, 08:40 PM
Ok then I'm gonna have no problem with the query limits. Thanks, mods you can close this thread.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.