scalability

I am nobody's puppet.

Disclaimer: My blogs are not a reflection of my employer's opinions, but are my own, and often unfiltered. Also, some links on this site may be part of an Amazon Associates program, so by clicking on them you help me pay for my independence.

[[{"type":"media","view_mode":"media_preview","fid":"25","link_text":null,"attributes":{"alt":"Acquia Certified Developer","title":"I am an Acquia Certified Developer","height":147,"width":147,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]] [[{"type":"media","view_mode":"media_preview","fid":"15","link_text":null,"attributes":{"height":180,"width":180,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]] [[{"type":"media","view_mode":"media_original","fid":"13","link_text":null,"attributes":{"height":68,"width":310,"style":"width: 190px; height: 42px;","class":"media-image media-element file-media-original"}}]]

Thanks again, Steve. I hope
14 years 1 month ago
Hi - bit late responding here
14 years 1 month ago
Should have added...
14 years 2 months ago
Hi Ryan,
14 years 2 months ago
Ryan,
14 years 2 months ago
It is happening and you are
14 years 5 months ago
In close future I want to
14 years 8 months ago
the article has been
14 years 9 months ago
I think it's a great coup for
14 years 9 months ago
My hardware box acts as an
14 years 10 months ago

By rprice , 6 September 2012

How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog

Link

http://backchannel.org/blog/friendfeed-schemaless-mysql

However, as we grew, scaling our existing features to accomodate more traffic turned out to be much less of an issue than adding new features.

In particular, making schema changes or adding indexes to a database with more than 10 - 20 million rows completely locks the database for hours at a time. Removing old indexes takes just as much time, and not removing them hurts performance because the database will continue to read and write to those unused blocks on every INSERT, pushing important blocks out of memory.

By rprice , 28 December 2011

MySQL Engines: MyISAM vs. InnoDB | Tag1 Consulting

Link

http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB

In most cases, InnoDB is the correct choice for a Drupal site. It provides increased concurrency, enhanced performance and much more data integrity than MyISAM ever can. However, the pluggable nature of MySQL engines allows the user to "mix and match" table engines inside a single database. This allows us to consider tables whose workloads fit MyISAM more so than InnoDB. The main candidates for MyISAM in a mostly InnoDB-centric database are the search tables.

scalability