Database Administrator

MySQL stores logs and uses Loganalyzer for front-end display Why use logs?In the production environment, we may need a complete log system to view the status and operations of the running host service, we can use ELK in a larger network architecture

MySQL buffer query and non-buffer Query Recently I encountered the following error when developing a PHP program: PHP Fatal error: Allowed memory size of 268 435 456 bytes exhausted The error message shows that the maximum allowed memory is

MySQL source code compilation and installation (5.5 and 5.6 coexist) Introduction: How to run two or more MySQL services simultaneously on one server. 1. MySQL 5.6 Shell> useradd-r-s/sbin/nologin mysql Shell> wget ftp://mirror.switch.ch/mirror/mysql/

Use shell to generate scripts for integrated data migration in batches For integrated data migration, it is basically the two-in-one, four-in-one, and eight-in-One rhythm of the Overlord, which integrates data from databases that are as relevant to

Install and configure MySQL in UbuntuInstall MySQL in Ubuntu Command: sudo apt-get install mysql-serverMySQL initial configuration and management Start MySQLMysql start: mysqld is the mysql daemon Check whether mysql is started:ps -ef | grep

Calculate the value of ken_len In the MySQL query plan This article first introduces the meaning of ken_len In the MySQL query plan, then introduces the calculation method of key_len, and finally uses a forged example, to show how to use key_len to

MyBatis Study Notes Speaking of mybatis, let's first talk about ibatis. mybatis3.X is a later version of ibatis2.X, which has many more powerful functions than ibatis. 1. Comparison between mybatis and ibatis 1.1 In terms of relationship ing,

Oracle listener service enabled Run the netca command to enable the Oracle listening service. Dialog Box Select listener service configuration, and click Next Select Add listener and click Next The name of the listener. Default Value.

CentOS7 compilation and installation MySQL 5.6.28 and compilation Parameters The source code package version after MySQL 5.5 is compiled and installed using the CMake tool. Therefore, you must install the latest version of MySQL in advance. CMake is

MySQL interactive connection & non-interactive connection Interactive operations: in layman's terms, you open the mysql client on your local machine, that is, the black window, and perform various SQL operations in the black window, of course, it

Use Redis to store the follow relationship Redis provides a wide range of data types. Compared with relational databases or simple Key-Value storage (such as Memcached), Redis data models are more similar to actual data models. For example, in the

How to Use Jedis to operate Redis message queuesResources Jedis jar packageCommons-io jar packageUsage The sample code is as follows. before using it, open the redis server program.Sample Code Package RedisExample; import redis. clients. jedis.

Install MySQL on Ubuntu source code for problem solving and Security Optimization 0. DescriptionOf course, MySQL is installed in a variety of ways. on Ubuntu, you can install it using apt-get. The advantage is that it is fast and convenient.

How to Set Up MySQL synchronization (replication) MySQL provides the Database Synchronization function, which is of great help to achieve database redundancy, backup, recovery, and load balancing. This document describes common synchronization

Oracle bidirectional Stream configuration practices Abstract: This article describes how to use the Oracle Stream replication function for Bidirectional Stream replication. It is mainly used for real-time database synchronization and backup. Oracle

MySQL Q & A · mysqldump tipsBackground When using mysqldump to export data to the cloud, you may encounter two "weird" problems.TIP 1 -- port is invalid? For instances with ports 3306 and 3307, run the following command: mysqldump --host=localhost --

PostgreSQL avg () function The AVG function of PostgreSQL is used to find the average value of a field in various records. To understand the AVG function, the table COMPANY has the following records:Testdb # select * from COMPANY;Id | name | age |

Remove time zone and precision from PostgreSQL query results I have been using PostgreSQL functions to piece together. Today I suddenly found that it can be so simple, just use timestamp (0) to solve it: Ls => select createtime: timestamp (0)

MySQL displays data too long for column 'name' at row 1 1. symptom: we set the character set encoding of the database to UTF-8. When we insert Chinese characters to a column in the table through the DOS interface, we will encounter a similar

Use Linux commands to filter out the complete SQL statements in binlog DB: MySQL 5.6.16CentOS: CentOS release 6.3 (Final) How to extract the complete insert statement when an insert statement is input across rows using spaces! Create an empty