PHP Meetup @ NC State - Presentation: Optimizing MySQL Configuration

This is a past event

28 people went


Doors open at 6:30
Presentation at 7pm

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


Optimizing MySQL Configuration

MySQL's configuration file is often the focus of too much attention, and too much tweaking of variables that make no difference -- or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You'll learn a practical approach to generate a sensible configuration file that sets what's needed and omits what isn't. The result will be a more stable and performant server that's resistant to many common problems.

Pre-Meetup 5pm-6:30pm

Mitch's Tavern,

2426 Hillsborough Street
Raleigh, NC[masked]

We suggest you park at the meetup building (the Hillsborough building) and walk to Mitch's, as its very close by.

Percona, is sponsoring pizza:

Peter Zaitsev
Founder and CEO, Percona

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

About Percona:
Experts in MySQL and InnoDB Performance.

Percona is the oldest and largest independent MySQL support and consulting company, with a global 24x7 staff serving more than 1,200 customers in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity.

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].

Refreshments will be served - donations are accepted.

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