Banner Image

All Services

Programming & Development

MySQL Database Design & Optimization

$50/hr Starting at $250

Lead developer on modifications to the core of the MySQL Database server and SQL syntax to support detailed usage reporting. Published in Linux Pro Magazine (http://www.linuxpromagazine.com/Issues/2009/109/ExtSQL). Former Member of the SQL ANSI Standards Committee (DM32.2), Worked with client to stabilize and improve performance of a large MySQL installation supporting 5-10 thousand queries/second and multimillion row tables.

About

$50/hr Ongoing

Download Resume

Lead developer on modifications to the core of the MySQL Database server and SQL syntax to support detailed usage reporting. Published in Linux Pro Magazine (http://www.linuxpromagazine.com/Issues/2009/109/ExtSQL). Former Member of the SQL ANSI Standards Committee (DM32.2), Worked with client to stabilize and improve performance of a large MySQL installation supporting 5-10 thousand queries/second and multimillion row tables.

Skills & Expertise

AirCC++cnmDatabase DevelopmentDesignHTTPInstallation DesignJavaLead GenerationLinuxLinux DevelopmentMagazine DesignMySQLPerformance EngineeringPerlReport WritingShell ScriptingSocial NetworkingSoftware DesignSoftware DevelopmentSolarisSQLTable Design

Related Work Collections

41 Reviews

  • EricF says,

    John thanks for the excellent work and your patiences!

    for Create DB and DB driven website on Oct 23, 2012

  • Scott_Sterrantino says,

    this is my second time using John's skillset, this time to review my configuration file. John does a great job of being clear up front on how he will test the environment, and he fully explains the results.

    for mySQL / Apache stopping on Aug 08, 2012

  • Scott_Sterrantino says,

    john has been a pleasure to work with. He was able to learn my system, fix our speed issues, and teach me what he did in a very short period of time. He understood the need to be minimally invise to our production system and was able to show me a few things I was missing which netted a speed increase of over 50x, as well as tools I was unaware of that will help my efficiency in the future. I was hopeful for an improvement, but I did not expect this much improvement in this short a time. He was true to everything he said from the hours required to the tasks he needed to look at. He even recommended a few books to help me get more up to speed. We are already starting our next project, and John will be my go to guy in the future any time I need help.

    for mySQL / Apache stopping on Aug 06, 2012

  • Brent_Eicher1 says,

    John is exactly the kind of guru we love working with. He is honest, courteous, timely and goes the extra mile. VERY HIGHLY recommended.

    for Fix Paypal IPN Listener on Jul 06, 2012

  • Robert_Goebel says,

    John has a wide range of expertise and knowledge. He is easy to work with and performs all work above and beyond expectations. I would definitely recommend John to anyone needed website work.

    for Website Service on Apr 10, 2012

Sign up or Log in to see more.