Blog for Database and System Administrators

This blog is a collection of articles on analyzing and troubleshooting for all system and database administrators. These guides come from my experience, I hope they can help everyone.

MENU
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Skip to content
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Linux Logo

Nextcloud 21 stop working after upgrade mariadb 10.6.X

If you have upgraded MariaDB 10.5 to 10.6, you will see that Nextcloud 21 will stop working and you’ll see this message : In the log, if enabled, you can… Read more »

Linux, MariaDB    innodb_read_only_compressed, KEY_BLOCK_SIZE, MariaDB, MariaDB 10.5, Mariadb 10.6, Nextcloud 21, Nextcloud upgrade, ROW_FORMAT
Linux Logo

Comparison Between Btrfs and XFS Filesystems

There are many filesystems available for use with Linux. The most common Linux filesystems include Ext4, Btrfs, XFS, and ZFS. Every filesystem has its unique use cases, pros, and cons…. Read more »

Linux    btrfs, ext4, Tuning, xfs
Uplexa Icon

How to configure and add nodes on Uplexa Wallet Android

The uPlexa team brings to you, our uPlexa Android wallet. The wallet includes Node-O-Matic technology, allowing to scan for remote nodes. Store, send, or receive uPlexa (UPX) with ease. The… Read more »

Cryptocurrency, Uplexa    Android, APP, Cryptocurrency, Nodes, Uplexa, Wallet
MariaDB logo

Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND

Last_SQL_Error: Could not execute _rows event on table .; Can’t find record in ‘’, Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event’s master log , end_log_pos. This is one of the… Read more »

MariaDB, Mysql    Error_code: 1032, GTID, HA_ERR_KEY_NOT_FOUND, MariaDB, mysql, Replica
Linux Logo

What are transparent hugepages?

“Transparent Hugepages” is a Linux kernel feature intended to improve performance by making more efficient use of your processor’s memory-mapping hardware. It is enabled (“enabled=always”) by default in most Linux… Read more »

Linux    Centos, Debian, Hugepages, Kernel, Linux, Performance Linux, Red Hat, Transparent Huge Pages, Ubuntu
Linux Logo

Debian 10: How to disable transparent hugepages

“Transparent Hugepages” is a Linux kernel feature intended to improve performance by making more efficient use of your processor’s memory-mapping hardware. It is enabled (“enabled=always”) by default in most Linux… Read more »

Linux    Debian, Hugepages, Memory Leak, performance, Transparent Huge Pages, Ubuntu
MariaDB logo

ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

I needed to change the hostname on mysql database logins because the application server name was changed. I ran the following command: Starting with the MariaDB-10.4+ the mysql.user is a… Read more »

MariaDB, Mysql    change user, ERROR 1356, mysql.user, rename user, scripts mariadb, scripts mysql
Linux Logo

How to enable https on wildfly and tls 1.2

In this post we will describe step by step how to enable the https protocol on wildfly and enable the desired security protocols. To activate SSL communication in Wildfly, perform… Read more »

Linux    Application Server, https, security, TLS1.0, TLS1.1, TLS1.2, Wildfly
MongoDB Logo

MongoDB 4.4 New Features

This version has been released to augment the database’s ability to operate at a convenient and dependable scale, therefore developed under the “user-driven engineering” principle to enable it deliver numerous… Read more »

MongoDB    mongodb, MongoDB 4.4, New Fea, Replica set, security, Sharding
Clickhouse Logo

ClickHouse compression test

ClickHouse supports different kinds of compressions, namely two LZ4 and ZSTD. But in short, LZ4 is fast but provides smaller compression ratio comparing to ZSTD. While ZSTD is slower than… Read more »

ClickHouse    Big Data, Clickhouse, Compression, Compression lz4, compression zstd, performance, Tuning

Posts navigation

« Previous 1 2 3 4 … 10 Next »

Recent Posts

  • OCFS2 File system and Snapshot with REFLINK February 25, 2023
  • Oracle UEK7 Oracleasm kernel module has been removed May 30, 2022
  • How do fsck at corrupted vm guest in Oracle OVM or Xen Server from vm images. May 2, 2022
  • Oracle Dataguard queries check April 12, 2022
  • Unable to open ‘/boot/vmlinuz-*-dpkg-new’: Operation not permitted March 10, 2022
  • Pre-built Oracle Database 12.2/19c/21c Virtualbox Image January 23, 2022
  • Upgrading Oracle Linux 7 to 8 using Leapp January 21, 2022
  • Oracle Database tracing LDAP from CMU to AD November 15, 2021
  • How to find Exadata database machine version September 14, 2021
  • How to upgrade all of the installed packages in OpenWRT August 12, 2021
Copyright 2020
dbsysupgrade.com
Ribosome by GalussoThemes.com
Powered by WordPress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT
Social Media Auto Publish Powered By : XYZScripts.com