My last post on June 10 was about when MySQL received queries from php scripts that looked like this:mysql_select_db = ('database_I_DO_want_to_replicate', $link);$sql = "INSERT INTO db_I_DO_NOT_want_to_replicate.repl_table (a,b,c) VALUES (1,2,3);";-- and thus could not pass this over to the slave unless I set Replicate_Wild_Ignore_Table value IN ADDITION to Replicate_Ignore_DB as such in my

I wanted to try using MySQL source from its new VCS, Bazaar, and I saw Daniel Fischer's extremely helpful post "Getting started with Bazaar for MySQL code". Thanks Daniel!Downloading using Bazaar is indeed slow, as Daniel warns. I am constrained to 1MBps ADSL, and the intial download took quite a bit of time. I think over an hour. But subsequent merges and other operations are

podcasting

Originally uploaded by Elliot Murphy

my podcast rig

Welcome to the 103rd edition of Log Buffer, the weekly review of database blogs.

Starting with Oracle stuff, Chen Shapira (just a simple DBA on a complex production system) is looking for great PL/SQL. Why? To become a better PL/SQL programmer. “But,” she writes, “for PL/SQL , I’m a bit stuck. I can still read my own code for bad examples, but where can I find examples for great code?  . . .  Somehow, there is simply no open-source code written in PL/SQL that I can read to get a good idea of how PL/SQL should be written.” Niall Litchfield recommends the contents of $ORACLE_HOME/rdbms/admin. Any other ideas …

With ndb_restore it is actually possible (talking MySQL Cluster 6.2 and 6.3 here, haven't looked at 5.0 for a long time) to restore a single table into a CSV file that can be loaded using LOAD DATA INFILE.

This can be useful if e.g:

1. You want to extract data from a cluster table and load it into MyISAM/Innodb. This can be useful for reporting/data-mining purposes.
2. You want to load data back into Cluster but into another table looking the same as the original table (not to spoil the original data) for some reason.

Number 2) could be used in scenarios where you want to upgrade the schema by e.g changing the column length of a char(10) to char(255) (not an online operation) and add a bunch of other stuff. Please note that add column is an online operation, changing the column length is not.

Here is an example on how you can do it generate a CSV file using …

Under the title of “From MySQL to Sun“, I’m writing a monthly column to a Swedish-language business publication called “Forum för Ekonomi och Teknik“, about the Sun-MySQL integration.

If you happen to read …

Lotame Solutions, Inc. is always looking for talented individuals. We have many openings in our Technology group, but the one I’m most interested in filling is the newly opened Database Engineer position. The Database Engineer will work with me to maintain Lotame’s entire database infrastructure – including design, development, testing, implementation, monitoring and support. Interested […]

I have been working on a set of efficient C++ classes for storing N-bit (N<=64) values at arbitrary bit offsets into a buffer. Essentially a way to address memory bit-wise, rather than the usual byte-wise or word-wise. The classes support either fixed-sized bitfield storage (eg. say 27-bit values), or compressed values where small numbers are stored in fewer bits than large numbers (for example 0-15 are stored in 6 bits, 16-2**24 are stored in 26 bits, and so on).

The basic idea is of course to save space when storing large amounts of data eg. for a relational database. Today most systems tend to pad much of their numbers to 32 or 64 or whatever bits, wasting space. This is done to allow efficient access, as it is much faster to access data when it is sized and aligned to one of the word sizes supported by the machine.

Or is it really?

Todays CPUs are so fast compared to I/O (disk, network) and even to main …

Teknologföreningen (or TF for short) is the Swedish language student corporation at Helsinki University of Technology. That’s where I started my studies in 1981 at the Department of Physics, together with Mårten Mickos and Michael “Monty” Widenius.

TF has a tradition of each year publishing “ …