In a couple previous posts, I explained how to get an “Always Free” Oracle Cloud compute instance and how to install MySQL on it – as well as how to add a web server.
I started my IT career (way back in 1989) using a (dumb) terminal and a 2400-baud modem to access a server. While I still use a terminal window and the command-line, it is always nice to have access to a GUI. In this post, I will show you how to install and use a GUI on your Oracle Cloud …
[Read more]As Grafana powers our star product – Percona Monitoring and Management (PMM) – we have developed a lot of experience creating Grafana Dashboards over the last few years. In this article, I will share some of the considerations for designing Grafana Dashboards. As usual, when it comes to questions of design they are quite subjective, and I do not expect you to chose to apply all of them to your dashboards, but I hope they will help you to think through your dashboard design better.
Design Practical Dashboards
Grafana features many panel types, and even more are available as plugins. It may be very attractive to use many of them in your dashboards using many different visualization options. Do not! Stick to a few data visualization patterns and only add additional visualizations when they provide …
[Read more]
In the first part of this article related to the
check plugin, we discovered information retrieved from the binary
logs. This part, is about what Performance_Schema
and SYS can provide us about the queries hitting the
MySQL database.
Currently, 3 methods are available:
getSlowerQuery()
getQueryTempDisk()
getFullTableScanQuery()
The method’s name should be self explaining.
This is an overview of the parameters for each methods:
ext.check.getSlowQuery()ext.check.getQueryTempDisk()ext.check.getFullTableScanQuery()
Some methods allow a select parameter if only
SELECT statements should be returned.
When only one query is returned (default), it’s also possible to …
[Read more]In the first part of this blog, we covered a deployment walkthrough of MySQL InnoDB Cluster with an example on how the applications can connect to the cluster via a dedicated read/write port.
In this operation walkthrough, we are going to show examples on how to monitor, manage and scale the InnoDB Cluster as part of the ongoing cluster maintenance operations. We’ll use the same cluster what we deployed in the first part of the blog. The following diagram shows our architecture:
We have a three-node …
[Read more]LIVE WEBINAR: Wednesday, November 27, 2019. 9AM PDT. Migrating to MySQL 8.0 from 5.6 or 5.7. Planning to upgrade to 8.0? Join us to learn the easy steps and best practices for a smooth upgrade. Register now!All opinions expressed in this blog are those of Dave Stokes who is actually amazed to find anyone else agreeing with him
Today, I will describe MySQL database connectivity with golang. MySQL is most popular open source relational database. I will let you know step by step how to golang connect with MySQL database. I assumed you have configured golang environment within your system, if not please configure golang environment into your system. The golang have MySQL […]
The post How to Connect Golang with MySQL appeared first on Phpflow.com.
In this blog post, we will see how to use perf (a.k.a.: perf_events) together with Flame Graphs. They are used to generate a graphical representation of what functions are being called within our software of choice. Percona Server for MySQL is used here, but it can be extended to any software you can take a resolved stack trace from.
Before moving forward, a word of caution. As with any profiling tool, DON’T run this in production systems unless you know what you are doing.
Installing Packages Needed
For simplicity, I’ll use commands for CentOS 7, but things should be the same for Debian-based distros (apt-get install linux-tools-$(uname -r) instead of the yum command is the only difference in the steps).
To install perf, simply issue:
SHELL> sudo yum install -y perf…[Read more]
By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well. In this blog post, we discuss an approach to optimize the MySQL index creation process in such a way that your regular workload is not impacted.
MySQL Rolling Index Creation
We call this approach a ‘Rolling Index Creation’ - if you have a MySQL master-slave replica set, you can create the index one node at a time in a rolling fashion. You should create the index only on the slave nodes so the master’s …
[Read more]
This blog was initially referring to the audit
plugin, but I renamed it as check plugin to be more
compatible with all the current and future methods included in
it.
As you may know, it’s now possible to create your own plugins for MySQL Shell. See the following posts:
I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions. In this blog series, I will look into how you can install MySQL, MariaDB, or Percona Server for MySQL with Docker. This post, part one, is focused on MySQL Server.
Docker is actually not my most preferred way as it does not match a typical production install, and if you look at service control behavior or file layout it is quite different. What is great about Docker though is that it allows installing the latest MySQL version – as well as any other version – very easily.
Docker also is easy to use when you need a simple, single instance. If you’re looking into some replication-related behaviors, …
[Read more]