Anyone know why Mysql is a Big piece of Shit ?
 

Anyone know ??

we use it. we love it

mysql is cool until you start hitting it 500k times a day

Then ya gotta go for Oracle, If you can afford it...

MySQL is really pretty cool when used right...I just hate that people call it so many different fucking things.

My S-Q-L
My sequal
My cycle
My cicle
Miscle

I'm like, "Dude, I don't care about your cycle!"

how do mre makaa thje hun?

Really? Maybe you were running an old version or hadn't tweaked the config files? We run close to 200 querys/second =~15 million querys/day with a 0.5 load on the DB server, mostly simple n+1 UPDATEs and INSERTs though.

mysql is great expect you don´t know how to tweak it or you have a weak database layout.
some heavy loaded sites use it without any problems. Even if you get a very high load you can use the replication features and split the load on different database servers.

PEBKAC



------------------
ah you have been blessed with 72 virgins?

at ~400 req/sec
( insert user ip , borwser lang, referer)


last pid: 1696; load averages: 0.16, 0.18, 0.21 08:33:26
22 processes: 21 sleeping, 1 on cpu
CPU states: 91.9% idle, 3.7% user, 4.3% kernel, 0.2% iowait, 0.0% swap
Memory: 4096M real, 3109M free, 52M swap in use, 7435M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
307 root 12 58 0 54M 43M sleep 249:41 6.43% mysqld-aw

runns nice http://bbs.gofuckyourself.net/board/smile.gif


------------------
ah you have been blessed with 72 virgins?

Both S-Q-L and Sequel are the truth pronounciation, this funny different was made by IBM and Microsoft about 10 yrs ago.

Mysql is the great database server. The most important thing is it's free so it can't do something cool or gives the best efficiency like some expensive dbs. But it still great for us who use it only on the internet.

Some unprofessional table design and/or script coding will cause the db down as hell. So before you purchase a script or hire some programmer, ask them if they're a professional.

100% ACK

mysql is nice for 'smal to medium ' project's

most problem is that some guy's getting php and mysql onthe server ...
coding ( pasting ) a 3 line phpscript
into the htmlfiles ...
and NOW the guy is not more a webdesinger he is NOW A webprogrammer and database admin.

then he start to make tables like
create table website (htmlcode longtext)

and later on the site select ...

dynamic pages http://bbs.gofuckyourself.net/board/smile.gif
but the best is the own searchengine !
select * from website where htmlcode line '%key%'

OK now mysql suxx http://bbs.gofuckyourself.net/board/smile.gif




------------------
ah you have been blessed with 72 virgins?