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 Wednesda

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: 9720

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 wrote: > Let this be a lesson to all of those d

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 Incorpor

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 guidel

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" > To: mysql@lists.mysql.com > Sent: Saturday, 9 July, 2011 5:54:58 PM > Subject: Low priority write > > Low Priority Lock > > Hello was won

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 Mailin

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 wrote: > 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 very common as all

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 wrote: > Leonardo, >What happens when you use "fo

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 t