Why generalizations about open source product usability don't apply to vendor-sponsored open source projects READ MORE

MySQL allows user specific options to be placed in a user options file under your home directory. This is handy if you use automated scripts or want to avoid typing in your MySQL user’s password everytime you login in. To do this, create the ~/.my.cnf with the options below:

[client]
user=mysqlusername
password=mysqlpassword

Then make sure no one else on the system can read this file. It’s essential for security as it contains your password in clear text!

$ chmod 600 ~/.my.cnf
$ ls -l ~/.my.cnf
-rw------- 1 alice alice 36 Aug 12 17:49 /home/alice/.my.cnf

Now you can just type mysql to login. Note that this will work for other MySQL clients like mysqldump. And you can always override the .my.cnf settings in the command line. For example:

$ mysql -ubob -pbobspassword

You can add other parameters to this file. For a full reference check out:
…

Introduction

The purpose of this document is to explain the power-efficeincy analysis proess, power-efficiency issues and solutions in MySQL database server as an example to help identify the right tools and procedures that support the development of energy-efficient application.

Analysis Process

1. Install and start test application(MySQL) on idle system, create workload to simulate the scenario that multiple concurrent clients connecting to the MySQL server without executing any queries.

2. Run PowerTop on Solaris to see how much time the CPUs are spending running in lower power states, and how much time the CPU are spending running in C0 state(meaning CPU is actually executing instructions.)

3. Use DTrace to profile application understand the source of the wakeups causing …

Introduction

The purpose of this document is to explain the power-efficeincy analysis proess, power-efficiency issues and solutions in MySQL database server as an example to help identify the right tools and procedures that support the development of energy-efficient application.

Analysis Process

1. Install and start test application(MySQL) on idle system, create workload to simulate the scenario that multiple concurrent clients connecting to the MySQL server without executing any queries.

2. Run PowerTop on Solaris to see how much time the CPUs are spending running in lower power states, and how much time the CPU are spending running in C0 state(meaning CPU is actually executing instructions.)

3. Use DTrace to profile application understand the source of the wakeups causing …

I was in San Francisco at the tail-end of last week and was fortunate to have some time to meet up with Josh Berkus, a member of the PostgreSQL core team and, until recently, a Sun employee.

Our conversation covered a lot of ground, including his reasons for leaving Sun (he didn’t go into detail but suffice to say he’s working a business idea), the future of the database market (more choice, more horizontal scaling, more use of specialist databases), the future of PostgreSQL (as a development platform), the level or authorization afforded to the Drizzle project, and the future of Sun.

I won’t go into the latter now, but the …

Hi,

I needed to install AMP on my OpenSolaris laptop to do some PHP development, and I thought some people would be interested to know how to do this.

Here we go.

AMP is available from the OpenSolaris Web Stack project, which also includes other open source components such as Perl, Ruby, Memcached, Lighthttpd, etc.

The nice thing with OpenSolaris is that - assuming my laptop is connected to the Internet - I can use the Package Manager to automatically download and install AMP on my laptop. I access the Package Manager through the menu System/Administration.

Once the Package Manager is launched, I make sure that the Repository is set to opensolaris.org and  I do a search on amp:

The amp and amp-dev packages are now listed in the selection …

Morning, I saw Monty's post asking for contribution to drizzle's i18n efforts. I did checked out Hindi language and well I must say translation is a fun activity. 
If you think that will be as easy as using some online translation tool (I tried Google Translate), you may be wrong. Many sentences that make direct sense in English get completely screwed when translated word by word. Sometimes they are translated into a perfect meaningful sentence and that is when you can laugh out loudly.
As of now I'm doing Hindi (already 80 translations down) and next I'm gonna pick Punjabi. Wow! I know languages.

We have been looking for a new standard method for serializing objects from the server. Schemas, Replication Events, Tables, etc... all for one reason or another have to be serialized at some juncture at the moment. Each type has its own method/language which makes it a bit of a pain to deal with in the server.

Worse?

Few of the formats are upgradable. You end up with all sorts of incompatibilities that over time have become a real PIA to deal with.

Introducing Google's Protocol Buffers:
http://code.google.com/apis/protocolbuffers/

In short, this buys us an upgradable format and a lot less code. It also makes it much simple to write trivial little tools to pull apart objects from the server.

I pushed the first bit of this into Drizzle last night, and picked a low hanging piece of fruit, the …

Just on the train after my morning tutorial on MySQL Replication and Backup Strategies.
I had 10 attendees, and we had a very good interactive session with many questions and discussions.
The attendees tell me they liked it.

I've rented a car here for the week, but just parking at a station outside the city to avoid parking problems.
Also allowed me to explore the area a bit more, including the fab wine regions (McLaren Vale, Barossa, etc).

Tonight is the LinuxSA meeting (a week earlier), and I'll be doing a talk there on MySQL and Drizzle.

Download Maatkit

Maatkit version 2152 is ready for download. This release is also known as the “is this project really alive?” release. We thought we should delay until MySQL released a new Community Server version. Just kidding — it has nothing to do with that.

This release is also very significant in that it’s the first one that has large code contributions by someone other than myself. As you may know, Percona (my employer) has hired the very talented Daniel Nichter, author of mysqlreport and other goodies, to help with Maatkit. So far it is a match made in heaven, and Daniel did …