Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Getting Started with MariaDB
  • Table Of Contents Toc
Getting Started with MariaDB

Getting Started with MariaDB

By : Daniel Bartholomew
4.4 (8)
close
close
Getting Started with MariaDB

Getting Started with MariaDB

4.4 (8)
By: Daniel Bartholomew

Overview of this book

MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available. From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.
Table of Contents (11 chapters)
close
close
9
A. MariaDB Next Steps
10
Index

MariaDB log files


Depending on how we configure it, MariaDB will keep very detailed or very sparse logs. The location of these logs is configured in our my.cnf (my.ini on Windows) MariaDB configuration file. On Linux, the default location is /var/log/mysql/ and on Windows, the default location is in the MariaDB data directory.

There are several different kinds of logs, each kind serving a different purpose.

The binary log

The MariaDB binary log is a series of files that contain events. An event is a description of any modification to the contents of our database. As indicated by the name, and unlike most other kinds of log files, MariaDB binary log files are in a binary format. They are not readable by us unless we use a helper program such as mysqlbinlog.

The binary log is controlled by the log_bin variable. The main purpose of the variable is to turn binary logging on and off. Basically, if the variable is present in the [mysqld] or [server] sections of our configuration file, binary logging...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Getting Started with MariaDB
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon