addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

PHP Meetup @ NC State - Presentation: Renormalize-Solving performance problems

  • Oct 25, 2011 · 6:30 PM
  • NC State Campus. Hillsborough Building

Doors open at 6:30
Presentation at 7pm

Location: NC State Campus. Hillsborough Building
Address: 2620 Hillsborough Street
Room: B16 Conference room
Google Map:


"Renormalize - Solving Performance Problems in MySQL Without Denormalization" - by Ari Weil, Product Manager of Akiban Technologies

As operational database schemas become complex, users resort to denormalization to handle performance issues. This includes a range of techniques from materialized views to using MySQL as a key-value store for blobs containing full objects. While denormalization solves immediate bottlenecks, it comes at a hefty price. In this presentation Ari will explore common denormalization approaches and tradeoffs using real world examples. He will then present a solution under development at Akiban Technologies to alleviate these same problems much more efficiently, and allow users to get the best of both worlds.


Parking is available on Hillsborough street and the surrounding side streets. There is a parking lot behind the building off of Gardner street, but it is a 24-hour NC State Permit Only spot, so you could get a ticket if you park there without an NC State Permit. However, there is usually plenty of parking around. There is a non-ticketd NC State Parking lot (Brooks lot) that is at the corner of Hillsborough and Brooks Ave ( You can park there any time after 5 with no problems.

Meet Up Location
The conference room is in the basement of the Hillsborough building, which has automatic locks. The best way to get there is to go to the back of the building and down the back steps (they look scary, but they are actually OK). I'll probably post a sign or two to direct people. Somebody will be there to let you in.  After 7pm, you will need to contact (call, text message) either Bryan Pearson (me) at[masked] or Jason Austin at[masked] to be let in.

Please consider volunteering to moderate, present or give a tutorial. Contact Bryan or Michael to sign up.

If you arrive at the door is closed, or you cant get in, you can text message/call either Bryan Pearson (me) at[masked] or Jason Austin at[masked]-1708.

Refreshments will be served - donations are accepted.

Please RSVP on Meetup, as we need to make sure we have seating and enough refreshments available.

Join or login to comment.

  • A former member
    A former member

    Great topic. Akiban looks like it might be useful to my company, I look forward to trying it out.

    October 26, 2011

  • Jason A.

    Great topic. We need more like this. Very informative and gave me some takeaways.

    October 26, 2011

14 went

  • Bryan
    Event Host
  • Jason A.
    zend framework guru, Co-Organizer
  • A former member
  • A former member
  • A former member
  • A former member
  • A former member
  • A former member
  • A former member
  • A former member

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy