This post is the final one of a series of articles on extending MySQL with the Component Infrastructure:
It is always hard to select a CPU for your own purpose. You could waste hours reviewing different benchmarks, reviews, and bloggers, and in the end, we would limit all our requirements to performance and price. For performance measuring we already have some specific metrics (e.g. in MHz to some specific tool), however, for economic comparison, it is quite hard. Mostly we are limited by our budget. Again, for our personal purposes, we are limited only with the cash in our pockets. It is easy to compare only two or three CPUs; it is required just to compare their price and performance and then create a simple bar plot and then check the results. However, what do you do if you have at least three types of CPU, a different number of CPUs cores on board, and seven different scenarios? It was a challenge to do it for performance, and for economic efficiency, it has become a nightmare. For a one-time purchase, it should be easier than for the …
[Read more]Getting a count of table or query rows in CodeIgniter 4 is quite easy using either of the Query Builder countAll() or countAllResults() functions. Continue reading to see examples of each…
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
[Read more]Apache Zeppelin is a web-based notebook notebook that enables data-driven, interactive data analytics, machine learning, and collaborative documents with SQL, Scala, Python, R. In this article, we explain how to enable HeatWave to accelerate the SQL queries.
A database is a special kind of structured, persistent, global variable with concurrent access over the network.
You write data to a cell of a row of a table in a schema in the server, and it is being kept around for you, with a lifetime longer than the runtime of your program. The database takes care of making sure of ordering access to that data, so there is a clearly defined series of changes to the data – locking, transactions, isolation are things that make databases popular.
And so one gets to have a lot of database schemas in server instances, and they grow. Sometimes that becomes a problem.
Databases don’t scale, even when they scale
These days, the MySQL server can easily utilize the resources even of very large servers. At work, we have taken instances easily up to 400.000 queries per …
[Read more]In this tutorial, you’ll learn how to build a mood tracker application with Laravel 9, connect it to a PlanetScale MySQL database, make database schema changes, and deploy your database branch to production. You’ll use PlanetScale for the database, which gives you a fully managed MySQL-compatible database, unlimited scalability, a Git-like development workflow, zero downtime schema changes, and more. This blog post is over a year old and may be out of date.
Here are some of the highlights of what you’ll create: A production-ready MySQL database in PlanetScale 2 database branches: main for production and dev for development 2 tables, moods and entries, to store your daily entries and mood options Database migrations and a seeder to run on your development database Deploy non-blocking schema changes from development to production with PlanetScale branching and deploy requests. If you just want to get up and running with Laravel and …
[Read more]Learn how to build a Laravel CRUD application connect it to a MySQL database and seed it with data.
On the previous article we saw how to easily deploy Apache Zeppelin on OCI with MySQL using Terraform.
In this article we will see how we can accelerate queries enabling MySQL HeatWave.
Enabling HeatWave
If you used a MySQL Database Service Shape compatible with
HeatWave (MySQL.HeatWave.VM.Standard.E3), using the
same Resource Manager Stack, you have the possibility to enable
HeatWave and deploy a HeatWave Cluster for your MySQL.
The first think to do, is to edit the previous applied stack:
As we used a HeatWave compatible shape, we have the choice to deploy a HeatWave Cluster and we can choose it:
Save and Apply… the HeatWave cluster will be added:
If you …
[Read more]Apache Zeppelin is a web-based notebook that enables data-driven, interactive data analytics, machine learning, and collaborative documents with SQL, Scala, Python, R. In this article we will see an easy method to deploy Apache Zeppelin on Oracle Cloud with MySQL Database Service.
Recently, somebody requested some help as he was trying to modify the structure of a large table. The requested modification was related in changing a fixed length string to a variable length string column.
If you don’t know it yet, MySQL supports multiple algorithms when altering a table (DDL):
The operation that interests us today needs to copy the full table. And this was the problem for the user as the MySQL Datadir could not store twice the amount of that large table.
In this blog post I will explain a method that can be used to solve this problem. There are also others method like a logical dump …
[Read more]