↓ 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 › 2019 › March

Month: March 2019

MySQL Backup Best Practices

By Jesper Krogh Posted on 31 March, 2019 Posted in Backup, MySQL, MySQL Enterprise Backup, MySQL Enterprise Monitor 2 Comments

Today is World Backup Day, so I thought I would use the opportunity to discuss some best practices and general considerations regarding backing up MySQL instances. While I focus on MySQL, several of these tips apply to backups in general. …

MySQL Backup Best Practices Read more »

Easy Execution of Dynamic Queries with the sys Schema

By Jesper Krogh Posted on 29 March, 2019 Posted in MySQL 5.7, MySQL 8.0, sys Schema No Comments

When you write stored procedures in MySQL, you sometimes need to generate queries on the fly, for example as you process the result of another query. This is supported using prepared statements. This blog explores how you can take advantage …

Easy Execution of Dynamic Queries with the sys Schema Read more »

Testing MySQL NDB Cluster with dbdeployer

By Jesper Krogh Posted on 27 March, 2019 Posted in dbdeployer, MySQL Cluster, Uncategorized 4 Comments

A great way to install MySQL when you need to do quick tests is to use a sandbox tool. This allows you to perform all the installation steps with a single command making the whole process very simple, and it …

Testing MySQL NDB Cluster with dbdeployer Read more »

Using SQLAlchemy with MySQL 8

By Jesper Krogh Posted on 3 March, 2019 Posted in Character Set, Connector/Python, MySQL 8.0, Python, SQLAlchemy 1 Comment

I few months ago, I wrote about using the Django framework with MySQL 8. There are also other Python frameworks that are worth considering. In this blog, I will look at using SQLAlchemy with MySQL 8. In order for you …

Using SQLAlchemy with MySQL 8 Read more »

The Format for Timestamps in MySQL Logs

By Jesper Krogh Posted on 2 March, 2019 Posted in Monitoring, MySQL 5.7, MySQL 8.0 2 Comments

MySQL changed the timestamp format in the log files in MySQL 5.7. Since then, I have a few times seen questions about the new format, and how to change the time zone that is used. Latest in a comment to …

The Format for Timestamps in MySQL Logs 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