This tutorial explains MySQL UPPER()/UCASE() functions which convert the lower case characters of a string to upper case. We’ll describe the functioning of this method with the help of simple examples. 1. UPPER()/UCASE() Syntax 2. UPPER()/UCASE() to convert text to upper case 3. UPPER()/UCASE() on table data 4. UPPER()/UCASE() on binary text Let’s now go through each of the section one by one. MySQL UPPER()/UCASE() Functions As stated initially, UPPER() is a built-in MySQL function which changes a string value to upper case. So, let’s now see the details and check out how can we use it. Syntax Below is

The post MySQL UPPER() and UCASE() Functions Explained appeared first on Learn Programming and Software Testing.

The ability to import data in parallel is now a feature of the new MySQL Shell.  And you can run it from a command line instead of from within an interactive shell.

How Does It Work?
The importTable utility, new on MySQL Shell 8.0.17,  analyzes the input file, divides that file into chunks, and then uploads that data using parallel connections.  This is much faster than the LOAD DATA statement. You get the ability to define how the data is delimited as far a field and lines are defined.  And it works on DOS CSVs, Unix CSVs, TSVs, and JSON if that JSON is in one document per line mode. You also can adjust the number of threads, number of bytes sent per each chunk, and the maximum rate of data transfer per thread so you can balance the load on the network and the speed of data …

Some time ago, I was building a new MySQL DB server (5.7.25) and like all DBAs, I have a template of my.cnf that I use for the new instances after changing a few variables based on the instance resources, replication … etc. I had MySQL installed but I struggled on having the service started!

MySQL failed to start, no errors were printed at all in the MySQL error log – or the log was not created from the first place – even no errors in the system log and I had no clue what was going on!

After some digging in, I found the bad guy! The variable secure_file_priv referred to a directory that didn’t exist. When I had the directory created, everything was fine and the service started.

I tried to repeat the same scenario in MySQL 8 and it was much better. The error log indicated the root cause of the issue as below:
2019-03-25T23:39:59.810992Z 0 [ERROR] [MY-010095] [Server] Failed …

In reply to dasagrivamanu.

Thanks for your feedback. I do use code blocking but I’d consider changing the style to make it more clear.

LikeLike

From time to time, you might notice that your MySQL database suddenly under-performs. To quickly locate the root cause, one might start digging into MySQL slow query logs, trying to locate the query(ies) taking up the server's resources.

Those slow log files contain lots of metrics for each query execution, which can be overwhelming, especially if you have a busy application with lots of queries constantly being executed.

There are several command line tools out there, doing a fantastic job in analyzing those slow log files and summarizing them (examples: pt-query-digest, mysqldumpslow), so if you never used them, you should definitely check them out.

If you're looking for a more visual way to look at those slow logs, another option …

In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch.

The clone plugin permits cloning data locally or from a remote MySQL server instance. The cloned data is a physical snapshot of data stored in InnoDB, and this means, for example, that the data can be used to create a standby replica.

Let’s go to the hands-on and see how it works.

Installation & validation process of the MySQL 8.0.17 clone plugin

Installation is very easy and it works in the same as installing other plugins. Below is the command line to install the clone plugin:

master …

The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the Raspberry Pi 3+.

This how-to post covers installing from source and being able to use Percona Server for MySQL in any of your maker projects. I have included everything you need to have a complete Percona Server, ready to store data collection for your weather station, your GPS data, or any other project you can think of that would require data collection in a database.

My years of hands-on support of Percona Server enable me to customize the install a bit. I wanted to build a full Percona …

Last time we used the New MySQL Shell to set up a sandbox instance of InnoDB Cluster in Six Steps. Now to make that cluster function we need to start up MySQL Router to proxy connections. And since we do not show how to do things with Windows, we will configure Router on that Operating System.

Cleaning Up From Last TimeIf you followed the instructions from last time you may find you InnoDB Cluster non functional.  If you have rebooted then you will find that the component pieces of the cluster have not been started.  To clean things up you will have to do the following:

• dba.killSandboxInstance(3310)
• dba.deleteSandboxInstance(3310)
• …

Continuent is pleased to announce that the following new software releases are now available:

• Tungsten Clustering version 5.4.0
• Tungsten Replicator version 5.4.0

Releases 5.4.0 is significant in that it introduces MySQL 8 support, along with many new features, stability improvements and bug fixes.

Highlights common to both products:

Improvements, new features and functionality

• Two new utility scripts have been added to the release to help with setting the Replicator position:
  • tungsten_find_position, which assists with locating information in the THL based on the provided MySQL binary log event position and outputs a dsctl set …