Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke?s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT?ON DUPLICATE KEY

Feedback:

Email podcasttechnocation.org">podcasttechnocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your computer:
…

mysql podcast

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your …

Hi,

for the whole week I have been in training in Cupertino.  Basically, what is covered is HA/Cluster/Performance tuning.  Nothing very special this week,  I just continue to discover MySQL from the inside and I’m pleased with what I see.  Tonight, we have a dinner with our VP, Ulf Sandberg.  Since such a large proportion of MySQL employees work remotely,  such events are important make ties between people.

I started looking at the MySQL proxy and although some may argue that features it allows should be in the server, it is so easy to do interesting things.   Of course, I will have to learn LUA and… of course Jan had chosen to use LUA 5.1 and my brand new Ubuntu Feisty Laptop has LUA 5.0.  Anyway, I don’t really need to compile it right now, there is a binary version available.

I almost done with the configuration of my Lenovo T61, yesterday I got my bluetooth …

The launch of MySQL Proxy has caused quite a commotion in the community. And with reason. For feature hungry people, this is undeniably the most exciting addition to MySQL set of tools.
If the last statement has left you baffled, because you don't see the added value, don't worry. This article aims at giving you the feeling of what the Proxy can do.

I really hate YUM, the crappy-ass apt wanna-be that all the non-Debian distros wet themselves over. Yes, it's better than what they had before, which was NOTHING. But it is absolutely inexcusable that, when apt was already available, powerful and quick, that they wrote YUM. Not because I think everyone has to use my favorite toy, but because it's a worse tool. It's it's slower, it's stupid and it gives terrible feedback.

Let's start with today's beef. I tried to do this:

yum install libselinux-devel

on a just-installed Fedora 7. What I got was this:

Transaction Check Error:
file /usr/share/man/man8/matchpathcon.8.gz from install of libselinux-2.0.14-4.fc7
conflicts with file from package libselinux-2.0.13-1.fc7
file /usr/share/man/man8/selinux.8.gz from install of libselinux-2.0.14-4.fc7
conflicts with file from package libselinux-2.0.13-1.fc7

Tell anybody what the problem is? First of all, has anyone ever tried …

As you might know while running GROUP BY and some other kinds of queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. Which one will be used depends on the allowed tmp_table_size and also by the data which needs to be put to temporary tables - BLOB/TEXT columns are not supported with MEMORY storage engine so must use on disk MyISAM temporary table.

What i decided to do is to see how much overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table and types which can be presented both in MEMORY and MyISAM storage engine.

The benchmarks are done with MySQL 5.0.45 on 32bit Fedora Core 6 on Pentium 4 box - something I had available for testing.

PLAIN TEXT SQL:

1. CREATE TABLE `gt` (
2.   `i` int(10) UNSIGNED NOT …

One of the mysql database servers I manage started to have issues with doing backups yesterday. mysqldump was running but nothing was happening on the backup side. I started to investigate to see why our full backups were failing. I opened up the mysql error log file (mine is at: /usr/local/mysql/var/hostname.err) [...] …

I noticed today if you go to Yahoo.com and type MySQL to Search field it gives you suggestions for MySQL, which are:

* loading javascript arrays with mysql data
* mysql performance blog
* mysql download
* mysql administrator download
* mysql front download

It may not be best search suggestions but it is cool to see our blog name to make it in the top of the list.
Too bad few Geeks use Yahoo for search so most of our search engine traffic comes from Google.

MySQLCamp is a free event available to the public, though geared towards the MySQL Community. There is no fee for any participant, and workshops are presented by participants and chosen by the community.

Last year, Google was kind enough to sponsor all of the logistics, from food to meeting space. This year, Polytechnic University is providing the location — and we're opening up sponsorship for the rest!

Technocation, Inc. — a US not-for-profit providing educational resources for IT professionals –  is sponsoring a donor campaign for MySQLCamp II, to take place from August 23-24, 2007 at Polytechnic University in Brooklyn, NY, USA.

By sponsoring MySQL Camp, you will not only help out the community and get a tax deduction, but your name and company's name will …

From Slashdot:
http://it.slashdot.org/article.pl?sid=07/08/13/1939231&from=rss

Its not that surprising to me that I am not the only person who wants a copy of Wikipedia in my pocket. The amount of time I am reading wikipedia has been going up each year. Its becoming a rare work day where I do not use it for reference at least once. The technical articles are getting better and better and its better then IMDB most of the time for information on a Movie.

Other things that are impressing me:

Foleo http://www.palm.com/us/products/mobilecompanion/foleo/index.html?creativeID=SP_M_foleo
I missed the point of this device when I first saw it. I thought "oh, bigger Treo, …