Skip to main content

Posts

Featured

Change InnoDB file format to Barracuda

MySQL and MariaDB uses innoDB for storing the tables in a file format called Antelope.  For large sites, the Antelope format doesn't support more columns which makes the backup option a tedious process.
so it will be advised to change the file format to Barracuda. There are various options to do that. Here is a small workaround to change it to barracuda.

Open Mysql from the command prompt and execute the commands one by one

$] mysql -u root -p 

The username is root here
It will ask for the password: (Input the password here).

mysql> select  version();
mysql> show variables like "%innodb_file%";

The output will be like this
+--------------------------+----------+
| Variable_name            | Value    |
+--------------------------+----------+
| innodb_file_format       | Antelope |
| innodb_file_format_check | ON       |
| innodb_file_format_max   | Antelope |
| innodb_file_per_table    | ON       |
+--------------------------+----------+
4 rows in set (0.00 sec)

mysql> SET GLOB…

Latest posts

Big Blue Button – a Virtual Classroom Software

How to enable Telnet and SSH in Mac OS

Virtual Host in Bitnami Lampstack

How to access ext2, ext3 and ext4 filesystems in windows OS

vokoscreen - a screen recorder for Linux

How to Mount NTFS and exFAT Partition in RHEL CentOS

NS-2.35 (ns2) installation in various Linux distros

How to take Screenshot in OS X (Mac)

How to open Ports in CentOS

Simple Screen Recorder for Linux