Showing entries 40691 to 40700 of 44029
« 10 Newer Entries | 10 Older Entries »
Finding out how far behind are the slaves using Seconds_Behind_Master
New presentation

Last Friday, my mentor from the university came to visit Imtech ICT. To explain him what the project is all about, I gave a short presentation. The presentation contains some of the elements that are also present in the presentation that I posted on the 29th of May, but this new presentation focusses on the project instead of the product.

I'm sorry English readers, this presentation is in Dutch.

The presentation can be downloaded here: Kennismaking

Blog: http://sqlbusrt.blogspot.com/

Project website: http://sqlbusrt.sourceforge.net/

What is a database? (humour)

I'm a big fan of the Working Daze comic, but I certainly hope that this comic is indicative of the majority of our users

read more

All things MySQL Cluster and some that are not

Hello,

Thanks for stopping by.

I have decided to set up this blog in order to collect, catalog, and contribute to, all things related to MySQL Cluster (and some that are not) floating around the web.

Count on this blog to be a clearing house of sorts for any and all information, how-to's, interviews, tips, news, feedback, gossip and happenings as they relate to MySQL Cluster.

I guess I should add the disclaimer that I am the product manager for MySQL Cluster...so I've got a bit of a personal interest in the subject matter.

Check back for additional content in the coming days, weeks and months.

Thanks for your interest,

Jimmy Guerrero
Sr. Product Manager MySQL

How to do efficient forward-only SQL maintenance jobs

I’ve recently written about techniques for archiving, purging, and re-indexing huge database tables. These techniques exploit both data structure and usage patterns. In this article I’ll develop that theme further, and explain how to write more efficient non-backtracking maintenance jobs when the update and insertion patterns permit. Motivation In my current employment, I’ve been optimizing databases for size, speed, and consistency. As part of my regular monitoring, I checked our master MySQL server for deadlock information and found that a nightly cron job’s query had caused other queries to time out or deadlock, then became a deadlock victim itself and died, after loading the server for a long time.

Talking at FrOSCon 2006



I will be at FrOSCon 2006 on June 24, with a talk about Pivot tables in MySQL 5.
I will arrive in Sankt Augustin on June 23, flying from Alghero Fertilia, Italy to Frankfurt Hahn, Germany and then driving to the conference site (travel plan).
The funny thing is that, when I booked my flight, I had no idea that I was about to get in the middle of the Soccer World Cup. Being no soccer fan, I realized this fact only when the media circus started and I could not avoid being informed. Oh, well, now I understand why it wasn't easy to find a hotel, even booking two months in advance!

The slides and the source …

[Read more]
Free Software Magazine blog added to Planet MySQL

I’ve had my blog at Free Software Magazine added the Planet MySQL syndication site.

Digg Runs MySQL

Digg, for those who have been under a rock for the last year, is a technology web site that gives users the opportunity to rank news stories.  Think of it as a combination of social bookmarking and nerdly news.  Digg grew out of founder Kevin Rose's desire for a feature within Slashdot to let users vote on their favorite stories.  Unfortunately, Slashdot couldn't accomodate the feature.  Necessity (or perhaps envy) being the mother invention, Rose created Digg.com.  Digg raised $2.8 million in venture funding from Marc Andreessen, Pierre Omidyar and Greylock partners last year. 

Digg has continued it's rapid growth with nearly a four-fold increase in traffic in just over a year. It's daily page …

[Read more]
Proper way to shutdown a slave
MySQL documentation update - week 24

Documentation is a vital part of any application, proprietary or free software, as it is often the first way to communicate with users about the application or software and how it should be used. I also think it tends to be one of the areas most taken for granted; most users expect it to be there and often forget just how much effort goes into producing it.

Many users also complain about the documentation itself. Often this is because it?s been written by programmers and, as a rule, they really aren?t that great at writing documentation that is particularly human readable.

read more

Showing entries 40691 to 40700 of 44029
« 10 Newer Entries | 10 Older Entries »