PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

How to create Cloudwatch alarms for RDS (MySQL) on AWS

How to create Cloudwatch alarms for RDS (MySQL) on AWS

26th January, 2021 by in Database

Monitoring your RDS instances is very important, and the same applies to other resources. In this article, we will create a simple alarm for...

Releasing ProxySQL 2.0.16

Releasing ProxySQL 2.0.16

27th January, 2021 by in Database

ProxySQL is proud to announce the latest release of ProxySQL version 2.0.16 on the 26th of January 2021 ProxySQL is a high performance, high...

JOINs - The Basics

JOINs - The Basics

26th January, 2021 by in Database

 JOINs confuse a lot of those new to Structured Query Language (SQL). If you read the various web forums popularly used to ask questions then...

Bye bye MySQL 5.6!

Bye bye MySQL 5.6!

26th January, 2021 by in Database

Adieu MySQL 5.6!When you arrived in 2013 you had a lot of cool new features.  There was the NoSQL Memchache plug-in that was blazingly fast,...

MySQL Membership

MySQL Membership

24th January, 2021 by in Database

MySQL membership conditions are in the MySQL 8 Documentation. They’re found in the 13.2.11.3 Subqueries with ANY, IN, or SOME section. The...

The MySQL X DevApi: Working with NULL Values

The MySQL X DevApi: Working with NULL Values

23rd January, 2021 by in Database

Tweet There was an excellent question from Francis on my MySQL X DevAPI tutorial on how to work with NULL values: Is it possible to store an...

MySQL Invisible Column: part III

MySQL Invisible Column: part III

23rd January, 2021 by in Database

We recently saw how the new Invisible Column feature works in MySQL since 8.0.23 and how we can use it as a Primary Key for InnoDB tables when...

MySQL Invisible Column: part II

MySQL Invisible Column: part II

21st January, 2021 by in Database

This article is the second part of the series related to MySQL Invisible Column started here. This post covers why Invisible Column is important...

Database Performance Archaeology

Database Performance Archaeology

21st January, 2021 by in Database

… an expedition to uncover (and fix) database performance issues! © 2021 Tiago L. Alves. All rights reserved.One of the worse things that...