Performance 101 for Small Web Apps

Jens Bollmann (SkySQL AB)
Average rating: **...
(2.00, 1 rating)

Handling application growth in the early days of a project does not necessarily require jumping straight into replication, sharding or the cloud. Many small or budget operations don’t have administration level access to their MySQL server and possess very finite resources.

With a few simple development techniques and rules of thumb for web app tuning, you may get an extra few years out of your shared hosting or single/dual server environment. We’ll look at:

  • Find an app’s bottleneck and solve it from the application side or the server side.
  • Quickly find your slow queries without access to the slow query log, and apply a few common tactics for tuning them.
  • Solve the pagination scaling problem, or: “How to browse large amounts of data the smart way”.
  • Get familiar with cool MySQL specific SQL functions that you may not have got around to trying out yet.
  • When to use external caching solutions like memcached, and how to tell what data is worth caching in the first place.
  • When to commit sins in the real world: De-normalizing your schema, using way to many queries per page request and lying to your users.
  • Understand query concurrency and locking issues on the server, and how to avoid such problems.
Photo of Jens Bollmann

Jens Bollmann

SkySQL AB

Jens is a principal trainer and consultant within the Professional Services group at SkySQL. Prior to SkySQL, Jens was a Senior Consultant at MySQL and Principal Instructor at Sun Microsystems and ORACLE. Joining MySQL AB in 2005 and working internationally serving many large enterprise customers and well known Web 2.0 companies he delivers all MySQL related training. He has undertaken performance tuning, assisted with database design and configuration, MySQL-Cluster and other HA solutions.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts