CodeIgniter 4 is a solid, well-designed PHP framework and one I enjoy using and exploring every chance I get. In 2022, the CodeIgniter 4 team released many database-related upgrades. Learn more about the ones I found most significant in this OpenLampTech report.

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.

Head over to the OpenLampTech publication page and read more on this CodeIgniter 4 piece.

Want to support the OpenLampTech publication? …

There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set documentation carefully, it could be hard to know what these configuration options are used for. In addition, for some of the options, unless there is further testing, it could be hard to know how MySQL uses them.

mysql> show variables like 'character_set%'; 
+--------------------------+-------------------------------------+ 
| Variable_name            | Value                               | 
+--------------------------+-------------------------------------+ 
| character_set_client     | utf8mb4                             | 
| character_set_connection | utf8mb4                             | 
| character_set_database   | utf8mb4 …

MySQL community Advent Calendar 2022 - final blog post for the MySQL Community Advent calendar!

OpenLampTech is back with another solid newsletter covering the PHP, MySQL, and LAMP stack media for you. I hope you are enjoying these newsletters. I know I learn and enjoy each and every one of them in more ways than one. Be sure and share the publication with someone else you think would be interested in this content. Thank you!

OpenLampTech has top-level sponsorship opportunities in the weekly newsletter for your brand, product, or service. As a starter publication, collaboration is very budget-friendly. Learn more by inquiring here.

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.

…

MySQL Community Advent Calendar 2023 - in this blog post, we will be discussing how to grant privileges to users in MySQL 8.0

MySQLCommunity Advent Calendar 2022 - Since MySQL 8.0.30, the Dynamic InnoDB Redo Log is a new feature that allows users to resize the redo log files on the fly without the need for a restart. In this blog post, we will explore the new architecture of the Dynamic InnoDB Redo Log and how to manage those logs.

I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. Although MyRocks is very efficient for writes, I chose a more generic workload that will provide a different MyRocks use case.

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB. The storage device has performance characteristics pretty similar to an AWS gp2 EBS volume of about 330 GB in size. I emulated these limits using the KVM iotune settings in my lab.

<iotune>
     <total_iops_sec>1000</total_iops_sec>
     <total_bytes_sec>16384000</total_bytes_sec> …

MySQL Community Advent Calendar 2022 - how to handle UUIDs with MySQL 8.0

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…