PreCon Program (Nov. 8, 2004)

Optimising MySQL

Speaker: Arjen Lentz (MySQL AB)

This workshop will look at the many aspects involved when optimising a MySQL application, the MySQL server, and its environment. Optimisation is certainly not a topic of dry knowledge. Instead it is about gaining the skills needed to analyse the big picture, and recognising the often small but important opportunities. As such, this workshop will provide a valuable experience particularly for more experienced users. You may benefit from bringing your own laptop computer, with MySQL Server and your favourite client installed. The latest versions of the software can be downloaded from www.mysql.com. Do come prepared, as we won't have time for the trivial.

The next generation: PHP5 and MySQL 4.1/5.0

Speaker: Zak Greant , Georg Richter (MySQL AB)

The new mysqli extension in PHP 5 supports all of the latest features that are in MySQL 4.1 and 5.0, and which are not supported in the mysql extension for PHP 4. This workshop will walk attendees through the features of new mysqli extension for PHP, along with all important features of MySQL 4.1 and 5.0, including changes in MySQL 4.1/5.0, new functions in mysqli, migration from mysql to mysqli, using the object-oriented interface, prepared statements and report functions.

MaxDB Hands-on

Speaker: Jörg Hoffmeister (SAP AG)

During this workshop we will show how to manage a MaxDB database instance and along this will give an inside view on the concepts behind this enterprise open-source database. MaxDB by MySQL is a re-branded and enhanced version of SAP DB, SAP's open-source database. MaxDB is a heavy-duty, SAP-certified, open-source database that offers high availability, scalability and a comprehensive feature set.
MaxDB complements MySQL AB's flagship MySQL database, extending the company's market reach to enlarge mySAP ERP environments and other applications that require maximum enterprise-level database functionality.

Connector/J - Stored Procedures, Server-side Prepared Statements and C

Speaker: Mark Matthews (MySQL AB)

MySQL Connector/J developer Mark Matthews will cover the newest features in Connector/J 3.1.x, including how to use Connector/J with Stored Procedures (new in MySQL-5.0), server-side prepared statements (new in MySQL-4.1) and Unicode character sets (new in MySQL-4.1).
This workshop will also include a discussion of the most efficient method of using these features, along with incremental improvements in connection pooling, multiple result set support, profiling and other performance and scalability features in the latest release of Connector/J.

Advanced Perl DBI

Speaker: Tim Bunce (Data Plan Services)

Who should attend: Intermediate to advanced Perl programmers with an understanding of the DBI and a desire to know more. Learn how the DBI works and how to get the best out of it, including how to maximize speed, safety, reliability and portability.
Outline: speed, speed, speed: what helps, what doesn't; database design, application partitioning, network latency, stored procedures, caching etc. Handling handles and binding values; your TYPE or mine? Error checking, recovery, and transactions; PrintError, RaiseError, and HandleError. The importance of checking and the virtues of eval. How transactions and RaiseError work together. Wheels within wheels: The architecture and how to see inside it using trace. DBI for the Web: Connect speed, state-less.