MariaDB is a community developed, backward compatible, drop-in replacement branch of the MySQL(R) Database Server. What is MariaDB all about, and what is its future? What can you do with new features added in the first GA release of MariaDB 5.1, such as additional Storage Engines (Maria, PBXT, XtraDB, FederatedX), …
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 …
Sheeri K. Cabral of the Pythian Group goes through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. She also goes through how to recognize when you want those types of joins, and best practices for the …
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone? The TIMESTAMP data type will show different times if you change the server’s time zone. This presentation covers all …
This presentation shows how to use SHOW ENGINE INNODB STATUS to get more information about your Innodb tables, foreign keys and transactions. This is a great presentation to learn how InnoDB works.
This video shows on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies.