When people are comparing databases and trying to select the correct one for their application, it is a very complex and confusing process. There are many factors, price being not the least of these. Some would opt for a closed-source product because of the extra bells and whistles it offers. I have to say that some of these extra features may represent security risks, or simply a database trying to take on functionality better performed at the application layer. There is a certain argument to have all of your business logic embedded in the database as it certainly eases the burden on the application programmers. But it can allow them to become sloppy, or to allow the database to be exposed directly to the users without even an application layer to protect it, counting on the database to protect itself. In some cases this comes at a price, sacrificing speed for security, when some fairly simple application coding could have implemented the same …
[Read more]mysqlreport v3.0 has been released (v2.8 & v2.9 were skipped) which finally has InnoDB reports for MySQL servers v5.0.2 and up. The documentation has been updated accordingly. The new options that invoke the InnoDB reports are –innodb (or -id), –innodb-only (or -ido), and –dpr (for the extra Data, Pages, Rows report).
Since this is the first release with InnoDB reports, feedback on the InnoDB reports is appreciated. Eventually, I’ll update the mysqlreport guide to explain the InnoDB reports. For now, I think the InnoDB reports are self-evident to those who know a little about how the InnoDB …
[Read more]I'm flying back from Alfresco's quarterly management meeting, and looking through some of the data shared by the team. We're just one company in a rising tide of open source companies, so I'm not sure how much to infer from our numbers about open source, generally, but I thought I'd share, anyway. Perhaps the data will be useful for you, too, as you plan your own open source business.
A few points:
-
Lead Generation. Alfresco's website (Downloads/product trials) drives 72% of our leads, and documentation drives another 21%. Cold calls from sales people, direct mail, email, Google Adwords, and other sources you might imagine...almost nothing. To be fair, we don't really do direct mail or email campaigns yet, so it's not surprising that these bring in few leads.
But we found (as SugarCRM and MySQL found before us) that PR, which leads to visits to our website …
Welcome to the 22nd edition of Log Buffer, a weekly compendium of postings and news from database-related blogs across the Internet.
Starting things off with a bang is Peter Zaitsev and his MySQL Performance Blog where he records his observations on a recent set of benchmarks for both MySQL and PostgreSQL. He offers some comments on the InnoDB concurrency scaling issue that some might not be aware of (as indicated in the comments). Dropping in for Database Soup, Josh Berkus also takes a look at the same set of benchmarks in …
[Read more]Ok, so the help wanted slogan on a McDonald’s seems ironically bogus, but here at my new job it really applies. I’m coming up on six months with OmniTI and really enjoy my job. Good pay working for good people, who happen to be looking for even more good people.
There are currently openings for the following:
C developers are especially wanted. There’s good pay, benefits, etc and you work for a really …
[Read more]Brian Kelley has published Log Buffer #22, the weekly review of database blogs, on SQLServerCentral.com blogs. In upcoming weeks, Log Buffer will be published by Sheeri Kritzer on The MySQL She-BA; and by Lenz Grimmer. Read the Log Buffer homepage for more detail and to see how you can get in on the act.
Continuent ships new uni/cluster for MySQL and uni/cluster for PostgreSQL solutions, Continuent (Press Release)
Open-Xchange Announces Partnership with MySQL AB, Open-Xchange (Press Release)
OpenReports Releases OpenReports 2.1, OpenReports (Press Release)
Survey Finds Red Hat Customers Willing To Stay With Company if it Cuts Prices, SeekingAlpha, Eric Savitz (Article)
Mission Accomplished: Do We Need the New OSDL?, Linux Magazine, Bryan Richard (Article)
…
[Read more]Daniel Nichter has released version 3.0 of mysqlreport, one of my favorite tools for quickly comprehending the overall state of a MySQL server. The new version prints out the most important information about InnoDB. It looks like this: $ perl mysqlreport --innodb-only MySQL 5.0.26-standard-l uptime 3 9:57:51 Fri Dec 8 17:29:07 2006 __ InnoDB Buffer Pool __________________________________________________ Usage 1.25G of 1.25G %Used: 100.00 Read ratio 0.002 Pages Free 1 %Total: 0.
Here are some common SQL problems, all of which have related solutions: how do I find the most recent log entry for each program? How do I find the most popular item from each category? How do I find the top score for each player? In general, these types of "select the extreme from each group" queries can be solved with the same techniques. I'll explain how to do that in this article, including the harder problem of selecting the top N entries, not just the top 1.