As requested by a few fans out there, here are the slides of my presentation:

Pentaho Data Integration 4.0 and MySQL.pdf

I had a great time at the conference, met a lot of nice folks, friends, customers, partners and colleagues. After the conference I was unable to get back home like so many of you because of the Paul Simon singing Eyjafjallajökul volcano in Iceland.

So I ended up flying over to Orlando for a week of brutal PDI 4.0 RC1 hacking with the rest of the l33t super Pentaho development team.  However, after 2+ weeks from home, even a severe storm …

Coming from a great MariaDB contributor, Mark, is:

1. MariaDB 5.1.44 / 5.2.0 Beta Binaries for Solaris 10 SPARC, and Debian GNU/Linux SPARC. Mark does a fabulous job of building these binaries, and he does them really quickly. If you’re on the SPARC platform, give it a go. Send some feedback, also.
2. Mark has also spent some time developing virtual machines. All you need to get started is download VirtualBox. Mark provides an OpenSolaris 0906 + MariaDB 5.1.44 VM as well as an …

When I celebrated my birthday, I got the idea that there must theoretically be a date on which two peoples ages are in a certain ratio. The basic idea were born when I thought that there must be a date on which my mother is exactly twice as old as me. Actually, this is the point of time when I'm as old as my mother was, when I were born. That means

Read the rest »

For all of those linux users out there that have moved over to, or tried out, Solaris10 or OpenSolaris because they heard the tales of how MySQL is faster on Solaris… or perhaps you wanted to learn how to use Sol10 for the great features of Zones or the ZFS filesystem? Regardless of why you’re on it you are probably wondering why Linux has colored output of filenames and directories but Solaris does not. The question of ‘why?’ isn’t important, but how to enable colors is. It’s very simple, and here’s how I fixed it. This is a result of digging through multiple semi-related links on Google.

1. Download all packages from SunFreeware.com
   • dependency: libintl-3.4.0-sol10-x86-local
   • dependency: libiconv-1.13.1-sol10-x86-local
   • dependency: gmp-4.2.1-sol10-x86-local
   • dependency: gcc-3.4.6-sol10-x86-local or libgcc-3.4.6-sol10-x86-local depending on your …

MySQL 5.1 still suffers to some degree from reduced performance under high concurrency. Until MySQL 5.5 is ready for production, we need some way constrain the amount of work we try to do in parallel. innodb_thread_concurrency is one control we have available, but it isn't perfect. When threads are blocked on IO, for example, no other thread can reuse its concurrency slot and try to accomplish work in the meantime. So most of us probably set innodb_thread_concurrency higher than the number of CPUs our host has, and possibly set it to 0 (unlimited).

Another way to control concurrency is limiting the number of client connections within MySQL by setting the max_connections variable. Usually we want to allow clients to stay connected longer than the duration of a single query to avoid having to reconnect for the next one so we set a connection limit of few thousand. We expect our clients to disconnect in a timely fashion …

I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram:

The XtraDB differences and main parameters are marked out.

PDF version is there http://www.percona.com/docs/wiki/percona-xtradb:internals:start.

Entry posted by Vadim | 4 comments

Add to: | …

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/

Uster, Switzerland -- April 26, 2010 -- FromDual has signed the Service Provider Partnership Agreement of the Open Database Alliance (ODBA).

FromDual is the first official ODBA consulting partner in Europe. The growing number of downloads and use of MariaDB, an improved and enhanced derivation of the MySQL database, also requires consultancy services for MariaDB in Europe.

“We are excited to be working with ODBA as their first consulting partner in Europe” says Oliver Sennhauser, Owner of FromDual. “Through our ODBA partnership, we will significantly help strengthen the position of MariaDB and ODBA in the Open Source database market.”

About FromDual

FromDual is the leading vendor independent and neutral MySQL consulting company in Europe!
As a ODBA Silver Partner, FromDual provides consultancy services for MySQL and its derivatives like MariaDB, Percona-Server, …

Uster, Switzerland -- April 26, 2010 -- FromDual has signed the Service Provider Partnership Agreement of the Open Database Alliance (ODBA).

FromDual is the first official ODBA consulting partner in Europe. The growing number of downloads and use of MariaDB, an improved and enhanced derivation of the MySQL database, also requires consultancy services for MariaDB in Europe.

“We are excited to be working with ODBA as their first consulting partner in Europe” says Oliver Sennhauser, Owner of FromDual. “Through our ODBA partnership, we will significantly help strengthen the position of MariaDB and ODBA in the Open Source database market.”

About FromDual

FromDual is the leading vendor independent and neutral MySQL consulting company in Europe!
As a ODBA Silver Partner, FromDual provides consultancy services for MySQL and its derivatives like MariaDB, Percona-Server, …

MySQL stored procedures are programs that are stored and can be executed on the MySQL server. You can call stored procedure from any application over a distributed network. Stored procedures provide a means of interacting in a prescribed way with the database without placing any additional traffic on the network. Here I’m describing a stored procedure that I used to create some sample data.

To learn more about stored procedure checkout this link.

Suppose you may need to create a large number of dataset for a table and your table structure looks like this

CREATE TABLE IF NOT EXISTS `dictionary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `word` varchar(100) NOT NULL,
  `mean` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
);

Now you’ve to add 110000 dummy data to this table. You can dump some dummy data to the table …