MySQL

MySQL--MariaDB--Percona-serverMysql:oracle,Commutity: Community Edition 5.5 5.6 5.7 8.0MariaDB:5.5 10.xPercona:Percona-serverInnoDB-XtraDBXtrabackupPercona-tools:Storage Engine:Engine: Also known as table type, table-level concept, it is not

I've been tossing lamp lately. "You should upgrade to MySQL 5.5.0 or later" when deploying the phpMyAdmin from the official download.The reason is that I installed the MySQL database version too low. Solution Ideas: 1, upgrade the MySQL

1, add Percona warehouse.# yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm2, install the plug-in.# yum -y install percona-zabbix-templates# rpm -ql percona-zabbix-templates/var/lib/zabbix/

Database overviewWhat is DataSymbolic records describing things are called dataWhat is a databaseThe database is the warehouse where the data is stored, except that the warehouse is on a computer storage device, and the data is stored in a certain

Understanding of MySQL optimistic lock, pessimistic lock, shared lock, exclusive lock, row lock, table lock conceptWhen we operate the database, there may be inconsistencies in data due to concurrency problems (data Conflicts)Optimistic

GRPC----http://www.cnblogs.com/ghj1976/p/4587736.html79452948Zipkin with MySQL in Docker-composeHttps://my.oschina.net/u/3020542/blog/1613016[docker Compose Build a Zipkin environment based on MySQL storage]https://github.com/openzipkin?page=2https:/

1, low-level automatic discovery overviewZabbix's low-level Autodiscover (LLD) is suitable for monitoring multiple instances, monitoring changes in data (partitions, network cards).Automatic Discovery (LLD) provides a way to automatically create

We all know that when a large volume of data is inserted into MySQL,MySQL uses load data local infile to import data from a file faster than the insert Statement, which is about 20 times faster.However, this method has a disadvantage: before

Actually: First, use Windows as the environment: Logs in Windows Overview of log file types:1.The error log records the problems that occur when you start, run, or stop mysqld.My. ini configuration information:# Enter a name for the error log file.

Note: This article is from the blog "afei". If you want to repost this article, please contact the author! And indicate the source: http://blog.csdn.net/faye0412/article/details/7038290 Cause:Today, I did one thing: On the VM, I copied a database

First, start and stop the MySQL Service Net stop MySQL Net start MySQL Second, log on to MySQL Syntax: mysql-u user name-P User Password Enter the mysql-uroot-p command, press enter and prompt you to enter the password, enter 12345, and then press

I. Preface Ii. Compilation and Installation Iii. Install MySQL and memcache 4. install Apache, PHP, eaccelerator, and PHP-memcache 5. Install squid Vi. Postscript  I. Preface I. Preface and preparationsCurrently, the lamp development mode

PM Codesmith4.1.3 failed to Load file or assembly "MySQL. data, version = 5.1.4.0, culture = neutral ,........ or one of its dependencies. The Assembly list definition found does not match the Assembly reference. "Solution:Download the

I started to write this post before weeks ago and finally publish it even if it's not totally finish. it is just a little feedback about tuning a full lamp server with some user traffic and services load. important thing to notice is that all stuff

How does Mysql LIMIT optimize (reprinted) a large amount of data? mysqllimit The following is a brief introduction to Mysql LIMIT. We all know that the LIMIT clause is generally used to LIMIT the actual number of rows returned by the SELECT

Mysql query method analysis summary: In other words, the article table article stores the time when an article is added as the add_time field, which is of the int (5) type, to query the total number of articles added today in descending order of

Abstract: This article describes how to optimize SQL queries. You can manually use the EXPLAIN statement to check the efficiency of SQL queries. In addition, some principles for optimizing SQL statements are described, mainly about how to optimize

MySQL management tool --- Percona Toolkit is a group of advanced command line tools used to manage MySQL and system tasks, including: 1. Verify the consistency between the master node and the replicated data. 2. Effectively archive record rows. 3.

Mysql variables are divided into local variables @ and global variables @. They are all in different sizes, but the usage of the two variables is slightly different. Next I will introduce the production usage. Commonalities: case-insensitive, all

Next, I will provide a summary of mysql Data Types, that is, field types, including type descriptions and string lengths of different data types. I will introduce them below. I. numeric type Storage required for column typesTINYINT 1 byteSMALLINT 2