Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Per Jessen
Daevid Vincent wrote: http://developers.slashdot.org/story/11/07/09/1256241/Facebook-Trapped-In-My SQL-a-Fate-Worse-Than-Death According to database pioneer Michael Stonebraker, Facebook is operating a huge, complex MySQL implementation equivalent to 'a fate worse than death,' and the

Re: MySQL and set complements

2011-07-12 Thread Leonardo Borges
Just now realized I answered to Mike only oops. So posting it again... forcing the use of the use_id index didn't really improve things, unfortunately. Cheers, Leonardo Borges www.leonardoborges.com On Sat, Jul 9, 2011 at 7:24 AM, mos mo...@fastmail.fm wrote: Leonardo, What happens

Re: Schema for Website Comments

2011-07-12 Thread Prabhat Kumar
http://www.ferdychristant.com/blog//archive/DOMM-7QJPM7 On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, Today I need to create a schema for my application website that allows user comments too. I think we have to maintain hierarchical data and it is

RE: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Jerry Schwartz
Let this be a lesson to all of those designers who say That will never happen. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing

Re: Low priority write

2011-07-12 Thread Johan De Meersman
Client C - LOW PRIORITY inserts will always wait until absolutely no other processes are using a table. - Original Message - From: Jon Siebert jon.siebe...@gmail.com To: mysql@lists.mysql.com Sent: Saturday, 9 July, 2011 5:54:58 PM Subject: Low priority write Low Priority Lock

Re: [GENERAL] Schema for Website Comments

2011-07-12 Thread Vibhor Kumar
On Jul 12, 2011, at 7:54 PM, Prabhat Kumar wrote: Today I need to create a schema for my application website that allows user comments too. I think we have to maintain hierarchical data and it is very common as all sites are supporting this feature. Can somebody suggest me some guidelines

Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Peter Brawley
On 7/12/2011 9:45 AM, Jerry Schwartz wrote: Let this be a lesson to all of those designers who say That will never happen. Let this be a lesson to all of those designers who say ''That will never happen' will never happen. :-) PB - Regards, Jerry Schwartz Global Information

Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Hank
Given the choice between doing right the first time, or having the second largest site on the internet, I'll take the latter, and deal with the problems of not doing it right the first time. -Hank On Tue, Jul 12, 2011 at 10:45 AM, Jerry Schwartz je...@gii.co.jp wrote: Let this be a lesson to

MySQL creating empty index?

2011-07-12 Thread Leonardo Borges
Hey guys, I'm working on some performance tuning tasks and realized that there was a missing index in one of my tables so sure enough I added it on my local database with the following sql statement: mysql create index id_idx on users(id); Query OK, 972064 rows affected (36.77 sec) Records:

Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Michael Cole
He is pushing his own products here, Looking at other implications of moving to a NoSQL system I would stay with an SQL system. NoSql has its place, but maybe not in such an environment. http://blogs.adobe.com/asset/2011/04/nosql-but-even-less-security.html Regards Michael Cole. On