Open Source
Developing Code Coverage for MySQL tests
I have always been a strong advocate of good testing of any system. I started on a project last year with Drizzle to produce coverage tests to facilitate verifying syntax and helping in comparison with MySQL.
Read moreA beginners look at Drizzle – Datatypes and Tables
The Drizzle database, while similar to MySQL includes a number of significant differences. In this post we will look at data types and table syntax that is valid in Drizzle. For more background information you can also review A beginners look at Drizzle – Getting around with SHOW .
Read moreA beginners look at Drizzle – Getting around with SHOW
Assuming you have successfully compiled Drizzle , and you are ready to start for the first time, here are some beginner differences with those familiar with the current MySQL 5.1 GA version.
Read moreA Drizzle update – Running version 2009.03.970-development
I’ve not looked at compiling and running Drizzle on my server for the past four weeks. Well overdue time for a check and see how it’s going. I saw in today’s planet.
Read moreExtending vmplot
Taking the work already done with vmplot.sh, a useful tool for MySQL performance tuning by Yves and Matt at BigDBAHead, and in true Open Source fashion I’ve enhanced and modified for my own purposes.
Read moreYour Code, Your Community, Your Cloud… Project Kenai
Following the opening keynote announcement about Kenai I ventured into a talk on Project Kenai . With today’s economy, the drive is towards efficiency is certainly a key consideration, it was quoted that dedicated hosting servers only run at 30% efficiency.
Read moreEverybody is talking About Clouds
From the opening keynote at CommunityOne East we begin with Everybody is talking About Clouds. It’s difficult to get a good definition, the opening cloud definition today was Software/Platform/Storage/Database/Infrastructure as a service.
Read moreCommunityOne East – An open developer conference
With an opening video from thru-you.com – an individual taking random you-tube video and producing video mashup’s, the CommunityOne East conference in New York, NY beings. The opening introduction was by Chief Sustainability Officer Dave Douglas.
Read moreHurting the little guy?
Today I come back from the dentist, if that wasn’t bad enough news, I get an email from Google AdWords titled Your Google AdWords Approval Status. In the email, all my AdWords campaigns are now disapproved, because of:
Read moreUnderstanding the various MySQL Products & Variants
The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL produces. The MySQL server product in general is released under the GNU General Public License (GPL) v2 , however you should carefully review the MySQL Legal Policies {#s0rl} as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.
Read moreInfobright Community Edition(ICE) – It’s Free
The March NY MySQL Meetup featured a presentation from Infobright , a data warehousing solution built on the MySQL Product. With a pitch of “Simplicity, Scalability and low TCO” I became more impressed with the capability to delivery on these as the presentation proceeded.
Read moreEliminating unnecessary internal temporary tables
I can’t stress enough that people look at SQL statements that are being executed against your production MySQL database, and you optimize queries when you can. Often it’s the improvement to the large number of similar queries executed that can optimize resources.
Read moreAnnouncing “MySQL Essentials” Training
Are you having problems getting up to speed on MySQL? Are you asking yourself “Is there a hands-on training course we can send a developer/system admin to learn MySQL?”. In response, at 42SQL we have put together two new training courses, MySQL Essentials and MySQL Operations.
Read moreThe art of looking at the actual SQL statements
It’s a shame that MySQL does not provide better granularity when you want to look at all SQL statements being executed in a MySQL server. I canvas that you can with the general log, but the inherit starting/stopping problems in 5.
Read more