The latest from the MySQL community

A picture says it all. Special offers at a FrOSCon books booth.
For how long is an IT book in its prime?

Could it have been the close up cameras?  Hmmmm....

• NBC: Olympic Volleyball Photo Gallery

Caching Business Logic in the Database

I had this relatively simple idea of storing conditions in the database. The idea is to store the condition of the if-then-else from your code in the database. While this will add (slightly) more space to the database, I hope that it will do away with processing the data over and over again as well as help drastically speed up searches and any analytical processing you would like to do in the future. I will try to explain with an example..


Story:
You run an electronics store and you have sales people working in that store. You would like to give a bonus incentive and you decide that the rules for the bonus would be the following:
1) Sales people that sell more then average amount of money each for at least 15 days out of a month will receive a bonus. After a bit of calculation you …

This is the third post in the weekly series "Last Week in Drizzle" where we summarize the efforts of various folks in the Drizzle community over the past week. This edition covers Aug 18th through the 24th. As with the week before, a number of developers and community advocates continue to refactor the code base, come together in discussions on the mailing list, and brainstorm on how to solve the tough problems that Drizzle is trying to address. It sounds like many in the community have been swamped this week, but there's still plenty to report. Jay Pipes and myself are tag teaming Last Week in Drizzle.

Continued Growth in the Drizzle Community

Drizzle mailing list has 191 members, up from 148 last week As I type this, there are 42 folks hanging out on the #drizzle Freenode …

This is the third post in the weekly series "Last Week in Drizzle" where we summarize the efforts of various folks in the Drizzle community over the past week. This edition covers Aug 18th through the 24th. As with the week before, a number of developers and community advocates continue to refactor the code base, come together in discussions on the mailing list, and brainstorm on how to solve the tough problems that Drizzle is trying to address. It sounds like many in the community have been swamped this week, but there's still plenty to report. Jay Pipes and myself are tag teaming Last Week in Drizzle.

Continued Growth in the Drizzle Community

Drizzle mailing list has 191 members, up from 148 last week As I type this, there are 42 folks hanging out on the #drizzle Freenode …

I attended several events in June of this year including Graphing Social Patterns East, Velocity and Structure 08. At each of these events, I tried to take some notes and posted them to my personal blog. I received a few pings from readers of this blog to point them to a list of these posts. It took some time but here is the list of my notes. In some cases, I have linked directly to the presentation files.

High-performance Ajax Applications: Julien Lecomte (Yahoo!) talked about how to …

Yesterday I helped someone who was seeing a lot of "server has gone away" error messages on his website. While investigating this problem, I noticed several things amiss, which appeared to be related but really weren't. The biggest measurable sign was

PLAIN TEXT CODE:

1. [percona@server ~]$ mysqladmin ext | grep Abort
2. | Aborted_clients                | 14835        |
3. | Aborted_connects               | 15598        |

These two status variables are actually unrelated (see the manual page that explains them). The first was related to the errors the client was seeing: the server was closing inactive connections after a while, and I fixed it by increasing the wait_timeout …

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). You will already see a few MySQL die hards, but also the need breed of names that are part of Drizzlemania.

I recently purchased a new Dell 1525 laptop running Ubuntu 8.04. I've been in need of a new laptop for about a year, and decided to take the plunge and see how good a Linux based laptop from Dell really is. My needs are fairly modest. I'm not a gamer, and don't watch many videos. Mainly it's used for blogging, internet, OpenOffice, IRC/IM, listening to podcasts and programming. Portablity is only somewhat important, mostly it'll be used 80% on a desk with the remaining time mobile.

Model: Dell Inspiron 1525N
Price as reviewed: $749
CPU: Intel Core 2 Duo T7250 (2 Ghz/800 Mhz FSB/2MB Cache)
OS: Ubuntu 8.04 with DVD playback
Screen: Glossy 15.4" widescreen (1280x800)
…

I recently purchased a new Dell 1525 laptop running Ubuntu 8.04. I've been in need of a new laptop for about a year, and decided to take the plunge and see how good a Linux based laptop from Dell really is. My needs are fairly modest. I'm not a gamer, and don't watch many videos. Mainly it's used for blogging, internet, OpenOffice, IRC/IM, listening to podcasts and programming. Portablity is only somewhat important, mostly it'll be used 80% on a desk with the remaining time mobile.

Model: Dell Inspiron 1525N
Price as reviewed: $749
CPU: Intel Core 2 Duo T7250 (2 Ghz/800 Mhz FSB/2MB Cache)
OS: Ubuntu 8.04 with DVD playback
Screen: Glossy 15.4" widescreen (1280x800)
…