recentpopularlog in

mcherm : mysql   5

MySql: Do Not Pass This Way Again » The Codex
This author does an extremely thorough job of explaining why MySQL is a terrible tool and should be avoided at all costs.
rant  database  mysql  via:HackerNews 
january 2013 by mcherm
Help:Short words in searches - Meta
How to make MediaWiki do searches even of short words (like 3-letters).
wiki  mysql  INGDirect 
april 2009 by mcherm
How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog
An interesting approach to storing large amounts of data. They use MySQL but *not* as a RDBMS... they use it only for its sharding and other scalability features. The data is stored as opaque blobs. Separate background processes build indexes. The indexes are permitted to be inaccurate... results get re-filtered after being retrieved and a background process runs around constantly trying to correct erroneous index entries.
scalability  programming  database  mysql 
february 2009 by mcherm
Fulltext Search - Eventum
We currently can't search our MediaWiki installation for words of 3 or fewer characters. This explains why and how to fix it.
mediawiki  mysql  search 
november 2008 by mcherm
Scaling Out | Engineering @ Facebook's Notes
When Facebook wanted a second data center with its own DB, how did they need to change their application? (1) make one DB read-only and replacate from the main datacenter; modify MySQL to clear memcache on replication. (isn't open source cool?) (2) all pages doing edits go to main data center. For the first few seconds after a user makes a change, send that user to main data center as the other may still have the old value.
scalability  JasonSobel  memcache  opensource  mysql  mypostings  concurrency  parallelprogramming  via:DebasishGhosh  programming 
august 2008 by mcherm

Copy this bookmark:

to read