Aaron Parecki

#mysql

• Troubleshooting Memory and Networking Issues (library.linode.com)

  Sat, Sep 17, 2011 9:16am -07:00 #apache #linode #memory #mysql #optimizing #troubleshooting
• High Availability and Scalability MySQL (dev.mysql.com)

  Thu, Aug 18, 2011 2:35pm -07:00 #cloud #high-availability #linux #mysql #scaling
• MySQL Explain Output (dev.mysql.com)

  Sun, Jun 19, 2011 7:35pm -07:00 #mysql #optimization
• Joins are fast (stackoverflow.com)

  Joins are fast. Joins should be considered standard practice with a properly normalized database schema. Don't fear the join. It's true that join performance degrades non-linearly as the size of the data set increases. Therefore, it doesn't scale as nicely as single table queries, but it still does scale. It's also true that a bird flies faster without any wings, but only straight down.

  Sun, Jun 19, 2011 6:32pm -07:00 #databases #JOIN #mysql #scaling
• Flickr Architecture (highscalability.com)

  Sat, Jun 18, 2011 10:04pm -07:00 #flickr #mysql #php #scaling
• MySQL Slave Lag (Delay) Explained And 7 Ways To Battle It (beerpla.net)

  Sun, May 15, 2011 11:48am -07:00 #databases #mysql #scaling #servers
• What to tune in MySQL Server after installation (www.mysqlperformanceblog.com)

  Sat, May 14, 2011 7:37am -07:00 #mysql #scaling #server
• How We Made GitHub Fast (github.com)

  Tue, May 10, 2011 5:15pm -07:00 #apache #architecture #infrastructure #mysql #ruby #scaling
• Hybrid Incremental MySQL Backups (www.facebook.com)

  Tue, Apr 5, 2011 12:49pm -07:00 #database #facebook #infrastructure #mysql #scaling #systems

• How To Monitor MYSQL Replication In Real Time With SNMP

  Fri, Dec 24, 2010 10:31pm -08:00 #linux #monitoring #mysql #replication #server
• Innodb Performance Optimization Basics (www.mysqlperformanceblog.com)

  Sun, Dec 19, 2010 11:00pm -08:00 #mysql #optimization #server
• 

  Solid comparison of SQL vs NoSQL happening at #nopoconi by @CastIrony and @TylerGillies #couchdb #mysql

  Overlook, Portland

  Mon, Oct 18, 2010 8:32pm -07:00 #nopoconi #couchdb #mysql
• Code: Flickr Developer Blog » Ticket Servers: Distributed Unique Primary Keys on the Cheap (code.flickr.com)

  Mon, Oct 11, 2010 11:46pm -07:00 #architecture #database #flickr #mysql #performance #scaling
• MySQL :: MySQL 5.1 Reference Manual :: 5.1.6 Server Status Variables (dev.mysql.com)

  Fri, Oct 8, 2010 11:40am -07:00 #database #mysql #performance
• InformIT: Optimizing and Tuning Your MySQL Database > MySQL Startup Options (www.informit.com)

  Fri, Oct 8, 2010 11:07am -07:00 #database #linux #mysql #performance #sysadmin #tuning
• Maatkit documentation: a toolkit of utilities and tools for MySQL (www.maatkit.org)

  Mon, Oct 4, 2010 11:54pm -07:00 #database #mysql #optimization #performance
• High Scalability - High Scalability - Scaling Digg and Other Web Applications (highscalability.com)

  Mon, Oct 4, 2010 10:57pm -07:00 #application #architecture #database #development #mysql #programming #scalability #scaling
• How Digg.com uses the LAMP stack to scale upward - Computerworld (www.computerworld.com)

  Mon, Oct 4, 2010 10:51pm -07:00 #architecture #lamp #mysql #php #scalability
• How to Scale WPMU « WordPress Codex (codex.wordpress.org)

  Sat, Jul 3, 2010 6:17pm -07:00 #blog #mysql #scalability #scaling #wordpress #wpmu
• Quora - Why does Quora use MySQL as the data store rather than NoSQLs such as Cassandra, MongoDB, CouchDB, etc? (www.quora.com)

  Wed, Jun 30, 2010 12:28pm -07:00 #database #development #facebook #mysql #nosql #scalability