In weniger als einer Minute können Sie mit dem Lesen von MySQL Troubleshooting: What To Do When Queries Don't Work auf Ihrem Kindle beginnen. Sie haben noch keinen Kindle? Hier kaufen Oder fangen Sie mit einer unserer gratis Kindle Lese-Apps sofort an zu lesen.

An Ihren Kindle oder ein anderes Gerät senden

 
 
 

Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 

MySQL Troubleshooting: What To Do When Queries Don't Work [Kindle Edition]

Sveta Smirnova

Kindle-Preis: EUR 8,64 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 8,64  
Taschenbuch EUR 21,35  

Produktbeschreibungen

Kurzbeschreibung

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

Über den Autor und weitere Mitwirkende

Sveta Smirnova is a Principle Technical Support Engineer in the Bugs Verification Group of the MySQL Support Group at Ora.

Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 627 KB
  • Seitenzahl der Print-Ausgabe: 266 Seiten
  • Gleichzeitige Verwendung von Geräten: Keine Einschränkung
  • Verlag: O'Reilly Media; Auflage: 1 (8. Februar 2012)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B0077F7T8W
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Amazon Bestseller-Rang: #295.241 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.5 von 5 Sternen  4 Rezensionen
5.0 von 5 Sternen Want to practice troubleshooting? This is the book to read. 12. Mai 2014
Von Anil Vaitla - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Although it is about mysql, the principles in this book apply to the general subject of problem solving. The art of troubleshooting is a tricky subject to teach. Too often in the real world we only read the solution to a problem but not the method and experimentation that led to its discovery. I believe the best way to get better at this subject is with many exercises and real world investigations. Therefore, in my view, the great value of this book is in the large set of examples the author provides of bugs she has encountered and the precise steps taken to fix them with the motivation for why those steps are taken. We can gain great insight in improving our own troubleshooting procedures by asking the right questions as Sveta points out.

For instance suppose there is a query which doesn't work as it should. How would you begin to troubleshoot? Of course try to do a print statement and run in the console. Easy. Now say the query is in a library you cannot modify. The author suggests using general query log (in precise detail) for catching the query and then adding it to a table for diagnosis. As I read it I frequently stopped to think how I might solve it (at first I thought dumping network traffic, but Sveta's solution is much nicer). Furthermore how can 'SHOW WARNINGS' and 'EXPLAIN SELECTED' help here? How do we see the query optimizer output for insight into the problem? It is easy to read about these things, but we need context with exercises or real world bugs to solidfy our understanding about when and why to use these tools. There are even links to the actual bug reports! How awesome is that!
5.0 von 5 Sternen Great book! 15. August 2013
Von Michael Rikmas - Veröffentlicht auf Amazon.com
Format:Kindle Edition|Verifizierter Kauf
Very well described! I love it!
I would recommend it for everyone who is working with MySQL everyday.

5 stars!
3 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Good for MySQL Troubleshooting 3. März 2012
Von Surachart Opun - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book has 7 chapters. On the chapter one, It's explained the simplest about something what I should know before; SQL syntax, MySQL command, some variables and etc. On the chapter two, "You are Not Alone: Concurrency Issues" - Concurrency is important for Database. This chapter is helpful for it. What I learn? For example: Lock and Transactions, Matadata Locking, Monitoring InnoDB Transaction and Concurrency Problems, etc. I believe a lot of DBAs see the lock/concurrency problem. It's good chapter, that`s helpful. Anyway, MySQL has a lot of options/variables, So It's necessary to learn about them. The chapter three, I learned about some options/variables, that effect with database. Good!

That was a little from this book. I rather believe this book is useful for someone who works with MySQL as DBA or Developer.

In this book, it has a good paragraph arrangement. It helps readers easy for reading. It has a lot of examples. It's easy-understand. I think readers can read and practice in the same time. Anyway, I still believe this book be able to figure readers out for MySQL Troubleshooting idea.
0 von 1 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen OK, but little content... 7. Dezember 2013
Von P. Marino - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
ok book, but very little content.... could be reduce to 10 pages. I will look for something else with more depth.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden