Planet MariaDB Server

In PostgreSQL, the process of parsing and binding is a critical part of the SQL query processing that occurs before the optimizer comes into play. This phase ensures that the SQL statements are correctly interpreted, […] The post Understanding Parsing and Binding in PostgreSQL’s Query Processing Pipeline appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

In PostgreSQL, the mechanism of index selection is a crucial component of the query planner, which evaluates various possible execution plans to determine the most efficient way to execute a given query. Index selection involves […] The post Understanding Index Selection Mechanics in PostgreSQL: How the Query Planner Optimizes Performance appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]… Read more

For me, the Redis story starts with…  Memcached.   Back in the early 2000s, “Web 2.0” was being built following the aftermath of the dot-com crash.  The open source  LAMP (Linux-Apache-MySQL-PHP/Perl/Python) stack was all the rage.  We needed to scale fast but also very efficiently, and caching became one of the core technologies to achieve […]… Read more

FromDual is pleased to announce the release of the new version 1.2.2 of the popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases. The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBAs and system administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes life easier for DBAs and Admins! The main purpose of the Ops Center is to help you with your daily MariaDB and MySQL operations. More information about FromDual Ops Center can be found in the General Information section. Download now The… Read more

FromDual is pleased to announce the release of the new version 1.2.2 of the popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases. The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBAs and system administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes life easier for DBAs and Admins! The main purpose of the Ops Center is to help you with your daily MariaDB and MySQL operations. More information about FromDual Ops Center can be found in the General Information section. Download now The… Read more

Understanding the principle of the hyperbola and its relation to queuing theory can provide valuable insights when troubleshooting performance issues in PostgreSQL, especially those related to concurrency and resource contention. The hyperbola, a curve represented […] The post Applying the Hyperbolic Principle in PostgreSQL Performance Troubleshooting: Insights into Queueing Theory and Resource Management appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Table of contents Review One month later Size of the tables Process list Global variables Metadata Lock and InnoDB Transaction Lock Global status Review After we introduced dbstat for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food). This went quite well until we came up with the idea of activating dbstat on the passive dbstat node on our MariaDB active/passive master/master replication cluster (a similar situation would also occur with a Galera cluster). We realised that the design of… Read more

Table of contents Review One month later Size of the tables Process list Global variables Metadata Lock and InnoDB Transaction Lock Global status Review After we introduced dbstat for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food). This went quite well until we came up with the idea of activating dbstat on the passive dbstat node on our MariaDB active/passive master/master replication cluster (a similar situation would also occur with a Galera cluster). We realised that the design of… Read more

Elasticsearch is a complex software incomparable to other mainstream database software, whether it’s RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics. Elasticsearch works as part of the ELK stack (Elastic, Logstash, Beats, and Kibana). It can also be used with other […] The post How to setup and install Elasticsearch: From a single node to a cluster of nodes appeared first on Severalnines…. Read more

Elasticsearch is a complex software incomparable to other mainstream database software, whether it’s RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics. Elasticsearch works as part of the ELK stack (Elastic, Logstash, Beats, and Kibana). It can also be used with other […] The post How to setup and install Elasticsearch: From a single node to a cluster of nodes appeared first on Severalnines…. Read more

We are pleased to inform you that a new maintenance release of MariaDB Enterprise Server 10.6 is available. This is … Continued… Read more

Percona.connect, a series of free events hosted by Percona database performance experts, is coming to a city near you!  This amazing learning opportunity spans six cities — across two continents — and includes educational sessions, customer testimonials, networking activities, and more. Don’t miss your chance to talk with technical evangelists, MySQL, PostgreSQL, and MongoDB experts, Percona […]… Read more

Progress Software on April 19 said more about “considering” an offer for MariaDB plc (the company not the foundation). They own NuSphere which had a dispute with MySQL AB which was settled in 2002. My happy history as a MySQL employee biases me but I thought that NuSphere was not acting angelically. I think it… Continue Reading Short note re Progress and NuSphere… Read more

Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […]… Read more