Showing entries 11 to 13
« 10 Newer Entries
Displaying posts with tag: refactoring (reset)
A Faster MySQL Database Size Google Chart

Abstract - As described by Walter Heck, MySQL database size can be visualized using Google Charts. With a minor code improvement the URL for the chart can be obtained twice as fast. With some more modification, the number of lines can be cut down resulting in a function that is half as long.

Hi!It's been a while since I posted - I admit I'm struggling for a bit to balance time and attention to the day job, writing a book, preparing my talks for the MySQL user's conference and of course family life.

A month ago or so I …

[Read more]
Refactoring MySQL Applications: Part 1

First off, let me wish you all a Happy 2009, and my apologies for being a bit slack with blogging in the last two months of 2008. It’s been a bunch of busy weeks, but I’m fully expecting to remedy that in this year.

Second, let me welcome you to this series on refactoring MySQL applications. I will cover best practices and useful tips, as well as show working examples of potential loopholes and solutions.

So, you are a DBA or a developer, and you’re faced with a problem. Your years-old application (perhaps you inherited it from a former co-worker) is now starting to keel over, and your choice of responses is limited.

Let’s start by saying that there are other ways to reach performance, but in some cases refactoring may be the only way that is possible to pursue, for one reason or another. Let’s take the refactoring way, focusing on SQL rather than applications, as there’s a lot that can be done on this side. …

[Read more]
Thoughts and MaxDB and MySQL

Do note: This is my personal blog, and all thoughts expressed here are my own, and are not necessarily shared by my employer.

So... I was talking with my cohort, Ulf about the future of MySQL and MaxDB.

He got me thinking about what the relationship between MySQL and SAP/MaxDB really is. What does the "partnership" mean a few levels below the VP?

To me, it means that, going forward, I expect to see a lot of communication and camaraderie between the MySQL and MaxDB developers. I expect to see a lot of MaxDB's rock solid, tried and true code become shared libraries which are then linked against by MySQL. I expect to see a lot of MySQL's tools that provide the usability and simplicity that the community has come to expect from them generalized in such a way that they can be used to administer a MaxDB system. I expect to see MaxDB adopt …

[Read more]
Showing entries 11 to 13
« 10 Newer Entries