'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 […]

  posted in Commentary, Tips & Tricks by mark

• 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 […]

  posted in Tips & Tricks by mark

• 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 […]

  posted in Tips & Tricks by mark

• 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. […]

  posted in Tips & Tricks by mark