High performance MySQL

High performance MySQL

How can you bring out MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and p...

Descripción completa

Detalles Bibliográficos
Autor principal: Schwartz, Baron (-)
Otros Autores: Zaitsev, Peter, Tkachenko, Vadim, Oram, Andrew, Demarest, Rebecca
Formato: Libro electrónico
Idioma:Inglés
Publicado: Beijing ; Cambridge [Mass.] : O'Reilly 2012.
Edición:3rd ed
Materias:
MySQL (Electronic resource)
SQL (Computer program language)
Relational databases.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628685806719
Tabla de Contenidos:
  • MySQL architecture and history
  • Benchmarking MySQL
  • Profiling server performance
  • Optimizing schema and data types
  • Indexing for high performance
  • Query performance optimization
  • Advanced MySQL features
  • Optimizing server settings
  • Operating system and hardware optimization
  • Replication
  • Scaling MySQL
  • Hight availability
  • MySQL in the Cloud
  • Application-level optimization
  • Backup and recovery
  • Tools for MySQL users
  • Forks and variants of MySQL
  • MySQL server status
  • Transferring large files
  • Using EXPLAIN
  • Debugging locks
  • Using Sphinx with MySQL.

Ejemplares similares