Sveta Smirnova's Books

MySQL Troubleshooting

What To Do When Queries Don't Work

By: Sveta Smirnova

Write a review Read reviews Take a Quiz Solve Book Puzzle

MySQL Troubleshooting

What To Do When Queries Don't Work

By: Sveta Smirnova

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL. Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence. Understand the source of a problem, even when the solution is simple Handle problems that occur when applications run in multiple threads Debug and fix problems caused by configuration options Discover how operating system tuning can affect your server Use troubleshooting techniques specific to replication issues Get a reference to additional troubleshooting techniques and tools, including third-party solutions Learn best practices for safe and effective troubleshooting—and for preventing problems

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

265

Publisher

"O'Reilly Media, Inc."

Published Date

ISBN 10

1449312004

ISBN 13

9781449312008

MySQL Cookbook

By: Sveta Smirnova,Alkin Tezuysal

Write a review Read reviews Take a Quiz Solve Book Puzzle

MySQL Cookbook

By: Sveta Smirnova,Alkin Tezuysal

For 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 results Retrieve data from the MySQL Server Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Assess the characteristics of a dataset Write stored functions and procedures Use stored routines, triggers, and scheduled events Perform basic MySQL administration tasks Understand MySQL monitoring fundamentals

Average ratings

N/A