MySQL has come up with window function in latest GA MySQL 8.0 . It is a major leap in SQL for MySQL. This presentation provides an overview to window function in MySQL 8.0. https://www.slideshare.net/MyDBOPS/window-functions-in-my-sql-8 Window Function in MySQL 8.0
Data security plays a major role in current age. Privacy matters a lot. Data masking is one of the Key Features when comes to security. In MySQL community versions if you want to mask your data, You can go with a Maxscale load balancer. They introduced a new masking filter on the Maxscale 2.1 version. … Continue reading Security: Data Masking in MySQL 8.0 server
Firstly, let’s start with the Universal Truth: STAY HOME, STAY SAFE, WORK FROM HOME. Said that, we are already aware that database is the schema for any business operations. Procrastination in optimizing the database will lead to a disaster. Hiring a resource considering the present situation is even more tedious. Mydbops can help in your … Continue reading Present Pandemic Situation is Daunting!!! Mitigate your Worries on Database to Mydbops.
Resource management is one of the key thing in all RDBMS. DB Connections is one of them. In PostgreSQL, Allocating more connections without proper analysis of resources causes an overhead in Memory usage and the creation of an OS process for each connection will lead to a scheduling overhead in the time-sharing operating system. These … Continue reading Getting started with PGBouncer in PostgreSQL
One problem I have experienced during logical exporting and importing databases is the tools don’t output any progress indicator (or anything at all really) and using the -v (verbose) switch outputs every single MySQL command being run from the import file. As, importing and exporting of databases is one of the most frequent activity being … Continue reading A Linux Tool to Monitor Progress of MySQL Data Imports and Exports.
A few days ago one of our intern @mydbops reached me with a SQL query. The query scans only a row according to the execution plan. But query does not seems optimally performing. Below is the SQL query and its explain plan. ( MySQL 5.7 ) select username, role from user_roles where username= '9977223389' ORDER … Continue reading Row scanned equals to 1, Is the query is optimally tuned ?
Database schema change is becoming more frequent than before, Four out of five application updates(Releases) requires a corresponding database change, For a DBA schema change is a more often a repetitive task, it might be a request from the application team for adding or modifying columns in a table and many more cases. MySQL supports … Continue reading An Overview of DDL Algorithm’s in MySQL ( covers MySQL 8)