↓ Skip to Main Content
Jesper's MySQL Blog

Jesper's MySQL Blog

Main Navigation

  • Home
  • Recent Activity
    • Latest Posts
    • Top Posts
    • Latest Tweets
    • MySQL Shell Blogs
  • My Books
    • MySQL Concurrency
    • MySQL 8 Query Performance Tuning
    • MySQL Connector/Python Revealed
    • Pro MySQL NDB Cluster
  • MySQL Books
    • My Books
    • Books by Oracle Employees
  • Who Am I?
  • Privacy Policy
Home › Archive for Book

Category: Book

Updates to Code for MySQL Concurrency – v1.1 and v1.2

By Jesper Krogh Posted on 25 July, 2021 Posted in Book, Contribution, MySQL Shell No Comments

When I wrote the book MySQL Concurrency I included a Python module for MySQL Shell that would help reproducing the examples in the book. Since things change, it has been necessary to update the code. In this blog I will …

Updates to Code for MySQL Concurrency – v1.1 and v1.2 Read more »

New Book: MySQL Concurrency

By Jesper Krogh Posted on 29 January, 2021 Posted in Book No Comments

In March 2020, my book MySQL 8 Query Performance Tuning (Apress) was released. That book with its more than 900 pages in 27 chapters covered a wide range of topics from executing benchmarks with sysbench over indexes and the optimizer …

New Book: MySQL Concurrency Read more »

Apress Blog: MySQL Performance Tuning Best Practices

By Jesper Krogh Posted on 29 April, 2020 Posted in Book, MySQL 8.0, Performance No Comments

To celebrate the publishing of my new book MySQL 8 Query Performance Tuning, the Apress team invited me (thanks Jonathan and Liz) to write a post for the Apress blog. I decided to write about my top six best practices: …

Apress Blog: MySQL Performance Tuning Best Practices Read more »

New Book: MySQL 8 Query Performance Tuning

By Jesper Krogh Posted on 21 March, 2020 Posted in Book, Monitoring, Performance No Comments

I have over the last few years been fortunate to have two books published through Apress, Pro MySQL NDB Cluster which I wrote together with Mikiya Okuno and MySQL Connector/Python Revealed. With the release of MySQL 8 around a year …

New Book: MySQL 8 Query Performance Tuning Read more »

Apress Blog About MySQL Connector/Python

By Jesper Krogh Posted on 21 August, 2018 Posted in Book, Connector/Python, Python No Comments

Apress have been kind enough to invite me to write a blog in connection with my recently released book MySQL Connector/Python Revealed. I chose to write an introduction of MySQL Connector/Python including three examples illustrating the APIs and the difference …

Apress Blog About MySQL Connector/Python Read more »

New Book: MySQL Connector/Python Revealed

By Jesper Krogh Posted on 13 August, 2018 Posted in Book, Connector/Python, MySQL, Python No Comments

When you write programs that uses a database backend, it is necessary to use a connector/API to submit the queries and retrieve the result. If you are writing Python programs that used MySQL, you can use MySQL Connector/Python – the …

New Book: MySQL Connector/Python Revealed Read more »

What is MySQL NDB Cluster?

By Jesper Krogh Posted on 14 February, 2018 Posted in Book, MySQL Cluster

I have had the opportunity to write a blog for Apress with a brief introduction to MySQL NDB Cluster. The blog gives a brief overview of the history and why you should consider it. The architecture is described before some …

What is MySQL NDB Cluster? Read more »

New Book: Pro MySQL NDB Cluster

By Jesper Krogh Posted on 11 November, 2017 Posted in Book, MySQL, MySQL Cluster, MySQL Cluster 7.5

It is with great pleasure, I can announce that a new book dedicated to MySQL NDB Cluster has just been released. The book Pro MySQL NDB Cluster is written by my colleague Mikiya Okuno and myself and is a nearly …

New Book: Pro MySQL NDB Cluster Read more »

Search

Twitter

Follow @JWKrogh

Books

The cover for MySQL Concurrency Order it from:
📚 Apress
📚 Amazon
📚 Barnes & Noble
📚 Saxo

The cover for MySQL 8 Query Performance Tuning Order it from:
📚 Apress
📚 Amazon
📚 Barnes & Noble
📚 Saxo

The cover for MySQL Connector/Python Revealed Order it from:
📚 Apress
📚 Amazon
📚 Barnes & Noble
📚 Saxo

The cover for Pro MySQL NDB Cluster Order it from:
📚 Apress
📚 Amazon
📚 Barnes & Noble
📚 Saxo

Recent Posts

  • Automatic update of InnoDB Persistent Statistics Never Triggers
  • Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables
  • Updates to Code for MySQL Concurrency – v1.1 and v1.2
  • MySQL Query Attributes
  • New Book: MySQL Concurrency

Recent Comments

  • Oscar on MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default
  • John on Install MySQL 8 on Linux with lower_case_table_names = 1
  • Addy on Replication Monitoring with the Performance Schema
  • Jesper Krogh on Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables
  • rockbie on Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables

Archives

  • August 2021
  • July 2021
  • February 2021
  • January 2021
  • October 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • October 2019
  • September 2019
  • July 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • March 2018
  • February 2018
  • November 2017
  • May 2017
  • January 2014
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • May 2013
  • February 2013
  • December 2012
  • October 2012
  • September 2012
  • August 2012

Categories

  • Backup
  • binlog_transaction_compression
  • binlog_transaction_compression_level_zstd
  • Book
  • Certification
  • Character Set
  • Cloud
  • Common Table Expression (CTE)
  • Conference
  • Connector/Python
  • Contribution
  • Curses
  • dbdeployer
  • Django
  • Encryption
  • Foreign Keys
  • Index Statistics
  • InnoDB
  • iOS
  • JavaScript
  • JSON
  • Locking
  • lower_case_table_names
  • Monitoring
  • Mutex
  • MySQL
  • MySQL 5.6
  • MySQL 5.7
  • MySQL 8.0
  • MySQL Cluster
  • MySQL Cluster 7.3
  • MySQL Cluster 7.4
  • MySQL Cluster 7.5
  • MySQL Cluster 7.6
  • MySQL Connect 2012
  • MySQL Connect 2013
  • MySQL Enterprise Backup
  • MySQL Enterprise Monitor
  • MySQL Shell
  • MySQL Workbench
  • node.js
  • Node.js
  • NoSQL
  • Optimizer
  • Options
  • Oracle Code One
  • Oracle OpenWorld
  • Performance
  • Performance Schema
  • Python
  • Pythonista
  • Query Attributes
  • Replication
  • Slides
  • SQLAlchemy
  • sys Schema
  • Transacftion Isolation Level
  • Uncategorized
  • Utilities
  • Variables
  • X DevAPI

Who am I?

I have worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. I have spoken at MySQL Connect and Oracle OpenWorld on several occasions. I have contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0.

I have written four books, all published at Apress.

Comments and opinions are my own and do not necessarily reflect the views of my employer.

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
© 2023 Jesper's MySQL Blog | Powered by Responsive Theme