Archive for the 'MySql' Category

MySQL 5.0’s Pluggable Storage Engine Architecture, Part 2: A Quick Test Drive

Saturday, February 23rd, 2008

MySQL 5.0’s Pluggable Storage Engine Architecture, Part 2: A Quick Test Drive
By Robin Schumacher, MySQL AB
October 26, 2005
Part 1 of MySQL 5.0’s Pluggable Storage Engine Architecture gave you an overview Let’s take a quick test drive to show how simple it is to use MySQL’s pluggable storage engine architecture and see the […]

MySQL 5.0s Pluggable Storage Engine Architecture, Part 1: An Overview

Saturday, February 23rd, 2008

MySQL 5.0’s Pluggable Storage Engine Architecture, Part 1: An Overview
By Robin Schumacher, MySQL AB
October 19, 2004
The reasons for the huge popularity and increasing adoption of MySQL as a serious database platform can many times be boiled down to two, but surprisingly contrasting, considerations:

How much MySQL is like other database platforms.
How much MySQL […]

MySQL Administrator Best Practices

Saturday, February 23rd, 2008

Database administration serves a number of important functions from improving the performance of your database to avoiding a disaster that would result in lost data or costly system downtime. This article will describe some of the fundamental tools and practices programmers, as well as DBAs and SysAdmins, can use with the powerful new MySQL Administrator […]

Connection pooling with MySQL Connector/J

Saturday, February 23rd, 2008

By Mark Matthews
May 29, 2003
In last month’s article, “Does MySQL Connector/J Support Multithreaded Programming?”), I covered the problems with sharing a JDBC connection between multiple threads.
Most of these problems can be overcome with a technique called “connection pooling.” In addition to fixing the problems mentioned in the previous article, connection pooling generally leads to more […]

Using AUTO_INCREMENT keys with Connector/J 3.0

Saturday, February 23rd, 2008

By Mark Matthews
One of the major features available in the latest version of MySQL’s JDBC Driver, Connector/J, is the implementation of version 3.0 of the JDBC API that is available with JDK-1.4.0 and later.
There are many changes in JDBC-3.0 that make you, the Java developer using MySQL job a little easier.
Today, we’ll talk about one […]