MySQL

MySQL master-slave replication principleMySQL master-slave replication and MySQL read-write separation of the two have a close connection, first of all to deploy master-slave replication, only the master-slave replication is completed, the basis for

Browse Catalogs Overview Features of the database Classification of databases Reasons to choose MySQL & MariaDB Introduction Download and install SQL Introduction I. Overview1. DataThe information stored in the

This section holds Storage Engine Introduction (Learn) Table additions and deletions to change One, storage engine (Learn)The first few sections we know that MySQL built in the Library = = = folder, the table in the Library = = =

August 15, 2018, today because of the previous error (because the company did not understand the business caused) so that a field should not be assigned to the assignment, the magic is actually on the production, and then a series of data errors, in

MySQL installation zabbix4.0A preparation environment1.shutting down the systemSELinux[[email protected] ~] #vi/etc/selinux/config#This file Controls the state of the SELinux on the system.# selinux= can take one of these three values:#

1. Usage and parameter descriptionpt-query-Digest [OPTIONS] [FILES] [DSN]--create-review-table # #当使用--when the review parameter outputs the analysis results to a table, it is automatically created without a table. --create-history-table #

MySQL Backup and recoveryTypes of data backups1. Physical BackupCold backup: A backup operation performed in a database shutdown state.Hot backup: A backup operation when the database is in a running state, which relies on the log files of the

August 10, 2018 08:53:50How the general production order number is1, use time + random number 1+ random number 2Disadvantage, it is possible to repeat in the concurrency, the solution is to add a unique index, when the data inserted into the query

First, web-based real-time communication, we all know that there is websocket, in order to develop quickly, this project we adopt Socket.io (client use socket.io-client)Socket.io is a websocket library that includes the client's JS and server-side

: https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip Unzip the directory after extracting the zipCreate a new My.ini file inside the contents as follows [MySQL]# Set the MySQL client default character

I. OverviewIn general, deadlock is an application design problem, by adjusting the business process, database object design, transaction size, and access to the database of SQL statements, the vast majority of deadlocks can be avoided, the following

Check out the "engine" concept first. Engine is the core component of a development program or system on an electronic platform. Using the engine, developers can quickly build, lay out the functions required by the program, or take

PrefaceUsing anemometer to visualize the MySQL slow query log, you can more easily query the slow query log, and based on the time stamp of historical query. The following is a stand-alone version of the Anemometer deployment demonstration, in

In more cases, the data we are querying comes from multiple tables, and it is necessary to have a look at the connection queries in MySQL.SQL divides connection queries into four categories: cross-joins, inner joins, outer joins, and natural

The specific exception information is as follows:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP by clause and contains nonaggregated column ' Aaa.test.age ' Which is not functionally dependent on columns in GROUP by clause; This

First, uninstall and delete MySQL 1 sudo apt-get autoremove--purge mysql-server-5.02 sudo apt-get remove mysql-server3 sudo apt-get autoremove mysql- Server4 sudo apt-get remove Mysql-common (very important)   Some of the above is redundant, it is

Business needs, the app user is written to a log table App_open_log.On the line for 7 months, there are 740,000 records.Now consider the sub-database of the table. At the beginning of each month, create a database table prefixed by App_open_log_

This is a summary about how to use Unicode with MySQL ++ on Windows OS. [problem] From http://lists.mysql.com/plusplus/5989 hi..i have a problem using Query class from mysqlpp with wchar_t. i hopesomebody can help me with this.i want to insert

The installation of unixodbc is really depressing over the past few days. Basically, every day, QT and unixodbc are compiled and installed, and sometimes some inexplicable errors may occur. First of all, I admit that I am not familiar with Linux,

Wcdj     MySQL can be accessed through many different programming languages, such as C, C ++, Java, Perl, Python, TCL and PHP. This article mainly summarizes how to access Mysql Data Using the C language interface. (1) connection routine(2) handle