MariaDB

InnoDB/XtraDB tables can be up to 64TB (terabytes) in size. On top of this you can have multiple tables per database and multiple databases per server. Usually the size and space limits of your underlying storage and operating system are reached long before MariaDB's internal limits are reached.

DROP TABLE command is used to delete a table from a database in MariaDB. It deletes the table permanently and cannot be recovered.

Syntax:

DROP TABLE table_name ;

MariaDB ORDER BY Clause is used to sort the records in your result set in ascending or descending order.

Syntax:

SELECT expressions

FROM tables

[WHERE conditions]

ORDER BY expression [ ASC | DESC ];

MariaDB LIKE clause is used with SELECT, INSERT, UPDATE and DELETE statement to retrieve data when an operation needs an exact match.

Syntax:

SELECT field, field2,... FROM table_name, table_name2,...

WHERE field LIKE condition

USE DATABASE command is used to select and use a database in MariaDB.

Syntax:

USE database_name;

MariaDB RIGHT OUTER JOIN is used to return all rows from right-hand table specified in the ON condition and only those rows from the other table where the joined fields are satisfied the conditions.

MariaDB RIGHT OUTER JOIN is also called RIGHT JOIN.

Syntax:

SELECT columns

FROM table1

RIGHT [OUTER] JOIN table2

ON table1.column = table2.column;

MariaDB AVG() function is used to retrieve the average value of an expression.

Syntax:

SELECT AVG(aggregate_expression)

FROM tables

[WHERE conditions];

The data directory location is controlled by the datadir variable. Look at your /etc/mysql/my.cnf file to see where your installation of MariaDB is configured to store data. The default is /var/lib/mysql but it is often changed, like for example if you are using a RAID array.

JOIN is used to retrieve data from two or more tables. By default JOIN is also called INNER JOIN. It is used with SELECT statement.

There are mainly two types of joins in MariaDB:

☛ INNER JOIN

☛ OUTER JOIN

Again OUTER JOIN is divided in two types:

☛ LEFT JOIN

☛ RIGHT JOIN

DROP DATABASE command is used to drop a database in MariaDB.

Syntax:

DROP DATABASE Database_name;

MariaDB DISTINCT Clause is used to remove duplicates from the result when it is used with SELECT statement.

Syntax:

SELECT DISTINCT expressions

FROM tables

[WHERE conditions];

First, you have to create a database in MariaDB follows by selecting the database and then create a table by using CREATE TABLE statement.

Syntax:

CREATE TABLE table_name (column_name column_type);

Percona’s pt-table-checksum is the preventative tool to use

It can build checksums of all your tables, and then propagate those checksums through replication to the slave.

The 'MySQL' name is trademarked by Oracle, and they have chosen to keep that trademark to themselves. The name MySQL (just like the MyISAM storage engine) comes from Monty's first daughter "My". MariaDB continues this tradition by being named after his younger daughter, Maria.

No need for a fresh install.

Just export your data, move or delete the system database (ibdata1) and the log files (ib_logfile0 & ib_logfile1), set innodb_page_size to either 4k or 8k, and restart MariaDB. A new XtraDB instance will be created with the smaller page size. Then you can import your data and run your tests.