Each SQL dialect is different in some way, shape, form, or
fashion from the next flavor. Some dialects have this
function, while others have that function. In this post, I cover
porting over Oracle SQL to MySQL in order to count the
number of occurrences of a specific weekday found in the current
given month (at the time of writing) purely as a learning
exercise focused on MySQL DATE functions and the
WITH clause…
Image by tigerlily713 from Pixabay
…
[Read more]Sometimes clients want that the information they collected from the user should be encrypted and stored in a database. Data encryption and…
Continue reading on Thinkdiff »
[Read more]
I recently published a blog post over on Medium
about the differences in 2 versions of the MySQL
COUNT() aggregate function: COUNT(*)
and COUNT(column_name or expression). I wanted to
share the post here with any readers who may be interested so
continue reading for more on this post…
Image by anncapictures from Pixabay
Self-Promotion:
If you enjoy the content written here, by …
[Read more]In the last post I covered some of the many reasons to migrate data from a spreadsheet to a database and now it is time to show how to do just that. Moving data from a spreadsheet into MySQL can actually be pretty simple in many cases. Now I will not mislead you by telling you that all cases are easy but there is an easy way to make this migration. And I highly recommend the following process when possible as it can save lots of time. More painful migrations will be covered in the future but this post is my favorite 'fast and easy' process.
This is a guide to taking data from a spreadsheet and easily moving that data into a MySQL database instance. The trick is the Import Wizard in MySQL Workbench that does a lot of the detail work for you. In a future post we will go into what you have to do when you are not …
[Read more]CodeIgniter’s Query Builder ORM has class methods for nearly any kind of database access/operation you can think of. In this post, I’ll cover some of the available methods for retrieving aggregate-level query results. The examples in this post map out Query Builder method chaining to produce results you would get from a raw MySQL query. Continue reading to see more…
Image by Clker-Free-Vector-Images from Pixabay
Self-Promotion:
If you enjoy the content written here, by …
[Read more]Introduction In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema. The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow. On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling. Enabling the MySQL... Read More
The post MySQL Query Profiling Using Performance Schema appeared first on Vlad Mihalcea.
Most developers use some form of auto-incrementing integer
counter for a given database table, ensuring uniqueness
among the rows. Several of the popular SQL dialects implement
this facility. For instance, MySQL’s AUTO_INCREMENT
attribute is used to provide a unique identity for a table row.
What exactly is the behavior of AUTO_INCREMENT? Can
you explicitly use a value of your choosing for it if you need
to? How does it count? Continue reading and know the answers to
these questions and more…
Image by Gerd Altmann from …
[Read more]CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…
Image by OpenClipart-Vectors from Pixabay
Self-Promotion:
If you enjoy the content written here, by all means, …
[Read more]… an expedition to uncover (and fix) database performance issues!
© 2021 Tiago L. Alves. All rights reserved.
One of the worse things that can happen when upgrading to a newer database version is discovering that the performance is not as good as before. Despite the effort put into gate-keeping MySQL NDB Cluster’s strict performance requirements, one of our customers found a performance regression when upgrading from our 7.4 version to our 7.6 version. How did that happen when our automated performance test suite failed to show it? To answer that, and fix the issue we enrolled on a database performance archaeology expedition…
When your performance is not good enough
MySQL NDB Cluster is an open-source in-memory distributed database developed for high-availability (99.999% or more) and predictable query times. It can be found at the core of gaming, banking, telecommunication, and online services. …
[Read more]I recently published a blog post about a portfolio project I am developing using the LAMP stack, Bootstrap 4, jQuery, and the MVC (Model-View-Controller) design pattern in core PHP. In this post, I will introduce an additional feature I integrated into the existing project.
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and …
[Read more]
