Dear Sheeri,

Congratulations! You have been accepted as a presenter for the O’Reilly Open Source Convention 2006 at the Oregon Convention Center July 24, 2006 - July 28, 2006.

The following has been accepted as a 45 minute session for the event:

“So you’ve inherited a MySQL Instance on Unix”

…..

——————-

I’d totally forgotten I’d even submitted that!

Guess I’m going to Oregon in July…..

Had evaluated mysql 5.1 and found it to be very good.
Check this out

[root@localhost mysql5]# ./bin/mysqladmin -u root -pjayant status
Uptime: 38621 Threads: 2 Questions: 98346998 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 119 Queries per second avg: 2546.464

The no of queries/second is very high. And the load on the machine is around 2.

Have tried out mysql partitioning on one of the tables. The table has large no of rows - around 90,000,000. And the results were very good. I was able to get large no of queries serverd at the same time from the table.

Few more improvements in the partitioning algorithm can make it rock.

1. Parallel execution of queries on all partitions
2. More efficient administrative commands like alter, add, COALESCE partitions.
3. Decrease locking time of partitions not required in a query.
4. Provision …

I have been noticing some forum posts / questions about InnoDB datafiles. The question is can they be copied to another server while a MySQL server is online? With a little testing, the answer is Yes!!

Provided that there is no write activity on the server, the files can be copied to another server and the MySQL server started up with no problems. This gives me lots of hope in trying to build new slaves quickly, while minimizing downtime. Both the innodb data file(s) and the log file(s) must be copied to the new server (while its down) in order for this to work. InnoDB goes through any recovery that's needed and the server comes up.

This gives me some hope in building new slaves going forward.

I don’t think I’ve ever installed MySQL via .rpm I have always installed via .tar.gz primarilarly because I’m an /opt system administrator from my old UNIX days. so my first experience installing on my CentOS 4.2 (aka RHEL 4).


$ rpm -Uvh MySQL-server-standard-5.0.19-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-standard-5.0.19-0.rhel4.i386
Suggested resolutions:
perl-DBI-1.40-8.i386.rpm
$ rpm --import /usr/share/doc/centos-release-4/RPM-GPG-KEY
$ yum install perl-DBI-1.40-8
$ rpm -Uvh MySQL-server-standard-5.0.19-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server-standard …

As mentioned in my earlier post Emulating Oracle Output Functionality, I’ll be speaking at the MySQL Users Conference on the topic of MySQL for Oracle Developers. Here is the second in a series of points regarding current MySQL Stored Procedures and Functions functionality.

• 3. Named Parameters
• 4. Procedure Overloading

3. Named Parameters

Parameters passed to Procedures under normal operations can be considered positional parameters. For each parameter, a calling statement is required to pass the same number of parameters and in the same order. Named parameters allows the user to pass parmeters in the order of their choosing, and also not pass all parameters. …

The advantage of having ExtractValue in the database, is that I can now just pull all of the titles out of the RSS without having to deal with it in the client :)

mysql> select ExtractValue(raw_xml, "/*/channel/title") from sites_log LIMIT 7;
+----------------------------------------------------------------------- --------+
| ExtractValue(raw_xml, "/*/channel/ title") |
+----------------------------------------------------------------------- --------+
| The Motley Fool |
| Nanodot: Nanodot: Nanotechnology News and Discussion of Emerging Technologies |
| Slashdot: Science |
| Slashdot |
| Slashdot: Book Reviews |
| Slashdot: Features |
| Slashdot: Interviews |
+----------------------------------------------------------------------- --------+
7 rows in set (0.00 sec)

mysql>

Now I just do a quick:

…

First, thank you so much to everyone who commented (and e-mailed) me about my previous blog post. I wasn't really preaching to use auto increment to anyone, just wanted to experiment. The bottom line is to not use auto-increment, rather use sequences or work around the application logic.

Now, to get to the point. I am very excited since with about eight hours of work, I added the entire photo gallery feature to Adoppt. I'm still working to find out the bugs, but it's pretty neat.

For starters, it takes your photo and creates different sizes out of it. You can upload a photo upto 600K and it will web-optimize the photo for you. In addition the small and medium sized images have rounded edges. And you know what's cool? You can tag the photos just like anything else for your organization. In addition now you can create collaborative galleries with friends. So all my …

There's a lot to be said about what's happening in MySQL 5.1 Quite a bit has already been written about 5.1, but as I'm starting to do some testing I thought I'd hit the release notes and see how things have progressed over the past few months. Some great things coming down the line. A few that I found worthy of note:

• 5.1.8 (not released)
  • mysqldump can dump events using --events
  • CREATE PROCEDURE and CREATE FUNCTION now allow DEFINER syntax
• 5.1.7
  • Now must use ENGINE= instead of TYPE= for specifying the storage engine to use with CREATE TABLE
  • mysql_upgrade program which is smart about upgrading between versions
  • new RENAME DATABASE statement
  • creating, changing or dropping events is not allowed in triggers
• 5.1.6
  • Packaging …

This site already went online a few weeks ago to launch this blog. Now, finally, it contains information about my forthcoming book “No Lobbyists As Such - The War over Software Patents in the European Union”. For your information, here is the related press release:

Florian Mueller’s book “No Lobbyists As Such”
tells the story of the successful resistance
against the EU software patent directive

Starnberg, Germany (March 28, 2006) — Florian Mueller, the founder of the award-winning NoSoftwarePatents.com campaign, has announced his forthcoming book, No Lobbyists As Such - The War over Software Patents in the European Union. On approximately 380 pages, Mueller tells the story of the legislative process that ended in July last year with a landslide vote of the European Parliament against a proposal for a software patent directive. Pre-orders …

I stand corrected on my earlier post Emulating Oracle Output Functionality (which I’ve updated) when I made a reference to MySQL catching up. That was not what I was implying, that MySQL had to catchup to Oracle. I was indeed making reference that MySQL is a 10 year old product, Oracle almost 30, and with a far greater historical R&D budget, MySQL as an organisation has for lack of a better term, entered the race at a later time. One could also argue it’s not a race, I’m just using this analogy.

For those that might have thought this in reading my earlier article, I’d encourage you to re-read my updated introduction for my clarification and correction.

The comment was made to me, “Oracle is very good at being Oracle” which is totally correct, and the “MySQL’s market now overlaps that of Oracle, and so there is competition.” Indeed Oracle, as a …