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
Exadata

How to find Exadata database machine version

Find Your Exadata Machine Version Are you really curious to see which version of Exadata you are using. Just follow the step and you are ready with the information$cat /opt/oracle.SupportTools/onecommand/databasemachine.xml… Read more »

Engineered System, Exadata, Oracle    exadata, Exadata Machine Version, Oracle Exadata
OpenWRT

How to upgrade all of the installed packages in OpenWRT

OpenWRT (from open wireless router) is an open-source project for embedded operating systems based on Linux, primarily used on embedded devices to route network traffic. The main components are Linux,… Read more »

OpenWRT    Openwrt, Openwrt 19.07, Openwrt 21.02, Openwrt 23.05, Openwrt 24.10, Packages, script, Updates
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

Posts pagination

« Previous 1 2 3 4 … 10 Next »

Recent Posts

  • Flatpak Search not working on Oracle Linux/Red Hat 9.4 June 3, 2024
  • Configuring and Using Oracle Global Data Services: Optimizing Distributed Workloads October 3, 2023
  • 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
Copyright 2020
dbsysupgrade.com
Ribosome by GalussoThemes.com
Powered by WordPress
Social Media Auto Publish Powered By : XYZScripts.com