↓ 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 › 2013

Year: 2013

Install MySQL Enteprise Monitor (MEM) 3.0 Using Limited Resources

By Jesper Krogh Posted on 28 November, 2013 Posted in Monitoring, MySQL Enterprise Monitor, Performance No Comments

MySQL Enterprise Monitor (MEM) is the monitoring solution offered as part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition. In this blog, I will not go into details of the features of MEM, but rather focus on the …

Install MySQL Enteprise Monitor (MEM) 3.0 Using Limited Resources Read more »

MySQL Connect 2013: ps_tools

By Jesper Krogh Posted on 10 October, 2013 Posted in MySQL, MySQL Connect 2013, Performance Schema, Utilities No Comments

During my talk and hands on labs at MySQL Connect 2013 I used several views, functions, and procedures from ps_helper and ps_tools. The slides from the two talks can be downloaded from Thanks For Attending MySQL Connect or from the …

MySQL Connect 2013: ps_tools Read more »

Thanks For Attending MySQL Connect

By Jesper Krogh Posted on 25 September, 2013 Posted in MySQL, MySQL Connect 2013, Performance Schema, Slides No Comments

MySQL Connect 2013 was held this past Saturday through Monday, and I would like to extend a big thank you to everyone who attended my sessions, I talked to or otherwise took part in the conference. I had two sessions …

Thanks For Attending MySQL Connect Read more »

Speaking at MySQL Connect 2013

By Jesper Krogh Posted on 14 August, 2013 Posted in MySQL Connect 2013 No Comments

It is hard to believe it is already closing in on a year since the last MySQL Connect, but it is true, it is time to start preparing again. This year MySQL Connect will take place in the weekend of …

Speaking at MySQL Connect 2013 Read more »

New Member of the Cluster API Family: The Native Node.js Connector

By Jesper Krogh Posted on 19 June, 2013 Posted in MySQL, MySQL Cluster, MySQL Cluster 7.3, node.js No Comments

MySQL Cluster 7.3 went GA yesterday and with it came a new member of the MySQL Cluster API family: mysql-js – a native Node.js connector. mysql-js uses the NDB API to connect directly to the data nodes which improves performance …

New Member of the Cluster API Family: The Native Node.js Connector Read more »

Easier Overview of Current Performance Schema Setting

By Jesper Krogh Posted on 20 May, 2013 Posted in MySQL, MySQL 5.6, MySQL Connect 2012, Performance Schema No Comments

While I prepared for my Hands-On Lab about the Performance Schema at MySQL Connect last year, one of the things that occurred to me was how difficult it was quickly getting an overview of which consumers, instruments, actors, etc. are …

Easier Overview of Current Performance Schema Setting Read more »

Changing the Size of the InnoDB Log Files In MySQL 5.6

By Jesper Krogh Posted on 24 February, 2013 Posted in MySQL, MySQL 5.6 No Comments

In MySQL 5.5 and earlier, the steps to resize the InnoDB log files were a bit involved and for example included manually moving the log files out of the way as InnoDB would only create new files, if none existed. …

Changing the Size of the InnoDB Log Files In MySQL 5.6 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

  • 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

  • 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
  • Ilya on Automatic Decryption of MySQL Binary Logs Using Python

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
© 2022 Jesper's MySQL Blog | Powered by Responsive Theme