DB User = dba
DB Pass = dba
DB Name = TEST
command = trace_on
argument = TRACE_INSERT

Voila:

$ dbmcli -u dba,dba -d TEST trace_on TRACE_INSERT

While this may be old hat to those of you out there who, like me, regularly scour through the source code commits on the internals (and newly forked commits) lists, however, in the past few weeks, a couple of documentation and code commits have caught my attention. Things catch my attention for any number of reasons. Most often, the commits that I flag for a later look at are those things which I suspected would change in the near future when I wrote chapters of Pro MySQL that dealt with the source code, architecture and storage engines. Other times, I catch something about a particular bug that I've run into has been fixed. Other times, I just notice some really cool idea that's going into the code and decide to investigate. Of course, besides the few things below, there …

Thanks to Lenz Grimmer on the MySQL forums. His solution was to use the following variables:

CC=icc \
CFLAGS="-O3 -unroll2 -ip -mp -restrict" \
CXX=icpc \
CXXFLAGS="-O3 -unroll2 -ip -mp -restrict" \
LDFLAGS="-static-libcxa -i-static"

There's a good blog article on the Xooglers (ex-Googlers) web site about how they use MySQL to run their adwords program.  If you're not familiar, adwords generates something like 99.9% of Google's advertising revenues, so it certainly a business critical application.  While Google is generally quite secretive about their internal operations, there are some interesting tidbits in this posting about how Google tried a commercial, closed-source database but it was never able to perform as well as MySQL.  A few select quotes:

• "AdWords was built using the MySQL database, which is open-source and therefore available for free. It is by now also nearly as full-featured as the best commercial databases, but back in 2000 this was not the case."
• "Many managers seem to have this idea that it is invariably true that you get what you pay for, and that therefore …

A couple friends are looking to put together a new on-line service and are in need of a skilled engineer to get their first working prototype built. If things go well, you'd have the chance to be a founder in their new venture.

Specifically, they've requested:

• PHP and MySQL experience.
• Drupal experience as a "very nice to have" skill.
• Some AJAX know-how, if possible.
• Experience building consumer-facing websites with a community/social angle.

I'm 90% sure they'd like someone in the San Francisco Bay Area but will consider remote folks too if it's a good match.

If you're interested, please e-mail me or leave a comment and I'll forward your information along to them.

(comments)

Definitely an issue that arises more often than not in real world applications, and definitely one that pops up on our forum from time to time.

Firstly, a bit of the fundamentals. MyComponents are derived from the standard Borland TCustomConnection and TDataset classes, and it is therefore important to realize that if these base classes' methods are not thread protected (using synchronization), neither are those of the MyComponents. That said, the MyComponents are quite safe to use in an isolated manner from and within threads (TThread). Moreover, the MyComponents classes actually makes special provision for you to create threaded connections to the MySQL server.

Also to be kept in mind, is that all Borlands' GUI VCL runs in the main application thread, and therefore is it not possible to create a dataset in a thread and have it be connected to a DBGrid for example. However, the TMySQLDataset does have a thread open …

Tonight the Boston MySQL meetup convened for pizza, soda, conversation and a presentation on MySQL 5 by Philip Antoniades.

Attendance was ~25 and a fairly low key. After some pizza we got right into Philip's presentation, "What's New in MySQL 5." Philip gave 10 tips or reasons for migrating to 5.0, along with a host of other information about the company, the database architecture etc. A good presentation with a lot of background and in-depth information about MySQL. After the 40-minute presentation there was another 20 minutes of Q/A, which was also pretty in-depth. Philip knows his MySQL stuff.

I recorded the meeting on my …

I started out today doing what I thought was a simple task; Install the MySQL client using Intel's compiler. In my environment, we like to install the client software so it is generally available to everyone and the server software on the actual physical box. We feel this gives us the flexibility to upgrade the servers indendently from all the programs.

I've compiled the 5.0.16 software using gcc about a dozen times already and other than a few simple tweaks here and there, it was a no-brainer. When I installed the client, I used gcc instead of the preferred (in my environment) icc.

I started by issuing a "make clean" to remove any builds I did before. I then changed my CC and CXX environment variables to point to the icc compiler and did:

$ configure --without-server --prefix=/usr/local/mysql_client

On my first try I encountered errors that were looking for …