[VIDEO TUTORIAL] PHP & MySQL (Course 03 Configuring For Php).avi

9 min – 21-Feb-07

[VIDEO TUTORIAL] PHP & MySQL (Course 03 Configuring For Php).avi Read the rest of this entry »

A Googly MySQL Cluster Talk
Google engEDU
55 min – Apr 28, 2006

Google TechTalks
April 28, 2006

Stewart Smith
Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is an active member of the free and open source software community, especially in Australia.

ABSTRACT
Part 1 – Introduction to MySQL Cluster The NDB storage engine (MySQL Cluster) is a high-availability storage engine for MySQL. It provides synchronous replication between storage nodes and many mysql servers having a consistent view of the database. In 4.1 and 5.0 it’s a main memory database, but in 5.1 non-indexed attributes can be stored on disk. NDB also provides a lot of determinism in system resource usage. I’ll talk a bit about that.

Part 2 – New features in 5.1 including cluster to cluster replication, disk based data and a bunch of other things. anybody that is attending the mysql users conference may find this eerily familiar. Read the rest of this entry »

An Overview of the MySQL Engine and its Latest Features
Google engEDU
54 min – Apr 26, 2006

Google TechTalks
April 26, 2006

Timour Katchaounov

ABSTRACT
The first part of this talk describes the main principles behind MySQL’s query optimizer and execution engine, how the optimizer transforms queries into executable query plans, what these plans look like, and how they are executed.

The second part of the talk describes the major improvements in the query engine of MySQL 5.0, and how these improvements can benefit the users of MySQL 5.0. The "greedy" optimizer reduces compilation time for big queries with orders of magnitude. The "index merge" access method provides a way to use more than one index for the same query. For faster plan execution and to allow better join orders, the 5.0 optimizer transforms most outer joins into inner joins.

The outer joins that cannot be transformed into inner ones are executed in a pipeline manner, so that no intermediate results need to be materialized. Finally, some GROUP BY and DISTINCT queries can be executed much faster thanks to "loose index scan" technique that reads only a fraction of an index.

The talk concludes with the near-future plans for new features coming in the next versions of MySQL. Read the rest of this entry »

Performance Tuning Best Practices for MySQL
Google engEDU
43 min – Apr 28, 2006

Google TechTalks
April 28, 2006

Jay Pipes
Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website.

ABSTRACT
Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the "low hanging fruit" on the tree of bottlenecks. It’s not rocket science, but with a bit of acquired skill and experience, and of course good habits, you too can do this magic! Jay Pipes is MySQL’s Community Relations Manager for North America. Read the rest of this entry »

A Googly MySQL Cluster Talk
Google engEDU
55 min – 28-Apr-06

Google TechTalks
April 28, 2006

Stewart Smith
Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is an active member of the free and open source software community, especially in Australia.

ABSTRACT
Part 1 – Introduction to MySQL Cluster The NDB storage engine (MySQL Cluster) is a high-availability storage engine for MySQL. It provides synchronous replication between storage nodes and many mysql servers having a consistent view of the database. In 4.1 and 5.0 it’s a main memory database, but in 5.1 non-indexed attributes can be stored on disk. NDB also provides a lot of determinism in system resource usage. I’ll talk a bit about that.

Part 2 – New features in 5.1 including cluster to cluster replication, disk based data and a bunch of other things. anybody that is attending the mysql users conference may find this eerily familiar. Read the rest of this entry »