↓ 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 Utilities

Category: Utilities

Back Up MySQL View Definitions

By Jesper Krogh Posted on 10 December, 2019 Posted in Backup, MySQL 8.0, MySQL Shell, Utilities No Comments

If you want to back up your table and views, stored procedures, or stored function definitions, you can use mysqldump or mysqlpump to export the schema without the data. However, if you just want the views you need to look …

Back Up MySQL View Definitions 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 »

A Couple of Substring Functions: substr_count() and substr_by_delim()

By Jesper Krogh Posted on 22 October, 2012 Posted in MySQL, Utilities 4 Comments

A problem that sometimes when writing queries or stored routines is the need to use strings to do basic manipulation of the data. While from a performance perspective it is generally faster to do these manipulations inside the application, for …

A Couple of Substring Functions: substr_count() and substr_by_delim() 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