Tweet
When I get this message (see below) is it really that the SQL "server shutdown is in process"
It seems like it's happening a lot recently...
It seems like it's happening a lot recently...
Attached Files
-
Haven't been here for ages.... -
I think them SQLs is drunk.
~ If Tehben spits eggs at you, jump on them and throw them back. ~ Eventis ~ Eventis Dungeons & Dragons 6th Age Campaign: Chapter 1, Chapter 2, Chapter 3, Chapter 4: (Unspeakable) Horror on the Hill ~ -
Using the DISTINCT command.
Is God willing to prevent evil, but not able? Then he is not omnipotent. Is he able, but not willing? Then he is malevolent. Is he both able and willing? Then whence cometh evil? Is he neither able nor willing?
Then why call him God? - EpicurusComment
-
Comment
-
MySQL.
It's about time a site of this size upgrades to a real DB."The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
Ben Kenobi: "That means I'm doing something right. "Comment
-
Yeah, got a few of them lately. But not that much more than before though.Do not fear, for I am with you; Do not anxiously look about you, for I am your God.-Isaiah 41:10
I praise you because I am fearfully and wonderfully made - Psalms 139.14a
Also active on WePlayCiv.Comment
-
Why not? From what I've read MySQL is of the best things around for forum boards.Originally posted by Asher
MySQL.
It's about time a site of this size upgrades to a real DB.
EDIT: I just got one after using "My Threads"Is God willing to prevent evil, but not able? Then he is not omnipotent. Is he able, but not willing? Then he is malevolent. Is he both able and willing? Then whence cometh evil? Is he neither able nor willing?
Then why call him God? - EpicurusComment
-
MySQL is simple and free, and fine for small loads.Originally posted by alva
Why not? From what I've read MySQL is of the best things around for forum boards.
EDIT: I just got one after using "My Threads"
Its performance sucks for large databases, and it lacks some "basic" features like DB views."The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
Ben Kenobi: "That means I'm doing something right. "Comment
-
what DB do you suggest and do you volunteer to do a port of our scripts (vbulletin, vb mods, civgroups, hofs, dir, news, etc) to it?Originally posted by Asher
It's about time a site of this size upgrades to a real DB.
Co-Founder, Apolyton Civilization Site
Co-Owner/Webmaster, Top40-Charts.com | CTO, Apogee Information Systems
giannopoulos.info: my non-mobile non-photo news & articles blogComment
-
I suggest DB2 for Linux, and I'm forced to recommend you use IBM's consulting arm if you need help porting things.
Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice. It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL."The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
Ben Kenobi: "That means I'm doing something right. "Comment
-
Well, php has different commands for accessing different types of databases, so even if the SQL queries are pure SQL there would still be changes needed. Also sometimes serverspecific features might have been taken in use in an optimization phase, since the code is creted to run on MySQL. I don't remeber if I've used any MySQL only functionality in my scripts, but a rule of thumb has been that I've not done it unless it would meen a good optimization compared to default SQL syntax.
vBulletin only supports MySQL (at least last time I checked) but that might also only be due to the php access functions.Creator of the Civ3MultiToolComment
-
so, is the mysql server (service) really shutting down multiple times a day?Haven't been here for ages....Comment
-
All the comparative reviews I read put MySQL and PostgresSQL on the same level. Each has its own advantages and disadvantages.Originally posted by Asher
Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice.
All MySQL commands are standard SQL AFAIK.Originally posted by Asher
It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL.(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."Comment
-
Asher knows his shiznit.Originally posted by Asher
I suggest DB2 for Linux, and I'm forced to recommend you use IBM's consulting arm if you need help porting things.
Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice. It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL.
Postgres is free and is an awesome database.
It never, ever crashes.
MySQL isn't in the same league as Postgres.
Developers like MySQL because you don't have to really know databases to use it.
A database administrator will pick Postgres every single time.
We the people are the rightful masters of both Congress and the courts, not to overthrow the Constitution but to overthrow the men who pervert the Constitution. - Abraham LincolnComment
-
Hey, if they want a set of results, what else can they doOriginally posted by alva
Using the DISTINCT command.
?
This is Shireroth, and Giant Squid will brutally murder me if I ever remove this link from my signature | In the end it won't be love that saves us, it will be mathematics | So many people have this concept of God the Avenger. I see God as the ultimate sense of humor -- SlowwHandComment
Comment