Ideas, releases, practical guides, and perspectives from the people building with MySQL.
After last week’s post on agents versus agentless monitoring systems, I got a lot of email. One, from a customer whose name I am not permitted to mention, sent me the following action shot (posted with permission):
Over half a gigabyte; more than twice what MySQL itself is using. So, that raises an interesting [...]
With most large sets of data, especially numerical data, statistical analysis plays a key role. You can't be bothered to look at every record yourself; that's what computers are for.One useful tool in any statistical analysis is the identification of outliers. Assuming you have a normally distributed set of data, outliers can help to identify user error in the data entry process, or genuine spikes in the data. Once found, these numbers can be set aside for closer analysis or eliminated to normalize the data set.There are many different methods for identifying outliers, with varying levels of rigor. Here I'll just demonstrate one of the simplest definitions: an outlier is any value greater than three standard deviations away from the mean. ...
Sun Microsystems founder and Chairman talks about open source and the unification of Unix READ MORE
Robin just wrote a new article, titled A Quick Look at MySQL 6.0’s New Backup, and I thought, that maybe you’d like to also see this in presentation/video format…
At OSCON, Giuseppe actually gave a quick talk at the Sun booth, about our online backup. He also showed how to use it. All examples there, were done with the test-db sample database.
(MySQL Online Backup in Practice, video if the
above doesn’t appear)
We timed our Use Case Competition to coincide with summer holidays, and are now prolonging the duration of the Use Case Competition with one month, until 30 September 2008.
To recap, here’s the original posting (with an updated deadline):
With 5.1 having officially been in Release Candidate status since September 2007 and soon approaching GA status, the MySQL Community Team launches a competition for the users of new features of MySQL 5.1:
Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 30 September 2008 and have a chance of winning one of our prizes:
This book is just "too" popular ;-) It took a bit of jiggling
with Amazon's stock levels (they say in-stock but if you
order some quantity it'll delay the shipping, then you can tweak
down and find out ;-), as well as a deal with the friendly people
at Australian book distributor Woodslane, but Open Query can now
offer anyone who participates (either an open course or custom/in-house training) in one or more training
days between now and the end of this year a copy of High Performance MySQL (2nd edition).
You can also see this as an offer that benefits you directly
rather …
September 16, 10:00 am PST, 1:00 pm EST, 18:00 GMT
I'm proud to inform you that I will be hosting a MySQL Workbench
Webinar, September 16. You can find the announcement right here.
I have spent quite a deal of time testing MySQL Workbench. Thanks
to the hard work of the MySQL
Developer Tools Team, the tool just becomes better and better
each new build. Personally, I think it is high time to present
its features and benefits in a web seminar, and when Giuseppe
asked me to do it, I was more than happy to oblige.
I'll shortly post an outline of some of the key features I will
be presenting. Most likely, I'll address a number of issues I've
seen recurring on the …
As part of a project of Technocation, Inc I took a whole bunch of videos at OSCon 2008. The conference was about a month ago, and about 2 weeks ago I’d finished processing and uploading all the videos, but it was only today where I had the 5-6 hours I needed to finish posting all the video, and making this matrix of video.
The video may not be the quality that the O’Reilly folks took and put up on blip tv’s OSCon site, but all the videos here are freely downloadable or playable in your browser.
Recently I added the first code to support multiple MySQL backends in HSCALE (see svn.hscale.org). As a “side note” I have to thank Giuseppe Maxia for MySQL Sandbox which made multi server testing a bliss!
While coding this I started to feel that writing HSCALE on top of MySQL Proxy is no more as easy and clean as it started out to be. And finally I reached the point where I have to say:
HSCALE (and maybe other advanced multi-server applications) and (current) MySQL Proxy don’t fit very well.
Before I go into details please let me make clear that this is mostly due to the specific nature of MySQL Proxy being a connection and protocol based proxy. MySQL Proxy is great and there are a lot of cool applications that fit perfectly with it.
Aside from some other minor glitches (like …
[Read more]I have not said much about Drizzle here; that is because there is not much to say. It is premature, really, to say anything about it at this point. Some have said they will support Drizzle; as Pythian supports several database systems, it is very likely that we will support Drizzle as well. Particularly since there is in-house Drizzle expertise already. But I digress; my point is that it is premature to really say much about Drizzle.
My involvement in Drizzle goes back to around the end of April/beginning of May 2008. Given my early involvement, (more…)