- Table View
- List View
MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
by Karthik Appigatla Kedar Mohaniraj VaijanapukarDesign and administer enterprise-grade MySQL 8 solutions Key Features Store, retrieve, and manipulate your data using the latest MySQL 8 features Practical recipes on effective administration in MySQL, with a focus on security, performance tuning, troubleshooting, and more Contains tips, tricks, and best practices for designing, developing, and administering your MySQL 8 database solution without any hassle Book Description MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before. This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more. With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical tips and tricks to give you the edge over others in designing, developing, and administering your database effectively. What you will learn - Install and configure your MySQL 8 instance without any hassle - Get to grips with new features of MySQL 8 like CTE, Window functions and many more - Perform backup tasks, recover data and set up various replication topologies for your database - Maximize performance by using new features of MySQL 8 like descending indexes, controlling query optimizer and resource groups - Learn how to use general table space to suit the SaaS or multi-tenant applications - Analyze slow queries using performance schema, sys schema and third party tools - Manage and monitor your MySQL instance and implement efficient performance-tuning tasks Who this book is for If you are a MySQL developer or administrator looking for quick, handy solutions to solve the most common and not-so-common problems in MySQL, this book is for you. MySQL DBAs looking to get up-to-speed with the latest MySQL 8 development and administration features will also find this book very useful. Prior knowledge of Linux and RDBMS is desirable.
MySQL 8 for Big Data
by Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp PatelUncover the power of MySQL 8 for Big Data About This Book • Combine the powers of MySQL and Hadoop to build a solid Big Data solution for your organization • Integrate MySQL with different NoSQL APIs and Big Data tools such as Apache Sqoop • A comprehensive guide with practical examples on building a high performance Big Data pipeline with MySQL Who This Book Is For This book is intended for MySQL database administrators and Big Data professionals looking to integrate MySQL 8 and Hadoop to implement a high performance Big Data solution. Some previous experience with MySQL will be helpful, although the book will highlight the newer features introduced in MySQL 8. What You Will Learn • Explore the features of MySQL 8 and how they can be leveraged to handle Big Data • Unlock the new features of MySQL 8 for managing structured and unstructured Big Data • Integrate MySQL 8 and Hadoop for efficient data processing • Perform aggregation using MySQL 8 for optimum data utilization • Explore different kinds of join and union in MySQL 8 to process Big Data efficiently • Accelerate Big Data processing with Memcached • Integrate MySQL with the NoSQL API • Implement replication to build highly available solutions for Big Data In Detail With organizations handling large amounts of data on a regular basis, MySQL has become a popular solution to handle this structured Big Data. In this book, you will see how DBAs can use MySQL 8 to handle billions of records, and load and retrieve data with performance comparable or superior to commercial DB solutions with higher costs. Many organizations today depend on MySQL for their websites and a Big Data solution for their data archiving, storage, and analysis needs. However, integrating them can be challenging. This book will show you how to implement a successful Big Data strategy with Apache Hadoop and MySQL 8. It will cover real-time use case scenario to explain integration and achieve Big Data solutions using technologies such as Apache Hadoop, Apache Sqoop, and MySQL Applier. Also, the book includes case studies on Apache Sqoop and real-time event processing. By the end of this book, you will know how to efficiently use MySQL 8 to manage data for your Big Data applications. Style and approach Step by Step guide filled with real-world practical examples.
MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds
by Jesper Wisborg KroghIdentify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzing their current performance, and improving them to deliver results faster and with less overhead. Author Jesper Krogh systematically discusses each of these steps along with the data sources and the tools used to perform them. MySQL 8 Query Performance Tuning aims to help you improve query performance using a wide range of strategies. You will know how to analyze queries using both the traditional EXPLAIN command as well as the new EXPLAIN ANALYZE tool. You also will see how to use the Visual Explain feature to provide a visually-oriented view of an execution plan. Coverage of indexes includes indexing strategies and index statistics, and you will learn how histograms can be used to provide input on skewed data distributions that the optimizer can use to improve query performance. You will learn about locks, and how to investigate locking issues. And you will come away with an understanding of how the MySQL optimizer works, including the new hash join algorithm, and how to change the optimizer’s behavior when needed to deliver faster execution times. You will gain the tools and skills needed to delight application users and to squeeze the most value from corporate computing resources. What You Will LearnMonitor query performance to identify poor performersChoose queries to optimize that will provide the greatest gainAnalyze queries using tools such as EXPLAIN ANALYZE and Visual ExplainImprove slow queries through a wide range of strategiesProperly deploy indexes and histograms to aid in creating fast execution plansUnderstand and analyze locks to resolve contention and increase throughputWho This Book Is ForDatabase administrators and SQL developers who are familiar with MySQL and need to participate in query tuning. While some experience with MySQL is required, no prior knowledge of query performance tuning is needed.
MySQL Admin Cookbook
by Udo Schwedt Daniel SchnellerThis book uses the approach of a cookbook, presenting solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy Administrators of all skill-levels will find step-by-step instructions for practical approaches to MySQL configuration, maintenance, and optimization topics. Each recipe uses a concrete example for easy understanding. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will profit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
by Daniel Schneller Udo SchwedtThis cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.
MySQL Admin Cookbook LITE: Replication and Indexing
by Udo Schwedt Daniel SchnellerThis cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.
MySQL Administrator's Bible
by Sheeri K. Cabral Keith MurphyWith 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.
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
by Jesper Wisborg KroghKnow how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well as table locks to record and gap locks. Most importantly, the book covers troubleshooting techniques when locking becomes a pain point. Several of the lock types in MySQL have a duration of a transaction. For this reason, it is important to understand how transactions work. This book covers the basics of transactions as well as transaction isolation levels and how they affect locking. The book is meant to be your go-to resource for solving locking contention and similar problems in high-performance MySQL database applications. Detecting locking issues when they occur is the first key to resolving such issues. MySQL Concurrency provides techniques for detecting locking issues such as contention. The book shows how to analyze locks that are causing contention to see why those locks are in place. A collection of six comprehensive case studies combine locking and transactional theory with realistic lock conflicts. The case studies walk you through the symptoms to look for in order to identify which issue you are facing, the cause of the conflict, its analysis, solution, and how to prevent the issue in the future. What You Will LearnUnderstand which lock types exist in MySQL and how they are usedChoose the best transaction isolation level for a given transactionDetect and analyze lock contention when it occursReduce locking issues in your applicationsResolve deadlocks between transactionsResolve InnoDB record-level locking issuesResolve issues from metadata and schema locksWho This Book Is ForDatabase administrators and SQL developers who are familiar with MySQL and want to gain a better understanding of locking and transactions as well as how to work with them. While some experience with MySQL is required, no prior knowledge of locks and transactions is needed.
MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers
by Jesper Wisborg KroghMove data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you from the initial installation of the connector through basic query execution, then through more advanced topics, error handing, and troubleshooting. The book covers both the traditional API as well as the new X DevAPI. The X DevAPI is part of MySQL 8.0 and is an API that can be used with connectors for several programming languages and is used from the command-line interface known as MySQL Shell. You will learn to use the connector by working through code examples and following a discussion of how the API calls work. By the end of the book, you will be able to use MySQL as the back-end storage for your Python programs, and you’ll even have the option of choosing between SQL and NoSQL interfaces. What You'll LearnInstall MySQL Connector/PythonConnect to MySQL and configure database accessExecute SQL and NoSQL queries from your Python programTrap errors and troubleshoot problemsStore data from different languages using MySQL’s character set supportWork in the X DevAPI that underlies all of MySQL’s language connectorsWho This Book Is ForDevelopers familiar with Python who are looking at using MySQL as the back-end database. No prior knowledge of Connector/Python is assumed, but readers should be familiar with databases and the Python programming language.
MySQL Cookbook
by Paul DuboisMySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe" -- short, focused pieces of code that you can insert directly into your applications. More than a collection of cut-and-paste code, this book explanation how and why the code works, so you can learn to adapt the techniques to similar situations.
MySQL Cookbook: Solutions for Database Developers and Administrators
by Paul DuboisMySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch.Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to:Use the mysql client and write MySQL-based programsCreate, populate, and select data from tablesStore, retrieve, and manipulate stringsWork with dates and timesSort query results and generate summariesUse stored routines, triggers, and scheduled eventsImport, export, validate, and reformat dataPerform transactions and work with statisticsProcess web input, and generate web content from query resultsUse MySQL-based web session managementProvide security and server administration
MySQL Cookbook
by Paul DuboisAlong with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. 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 MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.
MySQL Cookbook: Solutions for Database Developers and Administrators
by Sveta Smirnova Alkin TezuysalFor MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch.In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON.You'll learn how to:Connect to a server, issue queries, and retrieve resultsRetrieve data from the MySQL ServerStore, retrieve, and manipulate stringsWork with dates and timesSort query results and generate summariesAssess the characteristics of a datasetWrite stored functions and proceduresUse stored routines, triggers, and scheduled eventsPerform basic MySQL administration tasksUnderstand MySQL monitoring fundamentals
MySQL Crash Course: A Hands-on Introduction to Database Development
by Rick SilvaWith databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know.MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It&’s filled withpractical examples and expert advice that will have you up and running quickly.You&’ll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. You&’ll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You&’ll even explore how to call MySQL from PHP, Python, and Java.Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.You&’ll also learn how to:Query database tables for specific information, order the results, comment SQL code, and deal with null valuesDefine table columns to hold strings, integers, and dates, and determine what data types to useJoin multiple database tables as well as use temporary tables, common table expressions, derived tables, andsubqueriesAdd, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule eventsThe perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems.
MySQL Database Service Revealed: Running MySQL as a Service in the Oracle Cloud Infrastructure
by Charles BellAccess all the information you need to begin using the MySQL Database Service (MDS) in the Oracle Cloud Infrastructure (OCI). MDS is Oracle’s new platform as a service (PAAS) offering for open-source database users. This book covers getting started with an account in OCI, gives a brief overview of OCI services available, and provides a short tutorial on MDS. Reading this book helps you take advantage of the powerful OCI features by building your own MySQL database in the cloud. Examples in this book center around running MDS in OCI, and include several of the popular use cases as well as advice on how to implement them. In addition, you will learn more about the related MDS OCI features, such as the high availability features currently available. Finally, you will learn how to back up and restore your data as well as how to get your data into and out of the cloud. The skills you learn in this book will help you get started using MDS and letting Oracle do the heavy lifting of managing MDS operations and implementation.What You Will LearnUse Oracle Cloud Infrastructure (OCI)Deploy MySQL Database Service (MDS) systems in the cloudConnect your applications to MDSBack up and recover using the data recovery features of MDSEmploy the newest high availability features of MDSWho This Book Is ForSystems engineers, developers, and database professionals who want to learn about the powerful features of the MySQL Database Service (MDS) and how to incorporate cloud-based database storage into their infrastructure and applications. Readers who are new to MySQL will appreciate the tutorial chapter, and those familiar with MySQL will learn the latest features of MDS as well as how to build inexpensive, powerful MySQL database servers in the Oracle Cloud Infrastructure (OCI).
MySQL for Python
by Albert LukaszewskiThis is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their MySQL database through Python. If you are a Python programmer who wants database-support in your Python applications, then this book is for you. This book is a must-read for every focused user of the MySQL for Python library who wants real-world applications using this powerful combination of Python and MySQL.
MySQL for the Internet of Things
by Charles BellThis book introduces the problems facing Internet of Things developers and explores current technologies and techniques to help you manage, mine, and make sense of the data being collected through the use of the world's most popular database on the Internet - MySQL. The IoT is poised to change how we interact with and perceive the world around us, and the possibilities are nearly boundless. As more and more connected devices generate data, we will need to solve the problem of how to collect, store, and make sense of IoT data by leveraging the power of database systems. The book begins with an introduction of the MySQL database system and storage of sensor data. Detailed instructions and examples are provided to show how to add database nodes to IoT solutions including how to leverage MySQL high availability, including examples of how to protect data from node outages using advanced features of MySQL. The book closes with a comparison of raw and transformed data showing how transformed data can improve understandability and help you cut through a clutter of superfluous data toward the goal of mining nuggets of useful knowledge. What you'll learn Understand the crisis of vast volumes of data from connected devices Transform data to improve reporting and reduce storage volume Store and aggregate your IoT data across multiple database servers Build localized, low-cost MySQL database servers using small and inexpensive computers Connect Arduino boards and other devices directly to MySQL database servers Build high availability MySQL solutions among low-power computing devices Who this book is for MySQL for the Internet of Things is intended for both hobbyists and professionals who want to learn how to manage their IoT data. Table of Contents 1. The Internet of Things and Data 2. How IOT Data is Stored 3. Hardware for IOT Devices and Data Collection 4. Data Transformation 5. MySQL Primer 6. Building Low-Cost MySQL Database Nodes 7. High Availability IOT Solutions 8. Demonstration of Techniques
MySQL High Availability: Tools for Building Robust Data Centers
by Charles Bell Mats Kindahl Lars ThalmannServer bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.Learn replication fundamentals, including use of the binary log and MySQL Replicant LibraryHandle failing components through redundancyScale out to manage read-load increases, and use data sharding to handle large databases and write-load increasesStore and replicate data on individual nodes with MySQL ClusterMonitor database activity and performance, and major operating system parametersKeep track of masters and slaves, and deal with failures and restarts, corruption, and other incidentsExamine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs
MySQL in a Nutshell
by Russell DyerMySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily. MySQL in a Nutshell is the indispensable desktop reference to all MySQL functions. Programming language APIs for PHP, Perl, and C are covered, as well as all the popular MySQL utilities. This invaluable resource clearly documents the details that experienced users need to take full advantage of this powerful database management system. Better yet, this wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned. In addition to providing a thorough reference to MySQL statements and functions, the administrative utilities, and the most popular APIs, MySQL in a Nutshell includes several tutorial chapters to help newcomers get started. Moreover, each chapter covering an API begins with a brief tutorial so that, regardless of your level of experience in any given area, you will be able to understand and master unfamiliar territory. MySQL in a Nutshell distills all the vital MySQL details you need on a daily basis into one convenient, well-organized book. It will save you hundreds of hours of tedious research or trial and error and put the facts you need to truly tap MySQL's capabilities at your fingertips.
MySQL in a Nutshell
by Russell J.T. DyerMySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily.MySQL in a Nutshell is the indispensable desktop reference to all MySQL functions. Programming language APIs for PHP, Perl, and C are covered, as well as all the popular MySQL utilities.This invaluable resource clearly documents the details that experienced users need to take full advantage of this powerful database management system. Better yet, this wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned.In addition to providing a thorough reference to MySQL statements and functions, the administrative utilities, and the most popular APIs, MySQL in a Nutshell includes several tutorial chapters to help newcomers get started. Moreover, each chapter covering an API begins with a brief tutorial so that, regardless of your level of experience in any given area, you will be able to understand and master unfamiliar territory.MySQL in a Nutshell distills all the vital MySQL details you need on a daily basis into one convenient, well-organized book. It will save you hundreds of hours of tedious research or trial and error and put the facts you need to truly tap MySQL's capabilities at your fingertips.
MySQL in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly))
by Russell J.T. DyerWhen 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. Inside, you'll find:A thorough reference to MySQL statements, functions, and administrative utilitiesSeveral tutorial chapters to help newcomers get startedProgramming language APIs for PHP, Perl, and CBrief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territoryNew chapters on replication, triggers, and stored proceduresPlenty of new examples of how MySQL is used in practiceUseful tips to help you get through the most difficult subjectsWhether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.
MySQL. Leksykon kieszonkowy. II wydanie
by George ReeseMySQL to jeden z najpopularniejszych systemów zarz?dzania bazami danych. Rozprowadzany na zasadzie open source, MySQL jest wykorzystywany jako zaplecze bazodanowe setek tysi?cy serwisów WWW, sklepów internetowych, blogów i galerii. Coraz cz??ciej si?gaj? po niego tak?e twórcy rozbudowanych aplikacji korporacyjnych, poszukuj?cy stabilnej, bezpiecznej i wydajnej platformy do przechowywania danych. W najnowszej wersji, oznaczonej symbolem 5.0, dodano wiele od dawna oczekiwanych funkcji, w tym procedury sk?adowane, wyzwalacze, kursory i widoki. Poprawiono tak?e mechanizmy sk?adowania danych. Je?li jeste? administratorem lub programist? baz danych, ksi??ka "MySQL. Leksykon kieszonkowy. II wydanie" b?dzie dla Ciebie nieocenion? pomoc?. W skondensowanej formie przedstawiono w niej wszystkie najistotniejsze zagadnienia zwi?zane z instalacj? i konfiguracj? tego systemu, a tak?e z zarz?dzaniem nim i wykorzystywaniem go. Znajdziesz tu omówienie typów danych, polece? j?zyka SQL, funkcji i rodzajów tabel. Przeczytasz tak?e o replikacji, procedurach sk?adowanych, narz?dziach dost?pnych z wiersza polece? i wyzwalaczach. Pobieranie i instalacja MySQL Replikacja danych Narz?dzia wiersza polece? Typy danych Polecenia SQL Operatory Procedury sk?adowane Dzi?ki tej ksi??ce Twoja praca z MySQL stanie si? szybsza i efektywniejsza.
MySQL Management and Administration with Navicat
by Gökhan OzarStandard Mini. This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.
MySQL. Mechanizmy wewn?trzne bazy danych
by Sasha PachevPoznaj sekrety jednej z najpopularniejszych baz danych Jak przechowywane sš dane? Jak dodawa? w?asne zmienne konfiguracyjne? Jak przebiega proces replikacji? MySQL to obecnie jedna z najpopularniejszych baz danych. Jednš z jej najwi?kszych zalet jest nieodp?atny dost?p zarówno do samego systemu, jak i do jego kodu ?ród?owego. Mo?liwo?? przeglšdania kodu i -- w razie potrzeby -- samodzielnego modyfikowania go mo?e okaza? si? przydatna programistom tworzšcym aplikacje, które korzystajš z MySQL jako zaplecza bazodanowego. Jednak samodzielne "przegryzanie si?" przez setki tysi?cy linii kodu i rozpracowywanie mechanizmów dzia?ania bazy danych mo?e zajš? mnóstwo czasu. Dzi?ki tej ksiš?ce poznasz kod ?ród?owy i sposób dzia?ania tego narz?dzia. Autor, przez wiele lat pracujšcy w zespole tworzšcym MySQL, przedstawia w niej tajniki systemu. Podczas czytania poznasz architektur? i wzajemne powišzania pomi?dzy komponentami MySQL, struktur? kodu ?ród?owego oraz metody modyfikowania go przez kompilacjš. Dowiesz si? tak?e, jak przebiega komunikacja pomi?dzy klientem i serwerem bazy danych, jak realizowane sš zapytania, w jaki sposób sk?adowane sš dane i jak implementowane sš mechanizmy replikacji. Architektura MySQL Struktura kodu ?ród?owego Komunikacja pomi?dzy klientem i serwerem Zmienne konfiguracyjne Obs?uga ?šda? Parser i optymalizator zapyta? Mechanizmy sk?adowania danych Replikacja danych Dzi?ki tej ksiš?ce zrozumiesz budow? bazy danych MySQL i b?dziesz w stanie samodzielnie dostosowa? jš do ka?dego zadania.
MySQL Pocket Reference: SQL Functions and Utilities
by George ReeseTo help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.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 passwordMySQL data types, including numerics, strings, dates, and complex typesSQL syntax, commands, data types, operators, and functionsArithmetic, comparison and logical operatorsAggregate and general functionsStored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggersYou don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.