MySQL getting bad names

[Anon]

Hey. I was arguing with a hosting owner about this but he said that if MySQL gets big it just doesn't work. Also if your site generates a lot of traffic MySQL shuts down. Ok so can anyone help me figure out the truth here? The guy I was arguing with says that SQL could/and does whoup MySQL. I simply just replied "Microsoft" and that shut him up for like 5 minutes. Well can anyone help me... I am looking for a place to find out if it really does buckle under pressure or if it holds its ground. I don't think this guys right...is he? Thanks!
Ziggs

[brandonschnell]

MySQL beats storing data in text files but is only really suitable for small sites or sites that use SELECT 99% of the time.

take a look at the sites out there on how to tweak mysql. most limit the number of connections and spread out the connections to a number of servers (ie: hotornot.com uses this method last i checked).

to keep things cheap, take a look at using postgreSQL.

I assume you're talking about MS SQL Server. MSSQL is decent for the price. IMHO its one of the most annoying databases i've ever seen. once you get over its quirks its not too bad. Microsoft bought a number of different databases when they got into the market, so the core of it is fine.

[[deleted]]

Yes MySQL does buckle under load, and it will break eventually.

MySQL is very fast with low concurreny and simple queries.

If as you get more concurreny queries, or the queries get more complex, mysql slows to a crawl, and worse; it can die.

PostgreSQL, Oracle and MS-SQL are not as fast with low-concurrencty, and they will slow down too, but they will keep going.

But by far the biggest 'bad thing'(tm) about MySQL is it's complete lack of functionality.

In their race for speed, the mysql dudes took out everything that makes a database usefull, like consistency checks, PK/FK relationships.

That lack of functionality does make what's left very fast, but it also means you have to to 5 times as many queries to get to where you want to be. So where's the advantage?

:-)

Don't get me wrong, I really hate MySQL. It's severely overrated.
Getting better, but still no where near 'an option'.

[interactive]

lol i worked on a site a while back it inserted 5 times on one page and selected like ten and updated a few, mySQL woudl like jack up everytime the script was run...it has some major flaws but its free :-D