A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…
The post MySQL Slow query log export and review in RDS first appeared on Change Is Inevitable.
If you’re looking for your PHP, MySQL, and LAMP stack media source, you’ve found it in OpenLampTech. I have one massive – and excellent – newsletter for you this week. Check it out!
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
OpenLampTech issue #80 is sharing content on:
An inordinate amount of our Galera Cluster customer base is still using the MySQL 5.7 variant of Galera Cluster. Besides not being able to have access to all the new features of the Galera 4 library, MySQL 5.7 is rapidly reaching End of Life (EOL) status in October 2023. This is less than six months away, and it is also why we would like to focus on getting our users upgraded to MySQL 8.0 with Galera Cluster.
Firstly, MySQL 8 has been Generally Available (GA) since 19 April 2018. That is a whole five years, and you must by now, already know that there is a new release model, where there are new features included in minor releases. The release notes are a must read. Next, Codership released Galera Cluster 4 with MySQL 8 with MySQL 8.0.19, on …
[Read more]The post explains how to use MySQL Enterprise Data Masking and De-Identification Features.
I am finalizing my Percona Live talk MySQL and Vitess (and Kubernetes) at HubSpot. In this talk, I mentioned that I like that Percona is providing better MySQL with Percona Server. This comes with a little inconvenience though: with improvements, sometimes comes regression. This post is about such regression and a workaround I implemented some time ago (I should have shared it
Welcome to the OpenLampTech developer newsletter. Thank you so much for reading each week. I am bringing you the media source for PHP, MySQL, and the LAMP stack you can depend on.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
I am sharing so many good articles this week in OpenLampTech issue #79. Visit those …
[Read more]MySQL Shell offers an upgrade over legacy MySQL CLI tools. One set of features that gets a boost is dumping and loading data. MySQL Shell allows users to load and dump data using a multithreaded process and to be more granular in what data is dumped and loaded than when using mysqldump. In this post we discuss how to use these utilities to dump specific tables in a schema, specific data in specific tables in a schema, one or more schemas simultaneously, and an entire MySQL instance.
Explore the powerful features of Aurora Serverless V2 for MySQL in this informative blog series. Learn about read-only scaling, parameter support, and cost performance. Compare costs between Provisioned Aurora and Aurora Serverless V2. Discover key takeaways for optimizing your MySQL deployment on the cloud. Read now!
[Read more]Character sets and collations are fundamentally important concepts to understand when dealing with string columns in MySQL. A slight misunderstanding of either can lead to poor performance or unexpected errors when inserting data. A character set defines the characters allowed to go in a column. A collation is a set of rules for comparing those characters. Each character set can have multiple collations, but a collation may only belong to one character set. Character sets in MySQL MySQL supports a wide range of character sets, which you can view by selecting from the information_schema database.SELECT * FROM information_schema.character_sets ORDER BY character_set_name
This will list out all of the character sets, along with their default collations. Every character set has one default collation.| CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION | MAXLEN | …
[Read more]Understanding the differences between character sets and collations in MySQL.
