mariadb 10 2 performance

Compile and install MariaDB-10.0.20 under CentOS 6.6 System Environment: CentOS6.6 (Final)MariaDB port: 3309 (because MySQL is already installed on the local machine and you do not want to delete MySQL) # Wget http://mariadb.nethub.com.hk//mariadb-10

First, Background introductionEither Binlog or Gtid, the essence of which is in the form of I/o_thread and Sql_thread synchronization, because the replication delay can not avoid the criticism, based on the MARIADB introduced Galera cluster to solve

In May last year, I first introduced MariaDB 10.0 on my blog. At that time, we received a lot of feedback. After summing up the comments, we once again explained MariaDB 10.0 in a more in-depth manner. at the beginning of the New Year, with the

MYSQLI. Database Fundamentals 1. Legacy File System Management deficiencieswriting applications is inconvenient;Data redundancy is unavoidable;application dependencies;Concurrent access to files is not supported;weak connection between data;It is

First, MySQL background informationMySQL became popular in the early days of the Internet, pursuing speed, simplicity, open source, and support for almost all operating systems. Fully support multi-user, multi-threading, support massive data storage,

MySQL Log category:General query logs: log, general_log, log_outputSlow query log: the query execution time exceeds the specified query time, that is, the slow query;Error Log: generally refers to the error log information, usually the log

The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that Oracle has the potential risk of shutting down the source of

This article will show you some basic but useful tips on how to optimize the performance of MySQLMariaDB. Note: This document assumes that you have installed MySQL or Maria This article will show you some basic but useful tips on how to optimize

MySQL is a powerful open source relational database management system (RDBMS). It was posted on 1995 (20 ago). It uses Structured Query Language (SQL), which may be the most popular choice in database content management. The latest MySQL version is 5

Recently there is a Erp+php-web test page environment deployment needs, need to deploy nginx+php cgi+socket mode, MySQL environment. To see if the service port is up, we are accustomed to using the netstat command to view it, so if you do not have