Pipeline Newsletter Articles
Got something that you want to share with your fellow Pipeliners? Send it in and you might see it next on the MySQL Pipeline Archives page!
Email your file as an attachment to webmaster@quest-pipelines.com with a brief explanation of what it is.
Please keep the file size as small as possible for easier
downloading, (no files over 1MB in size). Use the archives below to better understand the type of material that we are
looking for. Thank you. |
By Bert Scalzo, PhD, Quest Software (Bert.Scalzo@quest.com)
In this white paper, database expert and author Bert Scalzo addresses the top-five database benchmarking questions most frequently asked of him.
Gaining the best performance from your database applications is critical to the productivity of your IT infrastructure. A key component in achieving this is to validate the scalability of your database systems using benchmarking that is focused on the database.
This white paper answers the following quesions:
- Does Linux or Windows yield better benchmarking results?
- How many bits are best, 32 or 64?
- Which database platform provides the best performance benchmark - Oracle 10g,
SQL Server 2005 or MySQL 5.0?
- How do I determine the maximum concurrent OLTP users a server can sustain?
- How do I determine the maximum size data warehouse a server can sustain?
Format: Adobe Acrobat
Top5DBBenchmarking.pdf
From MySQL.com
This page offers a quick way to compare the features of various database servers such as MySQL,
Oracle, DB2, and SQL Server, among others. The comparison, which can include up to 28 groups of criteria,
is designed to help you make an educated determination as to which database server will best suit your needs.
The comparison tool itself may also be downloaded from this page.
Format: HTML Page
crash-me.php
By Arjen Lentz, MySQL AB
InnoDB is an ACID compliant storage engine for MySQL with capabilities for
- commit-rollback
- recovery handling
- row-level locking
- versioning
- consistent, non-blocking reads
- FOREIGN KEYs
Specifically tuned for speed with large data sets, InnoDB is aimed at high performance
applications with frequent updates. This presentation provides an introduction to InnoDB as well as
some suggestions for maximizing its performance.
Format: Adobe PDF, 482KB
InnoDB.pdf
By Arjen Lentz, MySQL AB
This paper outlines the current key features of the MySQL RDBMS, supported by a little history and
an overview of the MySQL development and release philosophy. It goes on to look at what
new features the MySQL development team is working on.
Format: Adobe PDF, 211KB
MySQL_RoadMap.pdf
From The Analysis and Solutions Company
This tutorial provides new MySQL users with very basic, step by step, instructions on
how to get started.
The tutorial describes how to install MySQL on a Windows OS, start the client and adjust the initial
security settings. It then goes on to describe how to create a simple database, add some records, and
modify those records.
Format: HTML Page
mybasic.htm
Click Here to subscribe to the Quest Pipelines Newsletter.
Procedural Programming in MySQL - Part 1 (January 2005)
By Andrew Gilfrin
This paper looks at the new stored procedure support available in the latest version of MySQL.
The document describes how to create functions and procedures, add and use variables, pass
parameters in and out, and use the select into command to expand on the basic functions available
in MySQL.
Part 2 will follow shortly and contain more advanced features such as conditional logic, loops,
cursors and exception processing.
Click Here to view
the article.
Procedural Programming in MySQL - Part 2 (February 2005)
By Andrew Gilfrin
In the first part of Procedural Programming in MySQL published in last January’s Pipelines
newsletter we looked at the basics of creating functions and procedures within MySQL. We looked at
functions, procedures, parameters, variables and finally at the Select Into syntax.
The first release of Stored Procedures within MySQL set a base level of functionality that should
suit most basic programming requirements, but that’s not to say all of the standard features of a
programming language are not present. In this second part we will be looking at the features of the
language we didn’t cover in the first part. We won’t be looking explicitly at how to code these
features as that would require much more space and time than we have here, but at the end you will
have an understanding of what’s available to you.
Click Here to view
the article.
VB Without Data Binding; A Better Way (April 2005)
By Robert Rowe
I answer a large number of questions from people having problems with their Visual Basic
programs. Once I have the details of their situation I find that many people are using Data
Binding techniques. While Data Binding is a powerful technique, it can also lead to many problems
that would not otherwise exist. My efforts to explain this have ranged from difficult to
impossible. The purpose of this article is to detail what Data Binding is, why it should be
avoided and how to write VB programs without it.
Click Here to view
the article.
Effective Data Filtering (May 2005)
By Robert Rowe
This is the second article intended to illustrate professional programming techniques using
Visual Basic and MySQL. The first article discussed why we should avoid data binding. It can be
viewed here. This article discusses writing software that helps the user effectively work with
large amounts of data. The approach that I will describe is called filtering. I have expanded on
my sample program from the previous article to exemplify the techniques that are described
herein. You can download it here.
Click Here to view
the article.
Queries - Introduction to SELECT (August 2005)
Topic Extracted from Knowledge Xpert for MySQL
The SELECT query allows data to be read from a table. A selection can be made from a single
table or several tables, and you can write expressions around column names, so that table values
are processed in some way before reaching the resultset. There can also be a SELECT query with no
tables used to evaluate expressions.
Click Here to view
the topic.
Introducing the MySQL information_schema (September 2005)
By Roland Bouman
MySQL 5.02 and later includes an information_schema database. The MySQL information_schema is
a basic implementation of the INFORMATION_SCHEMA schema defined in the SQL Standard (ISO/IEC 9075).
The purpose of this database is to provide data describing the databases and their constituent
objects: metadata.
The information_schema database consists of a set of table-like objects (actually, system
views), exposing metadata in a relational format. This allows one to execute arbitrary SELECT
statements to retrieve or to format metadata. Metadata is available only for those objects that
are accessible to the current user. The metadata is automatically maintained by the server, and
the information_schema database is automatically created upon MySQL installation.
In MySQL versions prior to 5.0.2, virtually the only way to obtain metadata is through the
MySQL specific SHOW syntax. The possibilities to control the output of the SHOW commands are
limited to filtering for data of interest, whereas the information schema allows us to use the
full set of relational operations defined by the SQL language. This allows DBA's and application
developers to retrieve exactly the data they need to port applications, generate maintenance
scripts or document database structure.
Click Here to view
the article.
For questions
or comments on this site: webmaster@quest-pipelines.com
All content Copyright
© Quest Software, Inc. All rights reserved.
|
