addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

MySQL 5.6 improvements in Query tuning

  • Oct 30, 2013 · 6:15 PM

We have a special guest speaker in Dave Stokes, MySQL Community Manager in town, and he is going to talk about MySQL 5.6 features for tuning, performance and scaling.  There are several new features including explain for DML statements, optimizer trace as well as visual explain tools with MySQL workbench.

Thanks to ERANYC who is again hosting us.


6:15am  Meet and Greet

6:30pm  Presentations Starts

7:30pm  Q & A

About Dave:

Dave Stokes is a MySQL Community Manager for Oracle and previously was the MySQL Certification Manager.  Before that he has worked at companies ranging alphabetically from  the American Heart Association to Xerox on projects that range from chasing submarines to world wide foot court cash and sales. 

Join or login to comment.

  • A former member
    A former member

    Regarding conversation last night re: sync and fsync, background at . MySQL official position at, and says:

    "fsync operations must run on each open table rather than on a single file. Because there is a separate fsync operation for each file, write operations on multiple tables cannot be combined into a single I/O operation. This may require InnoDB to perform a higher total number of fsync operations."

    Anyways, innodb_file_per_table enabled by default in 5.6 - answers the question I was asking.

    1 · October 31, 2013

  • A former member
    A former member

    Definitely great talent, Q&A. We really didn't talk about query tuning much, however, due to technical dificulties

    October 31, 2013

33 went

Our Sponsors

  • Webair

    20% discount on all hosting packages.

  • Grovo

    Providing hosting of the NY MySQL Meetup

  • MariaDB

    Providing sponsorship to our meetup group.

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