Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline

Hi All, this document deals with how to fix ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. These messages indicate that the table’s definition allows rows that the table’s InnoDB row format can’t actually store. The Below configuration fixed my issue.   Restart MySQL or MariaDB restart or   © 2020, Techrunnr. All rights reserved.

Read More

how to install MariaDB 10.4 in Centos 7

Hi All, this document shows you how to install MariaDB 10.4 in Centos 7. MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License. Let’s go to the installation Part. Step 0: Update the system This will help you to keep update the system to the latest version. Once you update the system reboot the server as some packages need a reboot to updates to take effect. Step 1: Add the MariaDB 10.4…

Read More

how to check the size of the individual database in MySQL or MariaDB

Hi all, this document deals with how to check the size of the individual database in MySQL or MariaDB. Sometimes as a database administrator it’s required to check the size of the individual databases in database servers. So here is the command to check the sizes. Step 1: log in to Database server ( Mysql/MariaDB) Step 2: Execute the following command to get the individual size of all the schemas. In GB IN MB Here is the command to see the Size of the table.   © 2019, Techrunnr. All…

Read More

mariadb star replication

mariadb star replication Hello Techrunnr subscribers, this document deals with how to set up mariadb star replication. This type of topology requires when the application runs in a different region. And our motive is to update data in all the servers on a real-time basis. How does it work? So here we are choosing around 9 servers in a different location. Out of these, we have a server which is placed in the center. In the initial configuration, the central server is marked as the slave for all the servers,…

Read More