I could barely stuff this week’s OpenLampTech issue #31 into the email client to send out. It is that full!

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.

In this week’s OpenLampTech issue #31, we are covering articles on:

• Drupal PWAs
• What is a WordPress Developer?
• PHP OOP concepts and definitions
• WordPress contact form plugin
• 7 pieces of Linux advice
• And much, much more.

Original and curated content. PHP, MySQL, and the LAMP stack. All in one place. Every week. …

Full table scans can be problematic for performance. Certainly if the scanned tables are large. The worst case is when full table scans are involved in joins and particularly when the scanned table is not the first one (this was dramatic before MySQL 8.0 as Block Nested Loop was used) !

A full table scans means that MySQL was not able to use an index (no index or no filters using it).

Effects

When Full Table Scans happen (depending of the size of course), a lot of data gets pulled into the Buffer Pool and maybe other important data from the working set is pulled out. Most of the time that new data in the Buffer Pool might even not be required by the application, what a waste of resources !

You then understand that another side effect of Full Table Scans is the increase of I/O operations.

The most noticeable symptoms of Full Table Scans are:

• increase of CPU usage
• increase of …

Who dares diagram a system and process as complex as InnoDB page flushing? I do.

Who dares diagram a system and process as complex as InnoDB page flushing? I do.

Who dares diagram a system and process as complex as InnoDB page flushing? I do.

If your occupation has anything to do with databases, you face all kinds of routine tasks on data manipulation every day. Does it mean you have to do them all manually? Of course, not. It would consume all your time and raise plenty of risks. There are many convenient IDEs like dbForge Studio for MySQL […]

The post MySQL COUNT() – the Essence, Syntax, and Types appeared first on Devart Blog.

In this article, we’re going to share the MySQL tutorial how to use the MySQL GROUP BY function as well as this function usage together with and without aggregate functions. Contents What is the meaning of the GROUP BY clause in MySQL? GROUP BY syntax in MySQL Simple GROUP BY example GROUP BY and the […]

The post GROUP BY Statement in MySQL With Twelve Examples appeared first on Devart Blog.

We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…

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 kalhh from  …

I’m back again this week with your MySQL, PHP, and LAMP stack media outlet source. There are plenty of great reads in this week’s OpenLampTech newsletter. Enjoy and please share the publication.

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.

There is something for everyone in OpenLampTech issue #30. We have articles covering:

• 20 Laravel tips
• Ignore FSE
• Sorting arrays in PHP
• Linux useradd and adduser commands
• SQL engineering guide
• And much much more…

Don’t …

Is SQL, or Structured Query Language, a programming language? That’s a great question! A question that many answer with emphasis: “No, SQL is not a programming language!” There are some who answer yes; and they usually qualify that answer with something like: “SQL is a programming language designed to communicate with relational databases.”

It strikes me that those saying “yes” are saying that SQL is only a collection of interface methods to read from and write to a database engine. Those saying SQL is not a programming language often qualify that a programming language must have conditional logic and iterative structures, which don’t exist in SQL.

There’s a third group that are fence sitters. They decline to say whether SQL is a programming language, but they also say individuals who only write SQL aren’t programmers. That’s a bit harsh from my perspective.

Before …