PDA

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

LexF
3-19-03, 07:39 PM
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.