IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New More commonly known as MVCC
Multi Version Concurrency Control

[link|http://www.postgresql.org/docs/7.4/static/mvcc.html|http://www.postgresq.../static/mvcc.html]

[link|http://www.google.com/search?client=safari&rls=en-us&q=mvcc+database&ie=UTF-8&oe=UTF-8|http://www.google.co...ie=UTF-8&oe=UTF-8]

I continue to be amazed at mysql's popularity given its limitations and the availability of postgres.



"Whenever you find you are on the side of the majority, it is time to pause and reflect"   --Mark Twain

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."   --Albert Einstein

"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses."   --George W. Bush
New You'd be amazed
Ever seen a large application (backed by MySQL in this case) where every query used exclusively left joins? Guess why? The guy deciding what db server to use only knows one join syntax, and it's LEFT JOIN. Doesn't grasp the performance issues. Doesn't care about the fact that it potentially returns different data. (You can always add "DISTINCT" to the SELECT clause.)

Oh, and doesn't see the need for triggers, stored procedures, or referential integrity constraints, because "real programmers" take care of all that stuff in their code.

Yes, he actually puts down anyone wishing for referential integrity checks as just being lazy. Woo!

(Nah, we don't find corrupt data on a near-daily basis. Why do you ask?)
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New MySQL Gotchas
[link|http://sql-info.de/mysql/gotchas.html|MySQL Gotchas] scary stuff. Here's another that isn't on that list (yet?): Update ... limit ... [link|http://dev.mysql.com/doc/mysql/en/update.html|MySQL update syntax]. The where clause specifies n rows, the limit says (n-x), so x rows aren't updated and you have no way to know which ones. How is that ever a good idea?

Have fun,
Carl Forde
New My favorite quote:
6. Oh yes, this page does not render well in Internet Explorer, run along and get yourself a proper browser.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey

[link|http://it.slashdot.org/comments.pl?sid=134485&cid=11233230|"Microsoft Security" is an even better oxymoron than "Military Intelligence"]
No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link|http://www.eweek.com/article2/0,1759,1622086,00.asp|source]
New Somebody's channeling Peter in 'snarky' mode.
New That postgres link is really useful.
It is very close to the MaxDB documentation. Hmm. I'm getting the idea that multi-versioning databases are letting themselves get walked over by MySQL.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.

New mysql
is the answer to that complex problem of data storage that is obvious and simple and wrong.



"Whenever you find you are on the side of the majority, it is time to pause and reflect"   --Mark Twain

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."   --Albert Einstein

"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses."   --George W. Bush
New That is the question *I* keep asking MySELF.
Why MySQL? Doesn't really work well.

PostgresQL scales much better and can manage much more data with fewer resources.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey

[link|http://it.slashdot.org/comments.pl?sid=134485&cid=11233230|"Microsoft Security" is an even better oxymoron than "Military Intelligence"]
No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link|http://www.eweek.com/article2/0,1759,1622086,00.asp|source]
     Simplistic Database locking. - (static) - (19)
         AFAIK, Oracle is the only one using its model -NT - (ben_tilly) - (2)
             Postgres allows it too -NT - (broomberg) - (1)
                 Does it now? - (static)
         Re: Simplistic Database locking. - (JayMehaffey) - (6)
             The SELECT does. - (static) - (5)
                 Re: The SELECT does. - (JayMehaffey) - (4)
                     It's not an InnoDB table. - (static) - (3)
                         "Including 'THE' other..." ?!? :-( - (CRConrad) - (1)
                             Quite. - (static)
                         That would be a problem. - (JayMehaffey)
         The "Multi-Generational Architecture"... - (CRConrad) - (8)
             More commonly known as MVCC - (tuberculosis) - (7)
                 You'd be amazed - (drewk)
                 MySQL Gotchas - (cforde) - (2)
                     My favorite quote: - (folkert) - (1)
                         Somebody's channeling Peter in 'snarky' mode. -NT - (inthane-chan)
                 That postgres link is really useful. - (static) - (2)
                     mysql - (tuberculosis) - (1)
                         That is the question *I* keep asking MySELF. - (folkert)

Almost, but not quite, entirely unlike tea.
107 ms