Search
free ebooks website


Posts Present in MySQL Category
High Performance MySQL: Optimization, Backups, and Replication

Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views

  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategies—including new tools for hot online backups

 Author Name: Baron Schwartz (Author), Peter Zaitsev (Author), Vadim Tkachenko (Author)

Publisher: O’Reilly Media

MySQL Administrator’s Bible

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

 Author Name: Sheeri K. Cabral (Author), Keith Murphy (Author)

Publisher: Wiley Publishing, Inc

MYSQL in a Nutshell

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It’s ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O’Reilly Nutshell references, it’s easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.

 

Author Name: Russell J.T. Dyer

Publisher: O’Reilly Media

Understanding MySQL Internals

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:

  • Core server classes, structures, and API
  • The communication protocol between the client and the server
  • Configuration variables, the controls of the server; includes a tutorial on how to add your own
  • Thread-based request handling — understanding threads and how they are used in MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL’s performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication

 Author Name: Sasha Pachev

Publisher: O’Reilly Media

MySQL Pocket Reference: SQL Functions and Utilities

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

  • How to configure MySQL, such as setting the root password
  • MySQL data types, including numerics, strings, dates, and complex types
  • SQL syntax, commands, data types, operators, and functions
  • Arithmetic, comparison and logical operators
  • Aggregate and general functions
  • Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers

 Author Name: George Reese

Publisher: O’Reilly Media

Expert MySQL

Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You’ll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL.

  • Shows how to customize MySQL and its storage and authentication engines
  • Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting
  • Covers high-end features such as high-availability and replication

What you’ll learn

  • Learn the inner workings of MySQL
  • Diagnose and improve poorly performing queries
  • Implement high-availablity solutions and replication
  • Modify and debug the server code
  • Build your own pluggable storage engines and authentication modules
  • Implement new SQL functions and syntax
  • Build your own query optimizer

 Author Name: Charles Bell

Publisher: Apress

MySQL Cookbook

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You’ll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to:

  • Access data from multiple tables at the same time
  • Use SQL to select, sort, and summarize rows
  • Find matches or mismatches between rows in two tables
  • Determine intervals between dates or times, including age calculations
  • Store images into MySQL and retrieve them for display in web pages
  • Get LOAD DATA to read your data files properly or find which values in the file are invalid
  • Use strict mode to prevent entry of bad data into your database
  • Copy a table or a database to another server
  • Generate sequence numbers to use as unique row identifiers
  • Create database events that execute according to a schedule

And a lot more

 

Author Name: Paul DuBois

Publisher: O’Reilly Media

Beginning Database Design (Wrox Beginning Guides)

The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
* Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
* Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
* Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements”

 

Publisher: Wrox |

Expert PHP and MySQL

Expert PHP and MySQL:

  • Reviews essential techniques, such as design patterns, complex queries, and advanced regular expression
  • Addresses advanced PHP concepts, such as iterators and closures
  • Demonstrates using Gearman for multitasking in your web applications
  • Discusses caching using memcached with MySQL and your PHP web applications
  • Discusses ways to create PHP Extensions and MySQL User Defined Functions
  • Shows how to use Sphinx for search functionality in your PHP web applications

Publisher: wrox

PHP & MySQL Everyday Apps For Dummies

PHP and MySQL Everyday Apps For Dummies is a one-stop reference providing all you need to build dynamic, real-world, ready-to-use apps with the popular PHP (a scripting language) and MySQL (a database system) software. The book is a hands-on, go-to-guide that
* Walks you through installing the applications files from the CD-ROM and setting up your programming environment
* Contains all the code needed to create seven applications:
o User authentication with HTTP
o User login
o On-line catalog
o Shopping cart
o Content management system
o Web forum
o Building and managing a mailing list (on the CD-ROM)
* Automates the programming process and walks you through building the application from start to finish
* Explains how to write secure code
* Features complete code—not just snippets, but neatly assembled packages with “instant” real-world functionality
* Shows how to build the applications in two forms — procedural and object-oriented programming — providing programmers who want to switch to the object-oriented method of coding (which is new in PHP 5!) with the essential know-how
* Includes a companion CD-ROM that contains every line of code in the applications from the book plus a bonus chapter that shows how to build a mailing list

 

Author Name: Janet Valade

Publisher: Wiley Publishing, Inc

free ebooks website
Subscribe

Subscribe via RSS Feed stay updated with Latest Ebooks

Subscribe via email address:

Enter your email address:


 
Members Login
Username:
Password:
Forgot password? Register

 
Live Help