Note: My views are just that: mine.

1. Real time Query Monitoring

MySQL 5.0 GA provides only 3 ways to look at queries that are executed on a server in some way or another. Slow Query Log, General Query Log and Binary Log. All require a server reboot to activate and de-activate. In a production system, it’s sometimes critical to be able to know “what is going on”, and you simply can’t reboot the server twice (once to turn on, once to turn off). 5.1 goes some way with Log Tables to being able to turn on General and Slow Logs into tables. Question is, as Kevin Burton listed in his points, when is 5.1 going to be out.

Real time query monitoring also needs to have a granularity of operation better then “server”. There needs to be a capacity to assign this on per connection basis. A server is being hammered, …

Jay Pipes, Stewart Smith, Marten Mickos, Frank Mash, and Kevin Burton have all gotten into it, and Marten suggested that I should write my top five. I’m usually not into lists, but this sounds interesting, so here goes!

My top 5 wishes for MySQL are:

1. Restore some of my sanity

OK, well, this actually has several sub-wishes…

a. Global and session INFORMATION_SCHEMA …

"Which is the best opensource database?", "How does MySQL/PostgreSQL/Firebird ... (you name it) stand against Firebird/PostgreSQL/MySQL ... (you name it again)?" I'm shure we've all heard this questions many times, but now I have the definitive answer, by Jim Starkey himself, you can read the full post here, but in short is

"I think the short answer is that nobody with the experience to do this
is interested in doing it. I know that this isn't a particularly useful
answer, but I'm afraid it is the truth."

GREAT!!!

Intro

After a very long hiatus from PHP - circa php3 - I had a requirement to install PHP 5 to work with both MySQL 5.x and MSSQL database systems concurrently. I learned that PHP 5 no longer comes ready to work with MySQL directly, you have to install additional libraries, and if you need PHP 5 to play nice with that database server from Redmond, you're going to have to recompile PHP 5. I'm sharing my notes on accomplishing this task.

I'm using CentOS 4.5, but since I'll be describing how to modify a source RPM spec file to recompile PHP 5, these …

Just a quick note to let folks know that we have heard your complaints about ads on PlanetMySQL and your concerns about PageRank/page view siphoning and we have (hopefully) Made Things Right.

You will notice that we've removed the Google Ads block and we've truncated the article length at 1000 words with a link to view the rest of the article on the blogger's own website.

For this third installment in the Open Source CEO Series, I caught up with Marten Mickos, CEO of MySQL. Marten is one of my favorite people anywhere, and has been a great addition to the MySQL team. Marten is a fantastic speaker and incredibly adept at turning a phrase ("As if you could kill a dolphin by swallowing the ocean" or, my favorite, "Yes, MySQL will be part of a larger company, and that larger company will be MySQL").

I'm sure Marten has flaws, but I've yet to discover them. He certainly has some great insight, as found below:

Name, position, and company of executive
Marten Mickos, CEO, MySQL

Year company was founded and year you joined it
MySQL was founded in 1995, and I joined it in 2001.

Stage of funding and venture firms that have invested
We have done three …

Brian Aker was a recent guest on the LinuxCast podcast with Don Marti. Brian has some interesting thoughts in this podcast and elsewhere on his blog, on motivations for writing Free and/or Open Source software. Here's why I do it myself.

Way back in February I gave a webinar on using our Visual Studio integration product with MySQL.  At the time, our code did not integrate very well with the TableAdapter wizard.  To be precise, you really couldn't use stored procedures with a table adapter at all.  During the broadcast, someone asked me about using stored procedures and I told him that I would blog about it once I got it working.  Well, here we are.

Actually, we've had it working for a couple of weeks now but I'm just now getting to the blog post.  You know how it is.  There were several problems at play here but the biggest issues were the fact that we needed to provide an enumerator object for columns that would be returned by a stored procedure.  The second issue was needing to use the DbProviderSpecificTypeProperty attribute on our provider specific type property on the parameter class.  Let's look at each one of these in more …

MySQL AB today announced that iStockphoto has scaled out with the MySQL Enterprise database to handle its rapid growth while maintaining high performance and high availability. In the past three years, iStockphoto.com has grown from being one of the top 3,000 most-visited global Web sites to one of the top 300, according to Alexa.com. In the United States, it's now one of the 100 most-visited sites.

For the second installment in the Open Source CEO Series, I caught up with Javier Soltero, CEO and Co-founder of Hyperic. Javier is a highly pragmatic open sourceror, fully buying into the open source ethos but not forgetting that customers buy value, not source code.

Name, position, and company of executive
Javier A. Soltero, CEO and Co-founder, Hyperic

Year company was founded and year you joined it
Hyperic was founded in 2004. Coincidentally, I joined that same year. :-)

Stage of funding and venture firms that have invested
Series B (closed 6/07). Investors: Accel Partners & Benchmark Capital

Background prior to current company
I was Chief Architect at Covalent in charge of developing products to help manage Apache and its related technology stack (Tomcat, etc.). We built the first version of what later …