Tuesday, May 26, 2009

Texans - learn to tune your MySQL Servers

Brian Miezejewski will be presenting at the North Texas MySQL Users Group on June 1st on performance tuning on your system. Brian is a top-level tuning guru and this is your chance to get an expert to examine your system.

So on your system, run the following:

mysqladmin -u -p va >varis.txt


Then during your peak usage time (if possible):

mysqladmin -u -p ex -i 15 -r >stats.txt


Let it run for 10 minutes before hitting ctrl-c to kill it. Bring in the varis.txt and the stats.txt files for tuning and review.


Meeting: June 1st
7:00 PM
Sun Offices
Suite 700
16000 Dallas Tollway
Dallas


NorthTexasMySQL.org

Changing Testing Partners from Pearson VUE to Prometric

As part of integration with Sun Learning, MySQL Certification will be moving from using Pearson VUE to Prometric as our testing partner. July 31st, 2009 will be the last day that candidates will be able to take exams or use MySQl exam vouchers at a Pearson VUE test center. Those with outstanding exam vouchers that they can not use by July 31st, 2009 should contact certification@sun.com for an exchange.

Tuesday, May 12, 2009

Cluster presentation -- Richardson, Texas

The kind folks at The Dallas PHP/MySQL Users Group have asked me to repeat my 'MySQL Cluster -- a gentle introduction' presentation tonight at their meeting. This was after sitting through the original performance where I talked about how to set up complete cluster on a laptop. The presentation has been updated to reference Cluster 7.0 and the demo will work now that I have static IP addresses figured out with Virtualbox. So you know where to be if you are in the DFW Metroples and are not watching American Idol tonight.

The presentation in PDF format is available on NorthTexasMySQL.org

Tuesday, May 5, 2009

DataBox from ReportMill

Last night at the North Texas MySQL Users Group meeting, Jeff Martin from ReportMill.com showed off their DataBox tool.

This is a Java based tool for developing rich Internet applications. It has the hooks to create MySQL databases and link the data to applications. Jeff demonstrated creating tables from scratch, importing files into a database, and then using that data in a full function application that took a very shot time to create. It is much faster than compatible frameworks and features a rich set of Java enhancements for effects.

So if you quickly need to get from raw data to full application, check out DataBox.