Databases
A 5.1 QEP nicety – Using join buffer
I was surprised to find yesterday when using MySQL 5.1.26-rc with a client I’m recommending 5.1 to, some information not seen in the EXPLAIN plan before while reviewing SQL Statements.
Read moreAn intestesting approach to free hosting
I came across the OStatic Free hosting service that provide Solaris + Glassfish (Java Container) + MySQL. They offer “Now you can get free Web hosting on Cloud Computing environment free of charge for up to 12 months.
Read moreGet linked to Drizzle
We are always looking at different ways to help promote, inform and identify contributers, users and supports for Drizzle . One way is to join the Linked In Drizzle group (click here when logged in).
Read moreInteracting with BuildBot using IRC
Using BuildBot for Drizzle has been a great way to help in the verification of the sometimes rapid code changes that are being committed. Curious why the IRC notifier within BuildBot only joined and exited the #drizzle channel in IRC, some further investigation of the IRC Documentation lead to more information to share.
Read moreChoosing MySQL 5.1 over 5.0
I have been asked twice this week what version of MySQL I would choose for a new project. As with most questions in life the answer is: It Depends? In general I would now recommend for a new project to select 5.
Read moreWhat are the best MySQL Design Practices?
Tonight I provided a scope in Best Design Practices for MySQL Applications – Part A of just how much there is to consider with a successful application. I only scratched the surface in some detail, a topic one could easily write a book on, and definitely provide a number more presentations.
Read moreMonitor and Optimize Your MySQL, Microsoft SQL Server and Oracle Databases 24×7.
I came across another MySQL Monitoring product today, DBTuna. I’ve got a trial license of this commercial product so I’ll be looking into its installation, options and support and will be reporting back.
Read moreUsing consistent data types for columns
I came across this error recently when trying to modify the data type of a column. ERROR 1025 (HY000): Error on rename of './sakila/#sql-1d91_5' to './sakila/inventory' (errno: 150) Not the first time, and not the last time.
Read moreExtending application data to the cloud
I was one of the invited panel speakers to A panel on Cloud Computing this week in New York. As one of 2 non vendor presenters, it was a great experience to be invited and be involved with vendors.
Read moreMySQL involvement in OSCON opening keynote
Before I get to post my OSCON reflection I see I didn’t post this (which I reference). At OSCON opening keynotes Tim O’Reilly Interviews Monty Widenius & Brian Aker . This provided some interesting answers in a Q & A session.
Read moreDrizzle needs you
Use MySQL, but want to follow the new kid on the block? Want to help contribute to Drizzle? We are seeking help in compiling across different platforms. Please help us by becoming a buildbot slave .
Read more