Download - MySQL: Know more about open Source Database
Transcript
- 1. know more about MySQL open source database
MySQL: Open Source Database
1
Salaria Software Services
2. Storage engines
Schema
Normalization
Data types
Indexes
Know more about your SQL queries - Using EXPLAIN
Character set and Collation
Resources
2
Salaria Software Services
Outline
3. Generics are inefficient
If you have chosen MySQL, take advantage of its strengths
Having an understanding of the database helps you develop
better-performing applications
- better to design a well-performing database-driven application from the start
4. than try to fix a slow one after the fact!3
Salaria Software Services
Why is it significant for a developerto know MySQL?
5. Salaria Software Services
4
MySQL Pluggable Storage EngineArchitecture
MySQL supports several storage engines that act as handlers for
different table types
- No other database vendor offers this capability