↓ 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 › MySQL › Archive for Variables

Category: Variables

More Statistics for Slow Queries: log_slow_extra

By Jesper Krogh Posted on 31 January, 2019 Posted in Monitoring, MySQL 8.0, Performance, Variables 5 Comments

The slow query log is the trusted old method of recording slow query, so the database administrator can determine which queries are in the most need for optimization. Since MySQL 5.6, it has to some extend been overshadowed by the …

More Statistics for Slow Queries: log_slow_extra Read more »

MySQL 8.0: Persisted Variables

By Jesper Krogh Posted on 14 August, 2018 Posted in MySQL, Options, Variables

MySQL 8.0 introduced a new feature that allows you to persist configuration changes from inside MySQL. Previously you could execute SET GLOBAL to change the configuration at runtime, but you needed to update your MySQL configuration file in order to …

MySQL 8.0: Persisted Variables Read more »

Changes to Options and Variables in MySQL 5.6

By Jesper Krogh Posted on 6 February, 2013 Posted in MySQL, MySQL 5.6, Options, Variables No Comments

With MySQL 5.6 just gone GA, I thought it would be good to take a look at the changes in options and variables that comes with the new release. First of all, several of the existing options have get new …

Changes to Options and Variables in MySQL 5.6 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

  • MySQL Query Attributes
  • New Book: MySQL Concurrency
  • The MySQL X DevApi: Working with NULL Values
  • I Am Speaking at Oracle Developer Live – MySQL 2020
  • Happy Birthday MySQL

Recent Comments

  • Mysql Best Practices - Mysql Backup Best Practices €“ - Jesper'S Mysql Blog on MySQL Backup Best Practices
  • New Book: MySQL Concurrency – Jesper's MySQL Blog on New Book: MySQL 8 Query Performance Tuning
  • Jesper Krogh on NoSQL/X DevAPI Tutorial with MySQL Connector/Python 8.0
  • The MySQL X DevApi: Working with NULL Values – Jesper's MySQL Blog on NoSQL/X DevAPI Tutorial with MySQL Connector/Python 8.0
  • francis on NoSQL/X DevAPI Tutorial with MySQL Connector/Python 8.0

Archives

  • 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
  • InnoDB
  • iOS
  • JavaScript
  • JSON
  • 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
  • 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
© 2021 Jesper's MySQL Blog | Powered by Responsive Theme