'Tips & Tricks' Category

  • You upgraded to > 5.1 but did you turn on performance_schema?

    July 26, 2013

    If you’ve upgraded from MySQL 5.1 to a newer version (5.5?  5.6? 5.7?)  Mark Leith shows you why you should turn on performance_schema. Roland Bouman gave us Common_Schema to help improve the SQL user experience.   Mark now lets us look inward at the IO latency to improve the system. Mark has developed a great set of views and procedures to work with performance_schema that can […]

  • Developer Tips using MySQL

    April 19, 2010

    I get ask, by application developers,  “how do you optimize MySQL”.  I do lots of things that don’t really relate to a developer. I analyze the percent of queries are being pulled from cache for instance.  What a developer can do to optimize the SQL they develop is a different questions.   So here is a […]

  • Compiling Drizzle on CentOS 5.4

    April 6, 2010

    I was able to compile Drizzle on CentOS today thanks to Neil Armitage post on his website. Clean install centos 5.4 with Development Tools and Development Libraries yum groupinstall “Development Tools” yum groupinstall “Development Libraries” Setup the drizzle user account and allow it to sudo /usr/sbin/visudo uncomment %wheel ALL=(ALL) NOPASSWD: ALL useradd drizzle gpasswd -a […]

  • The OpenArk Kit

    March 25, 2010

    Shlomi Noach is DBA,  authorized MySQL instructor software developer and Winner of the MySQL Community Member of the Year, 2009. He has published his own collections of MySQL scripts and you might find them useful.  Shlomi calls them the “openark kit“. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. […]


Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.