Showing entries 38001 to 38010 of 44041
« 10 Newer Entries | 10 Older Entries »
MySQL Connector/J 5.1.0 Alpha with JDBC-4.0 Support Released

It's been a long time coming, but we've finally managed to get the first alpha release of Connector/J 5.1 out the door. The key thing in this release is support for JDBC-4.0, including:

Ease-of-development features including auto-registration with the DriverManager via the service provider mechanism, standardized Connection validity checks and categorized SQLExceptions based on recoverability/retry-ability and class of the underlying error.

Unwrapping to interfaces that include vendor extensions

Support for XML processing via JAXP interfaces to DOM, SAX and StAX

Support for setting per-connection client information (which can be viewed in the comments section of a query via "SHOW PROCESSLIST" on a MySQL server, or can be extended to support custom persistence of the information via a public interface)

Support for JDBC-4.0 NCHAR, NVARCHAR and NCLOB types

It's available for download now at …

[Read more]
My project just got written up in a tech news

MySQL-Storage-Engines für memcached und Amazon S3

Neue Storage-Engine-Architektur animiert Entwickler

Mit seiner neuen "Pluggable Storage Engine Architecture" bietet MySQL 5.1 eine neue Flexibilität in Sachen Storage-Engines und einige Entwickler zeigen, was sich mit diesem System anfangen lässt: Mark Atwood arbeitet beispielsweise an einer Storage-Engine, mit der sich über MySQl auf Amazons Webspeicherdienst S3 zugreifen lässt, und Brian Aker bietet Zugriff auf Dankas memcached via MySQL.

Mit seinen verschiedenen Storage-Engines und deren unterschiedlichem Funktionsumfang hebt sich MySQL von manch anderem Datenbank-Management-System ab. Während eine Storage-Engine mit Volltext-Indizes aufwartet, bringt eine andere Transaktionsunterstützung mit. Was manche als Schwäche des Systems sehen, versucht MySQL zu einer Stärke zu machen und führt mit MySQL …

[Read more]
Some news updates

So a few things happened in the last few weeks or will be happening that I find worth sharing. First up Pagenello, the biggest Ultimate Frisbee tournament in Europe, was blast. Plenty of sun while playing 10 beach Frisbee matches in 4 days with some quality time chilling in Rimini before and after the tournament.

Yesterday I also held a slightly updated version of my "Explaining Explain" talk (now called "Finding Order in Execution") at the webtuesday usergroup meeting here in Zurich. As always you can find a pdf with the slides in the slides section of my blog.

Speaking of speaking I will be giving a talk on PHP6 at MySQL User …

[Read more]
Handling multiple data sets in stored procedures from Perl

MySQL stored procedures can use SELECT statements in their body, returning a data set to the caller. The manual also explains that multiple data sets can be returned from such a stored procedure.
For example, assume you have this stored procedure:

CREATE PROCEDURE p1(x INT, y INT)
DETERMINISTIC
BEGIN
SELECT
x ;
SELECT
x AS first_param,
y AS second_param;
SELECT
x,
y,
x + y AS sum_xy,
x * y AS prod_xy;
SELECT * FROM t1;
END


There are four SELECT statements, with different headers, and a variable number of rows returned.
Early versions of …

[Read more]
How simple answer are you looking for ?

I've got an interesting comment the other day saying "I've heard Jay Pipes saying indexes with cardinality lower than 30% are worthless, true?"

That is interesting question and it has different answers depending on who is asking. A lot of people want to hear simple answers to the questions because they would be overwhelmed by complete answer, it is like children being taught math first taught simple division skills like you can divide 10 by 2 but not by 3. As we grow up we learn the truth is much more complex than that and if you Major in math you will find there is a lot of stuff out where far beyond basic stuff we use in every day life.

Answering such question you can say yes it is true and for clueless person it will be helpful answer because it will allow him to avoid creation indexes on the column containing just one value which is good idea.

If you start to explain it in details, a lot of variables add in - covering …

[Read more]
Sessions of Interest for me at MySQL 2007

I have put together a list of the sessions that are of interest to me this year at the MySQL Conference. Again, there is some overlap in sessions I would like to do, particularly with some certification exams in there as well! :)

What they say: Tritonn??????

One of the cooler bits of technology I got to see while in Japan last week was a MySQL Storage Engine for doing fulltext searches in Japanese. The engine in question was Senna, and it was merged with the MyISAM engine.

Fulltext for Japanese is hard, its a very non-trivial problem. The Senna developers are some of the many different storage engine vendors who will be at the MySQL User's Conference in a couple of weeks.


Tritonn (Binding between MySQL and Senna)
http://qwik.jp/tritonn/

Presentation Material(in Japanese)
http://www.scs.co.jp/mysql/docs/OSC2007SpringTokyo_MySQL_Senna.pdf

You can download it …

[Read more]
The innotop session at MySQLConf 2007

I'll present a session on the innotop MySQL and InnoDB monitoring tool at 2007 MySQL Conference and Expo in a couple of weeks.

The innotop session will focus on using innotop's basic and intermediate-level features. I'll demonstrate how to install it and get the initial configuration set up. I'll show you what innotop is good at doing, and how to do some of the things I do frequently, such as watch queries, check replication status, and look at what transactions are currently open. And I'll demonstrate some of innotop's many small features that can help you use it to watch and control your MySQL servers.

You'll leave the session with a comprehensive …

[Read more]
Ego Battle-Royale in Conference Wednesday Keynote Block

Here is a quick heads up for those following along in the buzz-meter generated about the MySQL Conference and Expo in a couple weeks: the development team responsible for Yahoo! Pipes — the incredible web-based GUI for mashing mashups — will be doing the conference's closing keynote... more details to come!

Anyway, I wanted to follow up on Kaj's blog post about the "Clash of the DB Egos" scheduled for Wednesday morning, directly following Eben's "Freedom Businesses Protect Privacy" keynote talk. In Kaj's original post, he joked that E.F. Codd and …

[Read more]
Zmanda Webinar: Backup and Recovery of MySQL Clusters

Event Information

Topic:
Backup and Recovery of MySQL Clusters

Date and Time:
Thursday, April 12th , 2007 10:00 am
Pacific Daylight Time (GMT -07:00, San Francisco)

Panelist(s) Info:
Shailen Patel - Professional Services Engineer,
Paddy Sreenivasan - VP, Engineering,
Ram “TK” Krishnamurthy - VP, Services and Support

Duration: 1 hour

Description:
Zmanda Recovery Manager [ZRM] for MySQL provides a simple and easy way to backup and recover MySQL clusters. Zmanda Engineers will provide an overview of ZRM for MySQL and demonstrate its ability to backup and restore MySQL cluster.

Showing entries 38001 to 38010 of 44041
« 10 Newer Entries | 10 Older Entries »