News
New Warning: P_S Metadata Lock instrumentation is disabled
With this new version of fpmmm you probably get a new warning in your fpmmm error log:
INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (1.2.0) run started. WARN: P_S Metadata Lock instrumentation is disabled. (rc=1411) INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc=0).
In this fpmmm release we start monitoring MariaDB/MySQL Metadata locking problems. For this new functionality the Metadata locking plugin in MariaDB or the Metadata …
Remote Syslog Server
Sources:
This notes are intended for Ubuntu 18.04!
Install and Configure Rsyslog Server
dpkg -l | grep rsyslogd
apt-get update && apt-get install rsyslog
systemctl start rsyslog
systemctl enable rsyslog
systemctl status rsyslog
Check rsyslog version (v7 vs. v8!):
rsyslogd -v
General configuration
#
# /etc/rsyslog.conf
#
# provides UDP syslog reception
module(load="imudp")
input(type="imudp" …FromDual Performance Monitor for MariaDB 1.2.0 has been released
FromDual has the pleasure to announce the release of the new version 1.2.0 of its popular Database Performance Monitor for MariaDB and Galera Cluster fpmmm.
The FromDual Performance Monitor for MariaDB (fpmmm) enables DBAs and System Administrators to monitor and understand what is going on inside their MariaDB database instances and on the machines where the databases reside.
More detailed information you can find in the fpmmm Installation Guide.
Download
The new FromDual Performance Monitor for MariaDB ( …
Other example
Trx # 86153878218 exists in both Galera Cluster conflics which are 46 seconds apart (= long running transaction?). Table `rt3`.`Tickets` seems to be involved in both cases. One should investigate also in this query or transaction we cannot see here...
MySQL thread id 6147, OS thread handle 0x7f5af77fe700, query id 5394536 192.168.1.42 node1 *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 67799 page no 2924419 n bits 136 index `PRIMARY` of table `rt3`.`Tickets` trx id 86153787673 …
Stupid Error Messages
Very often I see some stupid error messages as a (power-)user. I do not know if this is because of lazy developers or managers not having enough focus on more useful error messages.
If the error messages would be more clear it would help me as a power-user to fix my problems faster and fix it possibly myself instead of asking questions or even open support cases.
That would also safe costs on the support service side if end-users would be enabled to fix their problems themself. If this is what software …
FromDual Ops Center for MySQL and compatible databases 1.0.0 has been released
FromDual has the pleasure to announce the release of the new version 1.0.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MySQL and compatible databases.
The FromDual Ops Center for MySQL and compatible databases (focmm) helps DBA’s and System Administrators to better manage their MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and compatible databases operation tasks. …
See also SElinux
cd /var/log ll -d -Z mysql* mysql/* mkdir mysql chown mysql: mysql semanage fcontext -a -t mysqld_db_t "/var/log/mysql/(/.*)?" restorecon -Rv /var/log/mysql ll -d -Z mysql* mysql/*
And Non-standard database set up with SELinux
Testing Logrotate
/usr/sbin/logrotate /etc/logrotate.conf
Shutdown with MySQL 8
On StackExchange for Database Administrators I recently have seen a question which attracted my interest.
The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous…
About time - was, is and will be
How can I find out if the database “was” shutdown slowly? This is quite easy: Look into your MySQL Error Log and there you will find a log sequence similar to the following:
2020-03-30T08:03:36.928017Z 0 …FromDual Performance Monitor Release Notes
- fpmmm 2.2.1 Release Notes, Release Date: 13 February 2026
- fpmmm 2.2.0 Release Notes, Release Date: 4 September 2025 → see v2.2.1
- fpmmm 2.1.0 Release Notes, Release Date: 5 December 2023
- fpmmm 2.0.0 Release Notes, Release Date: 18 May 2022
- fpmmm 1.2.0 Release Notes, Release Date: 11 June 2020
- fpmmm 1.1.0 Release Notes, Release Date: 17 December 2019
- fpmmm 1.0.2 Release Notes, Release Date: 7 March 2019
- fpmmm 1.0.1 Release Notes, Release Date: 9 February 2017
- fpmmm 1.0.0 Release Notes, Release Date: 2 …
innodb_deadlock_detect - Rather Hands off!
Recently we had a new customer who has had from time to time massive database problems which he did not understand. When we reviewed the MySQL configuration file (my.cnf) we found, that this customer had disabled the InnoDB Deadlock detection (innodb_deadlock_detect).
Because we have advised against doing this so far, but I never stumbled upon this problem in practice, I have investigated a bit more about the MySQL variable innodb_deadlock_detect.
The MySQL documentation tells us the following
[1
]: …
MariaDB/MySQL Stored Language Examples
MariaDB/MySQL Stored Language is called SQL/PSM.
There are 4 different types of Stored Language: Stored Procedures, Stored Functions, Triggers and Events.
Stored Procedures
Stored Procedure with a Cursor:
DELIMITER //
CREATE PROCEDURE cleanup(IN pData VARCHAR(48))
BEGIN
DECLARE vId INTEGER;
DECLARE vNotFound INTEGER;
DECLARE cCleanUp CURSOR FOR
SELECT id FROM test WHERE data = pData;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET vNotFound = 1;
OPEN cCleanUp;
lGetRecord: LOOP …FromDual is 10 years old
On 1 March 2020 FromDual became 10 years old! Sincere thanks are given to all our customers, partners and interested person for their support and good cooperation in the last 10 years. And we would be pleased to advise and support you again competently in the coming 10 years.
Your FromDual Team
MariaDB Security Risk Matrix
InnoDB Page Cleaner intended loop takes too long
Recently we migrated a database system from MySQL 5.7 to MariaDB 10.3. Everything went fine so far just the following message started to pop-up in the MariaDB Error Log File with the severity Note:
InnoDB: page_cleaner: 1000ms intended loop took 4674ms. The settings might not be optimal. (flushed=102 and evicted=0, during the time.)
I remember that this message also appeared in earlier MySQL 5.7 releases but somehow disappeared in later releases. I assume MySQL has just disabled the Note?
You can find …
FromDual Ops Center for MariaDB and MySQL 0.9.3 has been released
FromDual has the pleasure to announce the release of the new version 0.9.3 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB and MySQL.
The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA’s and System Administrators to better manage their MariaDB and MySQL database farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks. More information about FromDual Ops Center …
Architecture and Design decisions
When it comes to MariaDB/MySQL Database consulting engagements we often see, that our customers are very confused by many different technologies advertised to them.
Below you will find some simple concepts and ideas we use during our consulting engagements to solve some issues and answer some questions.
General problem solving approach
- 1
. Written description of the problem to solve. This helps to learn about your problem and better understand your problem. - 2
. Searching for a suitable method, technology or …
FromDual Performance Monitor for MariaDB and MySQL 1.1.0 has been released
FromDual has the pleasure to announce the release of the new version 1.1.0 of its popular Database Performance Monitor for MariaDB, MySQL and Galera Cluster fpmmm.
The FromDual Performance Monitor for MariaDB and MySQL (fpmmm) enables DBAs and System Administrators to monitor what is going on inside their MariaDB and MySQL databases and on their machines where the databases reside.
More detailed information your can find in the fpmmm Installation Guide.
Download
The new FromDual Performance Monitor for …
fpmmm Version is old
You are using an old version of the FromDual Performance Monitor for MariaDB and MySQL (fpmmm). Please consider using a more recent version.
InnoDB Log Buffer is too small for large transactions
Your InnoDB Redo Log Buffer is too small for large transactions. Make the InnoDB Redo Log Buffer (innodb_log_buffer_size) bigger if you have enough RAM available to avoid additional I/O.
1 Mibyte is good for databases with small transactions. 8 Mibyte is good for medium size transactions. 64 MiByte is good for large transactions.
Pages
