Advent Calendar 2022 - How to always use MySQL Shell even if we are used to the old mysql command line client.

If, in Percona Server, you are observing tail latencies on queries that should be fast, this might be a side effect of Percona's improved InnoDB Empty Free List Algorithm.  When using this algorithm (the default in 5.6 and 5.7 and optional configuration in 8.0), a query needing a free page while none are available waits until the LRU Manager Thread refills the free list.  Because this

If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have enough disk space, we will need to wait until the end to start to upload the files, making the whole process longer.

MyDumper implemented stream backup in v0.11.3 and we have been polishing the code since then. We also implemented two ways of executing external commands:

−−exec-per-thread: The worker that is getting the data from the database will write and redirect to the STDIN of the external command. It will be similar to execute cat FILE | command per every written and closed file.

−−exec: In this case, the worker writes in the local storage and when the file is closed, the filename is enqueued. The exec …

MySQL stores data in the form of one or many tables and sometimes these tables become useless but take up some space, to free up the space and get rid of these tables, we can delete them by simply dropping them from the MySQL database. Drop a table means deleting the table permanently from the …

NodeJS MySQL Drop Table Read More »

MySQL is a relational database management system that stores data in one or more tables of rows and columns and uses structured query languages to perform different operations on them. MySQL can be used in NodeJS to store large amounts of data, and we can retrieve data quickly due to its simple structure using SQL …

NodeJS MySQL Select Record Read More »

Creating a table is extremely important for storing data in multiple rows and columns in a MySQL database. MySQL stores data in the form of a table which can be created using SQL queries, SQL stands for Structured Query Language and can be used to perform different operations on MySQL database. The below query is …

NodeJS MySQL Create Table Read More »

While the LAMP stack – Linux/Apache/MySQL/PHP – is not the dominant platform it was a decade ago, there are still many websites that depend on it. One of the pillars of this quartet had a milestone last week when PHP 8.0 passed into End Of Life status. While it will still have limited security issue support for another year, 8.0 should be phased out of your environments.

By the way, 8.1 has another year until it reaches End of Life status.

So please update your PHP 8.0 as soon as you can, double check the connector you are using to access your database is updated too, and make sure you are ready for 8.1’s future.

And make sure that if you are currently running MySQL 5.7 that you upgrade by October 2023 when it too reaches End of Life.

MySQL Database is used to store the collection of records in the form of tables consisting of rows and columns. The Database in MySQL can be handled using SQL queries. SQL stands for Structured Query Language, which can perform many operations such as create, select, update, delete, etc on the database. For creating a database …

NodeJS MySQL Create Database Read More »

MySQL is a relational database management system that stores data in one or more tables of columns and uses structured query languages to perform different operations on them. For interacting with MySQL Database it is required to run a MySQL server in the background. You can install MySQL from https://www.mysql.com/downloads/.  Installation and Setup of MySQL …

NodeJS MySQL Create Connection Read More »

In my honest opinion, MS Access is one garbage of a database. More likely, database is too strong of a word. While I won’t be using Access in this article, there is a story there (but I’m not here to have an Access bash party). Continue reading for an example of how you may use a correlated subquery and simulate the LEAD() Window Function.

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.

Image by  …