6/26 [ Kinney's drivel deleted. ]
\_ Does MySQL really do transactions, ACID, etc now?
anyone have a URL handy? --oj
\_ No, MySQL is not presently ACID compliant. That's why you
can corrupt MySQL databases if you throw enough traffic at
one. They just moved their transaction code into the stable
release. Don't know if it's usable yet though.
\_ Its not. Our 'database' guy is a rabid MySQL fanatic and
had us use it in our project (instead of PostGres which
I wanted to use). The transactions code is turning out to
be the cause of a lot of our problems. We will probably
switch to PostGres in the next version.
\_ From what I read the corruption problems were due to
real multiuser env where multiple insert and update
statements clouded the water.
\_ Yup, that's the problem. MySQL "forgets" to do
some inserts and updates. We got about 5 daemons
reading network and system state and trying to
populate the db with this info and sometimes
stuff doesn't show up, but the db says everything
is okay. It really sucks.
My application having only read rights should not be
affected; but then again who cares- my master data file
is still maintained on my local computer and used only
by me. I do an update once and month on my local copy
and publish the new tables out to the network.
\_ Will MySQL ever have transactions? I thought the point
of MySQL was that it wasn't a real database, just a fast
data source that could understand SQL.
\_ Anyone who runs something they really care about with
either Access or MySQL is asking for what they'll get. They
each have their uses, but so does Excel for that matter.
If you want a real database, then use a real database like
MS SQL Server, Slimebase, Informix, Oracle, or the like.
Postgres/Ingres is about as good as its going to get for the
"freeware" camp, and in fact we use it here to catalog
near-earth objects and (in another application) store
GPS data. Rock solid. --dim
\_ No Kinney, I don't wonder. If I'm curious, I read the
New York Times and the Christian Science Monitor (both
available free online). Add in a dash of The Economist
and a liberal paper (insert SF Guardian or Village
Voice here) to balance it out, and a grain of salt to
account for the ridiculous conservative bias in one and
the loony liberal bias in the other and you come out
pretty well informed.
\_ wow. Tell your boss he is a moron and he shouldn't be making
these decisions. Do what is right (PostgreSQL) and then if
you get fired be GLAD that you now will get a tiny bit of money
on unemployment while you dick around before getting another job
which you obviously need to do anyway.
( If this database will really stay like it is now forever, then
yes, mysql is great).
(Also, ignore the person who said (point 3) that Oracle is faster
than MySQL. That person is either a moron, or he typod).
Finally, to answer another deleted question, MySQL does NOT support
sub-queries. (very annoying and another reason to run Postgres).
One thing Mr. point #3 is Right about is that you should never even
consider running Access. (so much for "Finally")
\_ No, really, Oracle is significantly faster than MySQL.
- Mr. Point 3
\_ MySql is faster on simple selects. But when you run join
join queries of many tables, mysql slows down significantly.
\_ Does MySQL really do transactions, ACID, etc now?
anyone have a URL handy? --oj
\_ No, MySQL is not presently ACID compliant. That's why you
can corrupt MySQL databases if you throw enough traffic at
one. They just moved their transaction code into the stable
release. Don't know if it's usable yet though.
\_ Its not. Our 'database' guy is a rabid MySQL fanatic and
had us use it in our project (instead of PostGres which
I wanted to use). The transactions code is turning out to
be the cause of a lot of our problems. We will probably
switch to PostGres in the next version.
\_ godamn i missed this one before it was purged. Pray tell it
wasn't about h07 4zn ch1x?
\_ D00D U N33D 2 134RN 2 5P311! 175 42N ! 4ZN!
wasn't about H07 42N CH1X [ 5P3111NG C0RR3C73D ]
\_ I hope it becomes standard MOTD policy that Kinneydrivel(tm) is
automatically deleted.
\_ I hope so too.
\_ Solidarity, man.
\_ Oh my god, you deleted kinney! You bastard!
\_ what's the average lifetime of Kinney's drivel?
\_ 3-5 minutes
\_ Are you on drugs? Do you even know what the ASP model is? This
is the most nonsensical discussion I've ever seen.
\_ Please ignore kinney, he is something I like to call a
'blazing moron.'
\_ I think "ASP" means something different to most people than
what it means to you.
\_ Please ignore kinney, he is something I like to call a
'blazing moron.'
\_ goddamn it stop censoring kinney. Kinney you must share
your wisdom with the world. Put it all on a web archive
or something.
\_ you guys are fast. did you write an automatic kinneydrivel filter?
i actually enjoyed the last two drivels.
\_ yeah, i've yet to see any at all. someone got a repository of it?
\_ I guess I happened to view the motd at the right moment and then
immediately deleted it. Knee-jerk reaction I guess =)
\_ Hey, this was the first one that wasn't drivel.
\_ wasn't the post signed by psb? and yes, it was total drivel
and completely random question that didn't follow from
the story.
\_ i'm gonna keep putting drivel in motd.kinney even if it might
be fake kinney. making fake drivel is pretty lame anyway so
i'm gonna hope no one bothers.
\_ Did we read the same post? The one I read was a question
about transmission limits imposed on communications equip.
by the FCC as it related to a new technology. It seems to
be a non-drivel question.
\_ I thought it was cute. Why'd you purge it? I was going to have
some fun with it. |
http://csua.com/feed/