High availability and replication is a must for any production environment in order to have a back-up process in place with minimum interruption in case of failure. In this article, I'll explain how to configure this architecture for MySQL HeatWave on OCI.
Jun
20
2022
Jun
20
2022
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. …
[Read more]
Jun
20
2022
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 …
Jun
18
2022
Who dares diagram a system and process as complex as InnoDB page flushing? I do.
Jun
18
2022
Who dares diagram a system and process as complex as InnoDB page flushing? I do.
Jun
18
2022
Who dares diagram a system and process as complex as InnoDB page flushing? I do.
Jun
16
2022
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.
Jun
15
2022
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.
Jun
15
2022
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 …
[Read more]
Jun
13
2022
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 …
[Read more]