Good news for everyone that has wanted the performance tuning abilities of Kontrollbase – the opensource enterprise monitor for MySQL – but didn’t want to install a centralized monitoring application for their MySQL database servers. Now the same performance tuning reports are available in a single script that can be run from the command line [...]

We’re looking for an intermediate to expert MySQL DBA who can jump right in. We have several offices in Ottawa, Boston, Sydney and Hyderabad, India.

Working at Pythian is different than working in-house or as a consultant, because you’ll be making your contributions available to each of the customers assigned to your team, allowing you to see more use cases, more technologies, and work with more and varied environments, all the while building interesting and long-lasting working relationships with your peers. I will gladly sponsor a work visa for the right candidate anywhere in the world.

We support some of the most interesting internet-scale MySQL environments in the world, see http://www.pythian.com/about/customers/ for a sampling of customers across many industries.

Top Criteria

* Outstanding MySQL production administration …

One of the best kept secrets in the MySQL world are the terrific (and free) webinars that are available.  In fact we have just such a webinar coming up this Thursday.  This one is covers using MySQL embedded with Windows and is presented by Mike Frank.  You can find out more and register here.

It’s free and I know you can spare an hour so what are you waiting for?

After my previous benchmarks of FusionIO 160GB SLC card, FusionIO team sent me for the tests another card, FusionIO 320GB MLC. I should say I really appreciate an opportunity to play with this card and with combination of two cards.

This card is also not cheap, the price I can find on dell.com is $6,829.99, which is almost the same as for 160GB card, but with doubled space,
and which gives me 21$/GB for 100% formatted card, and 29$/GB for card with 75% of space allocated. Effect of 25% reserved space you will see in the results.

The full numbers are available on our …

The latest version of Kontrollbase – the opensource enterprise MySQL analytics and performance tuning application –  is available for download. Since the previous one, version 225, there have been a lot of great changes. The most significant being the development and inclusion of the Reporter CLI script – which is a combination of the client, [...]

A recent pitch from the folks opposing Oracle’s ownership of MySQL via acquisition of Sun Microsystems got me thinking. The plea, ‘Oracle can have Sun, but not MySQL’ may make sense to some, but to me it speaks to the irony of closing out Oracle or any company or anyone from open source. Upon further reflection and given 2010 is off to a roaring pace of M&A, I also began to wonder what the impact of the ‘Save MySQL’ campaign could be on open source in M&A, particularly if it was to successfully derail the acquisition or somehow decouple MySQL from Sun under Oracle?

What would it mean to carve out the open source projects, components, teams and support from companies involved in mergers and acquisitions over …

Join the leading Drupal performance and scalability company. We architect infrastructures, optimize code and database queries, tune the applications serving web pages, and stay current with the latest performance and reliability technologies. We employee some of the leading contributers to the Drupal framework, including core contributors and contrib maintainers, as well as key members of the Drupal.org infrastructure team. We strive to continuously share our growing knowledge and contribute back performance patches to the larger open source community.

read more

A customer says: "I am building a form that presents columns in a table as fields in the form. I want to use the end user's database account to discover which columns are updateable and present the corresponding fields appropriately to the end user: I will gray-out the fields that are not updateable. How do I discover the updateable columns in a table?"

This is a straight-forward set of queries on the data dictionary, which is presented in the information_schema database. The only thing to note is that a user's access to table columns is determined at 4 levels: server level, database level, table level, and column level. These privileges are reported in the information_schema tables USER_PRIVILEGES, SCHEMA_PRIVILEGES, TABLE_PRIVILEGES, and COLUMN_PRIVILEGES. The access I have is the union of all the privileges I have been granted. So, if I have been granted access to all tables in the world database with, say:

GRANT …

Friday was my last day at Sun Microsystems, and today is the first day at my new job (location coming soon). I’ve had a great time at Sun, and thank them for all the opportunities given to me there. I’ll be doing mostly the same work at the new gig, working on projects like Drizzle, but with a slightly different focus. For the most part my day-to-day won’t change much.

Right now I’m focusing on libdrizzle again and am implementing the prepared statement API, cleaning up the MySQL protocol support a little, and also implementing the new Drizzle client/server protocol. I’ll continue to work on Gearman as well, especially where it is relevant to Drizzle. I also need to start blogging again with specific topics in the projects I’m working on, I’ve been fairly quiet lately.

I’ll be in New Zealand next week at Linux Conf AU (yes, it’s not in AU this year). I have a …

Friday was my last day working for Sun Microsystems, which means it was also the end of the job that started when I was hired by MySQL, Inc a little over four years ago. For those of you who didn't know me before that, it should be noted that the other than periods of time when I have started companies and worked for myself, the next longest I've ever been with one company was 10 months. I mention that as one of the few quantifiable metrics I could cite in describing what a wonderful experience it has been to work for MySQL and then Sun. The people I've worked with have been nothing short of stellar.

I will be continuing my work as a core Drizzle developer, so this blog post notwithstanding, I doubt most people will notice the change. The only real outward difference I can think of is that now that I'm not a Sun employee, I am free to comment on the merger and on what some people see as the need to save MySQL from Oracle. I don't know if I …