MySQL

In order to realize the redundancy of MySQL database, backup, recovery, load balancing functions, such as the two days have been learning and research MySQL dual-machine hot standby, in fact, MySQL dual-machine hot standby is the use of MySQL

Usually encountered this situation, are Slave binlog bad, on the Slave DB of the data to solve, but this encounter is Master's Binlog bad, a little bitter ~ The error message is as follows: last_io_errno:1236Last_io_error:got fatal Error 1236 from

The integer types in the MySQL data type is a bit odd. You may see int data types such as int (3), int (4), int (8). When I first contacted MySQL, I thought that int (3) occupies less storage space than int (4), and int (4) occupies less storage

State management commands are divided into LNMP State management commands and Lnmpa State management commands, Lnmpa represents Linux under Nginx, MySQL, PHP, Apache, such as the Web server architecture, is the combination of lamp and lnmp the

1. First, verify that the server is in a secure state, that is, no one can arbitrarily connect to the MySQL database. Because the MySQL database is completely out of password protection during the reset of the MySQL root password, other users can

The Oracle tutorial you are looking at is: MySQL Security Guide (3) (turn). MySQL Security Guide (3) Author: Yan Zi 2.4 Without grant set the user If you have a MySQL version earlier than 3.22.11, you cannot use the grant (or revoke) statement

Introduction of MARIADB (MySQL introduction skip) MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensed license MARIADB is fully compatible with MySQL, including

HTML and PHP, MySQL interaction Why should I use a database? World Wide Web (WWW) is more than just a place to provide information. If you have something, make a website, you can share it with people all over the world. But this is not a very easy

Required software: ActivePerl, PHP, MYSQL, Zend (first, install the IIS6.0; second, configure the PHP environment; third, install MYSQL; install Zend Optimizer; v. Configure phpMyAdmin) Win2003 configuration under Iis+php+mysql+zend2, download the

One of the most powerful features of MySQL Proxy is the end of "Read and write parting (Read/write splitting)". It works by having the primary database process a transactional query and processing a select query from a database. Database replication

Since 2012 years, Wikipedia has started migrating from MySQL to Mariadb, a major milestone in the evolution of the Wikimedia database architecture, porting the English and German versions of the Wikipedia database Wikidata to MARIADB 5.5.Over the

Stored procedures and functions define a collection of SQL statements in a database, and then call those stored procedures and functions directly to execute a defined SQL statement. Stored procedures and functions can prevent developers from writing

The previous article has adjusted the single redo statement to the optimal, but the statement is executed in one-threaded fashion. Can the multi-processor be used to allow multi-threading to be executed in parallel to further improve speed? For

In the daily MySQL operations, it is often to query the current MySQL executing SQL statements and other running MySQL-related threads, which is used in the MySQL processlist command.Mysql> show processlist; //Query the SQL statement being

ObjectiveMMM (master-master replication managerfor mysql,mysql primary master Replication Manager) is a flexible script that is based on Perl and is used to monitor and fail-over Mysql replication. And can manage the configuration of MySQL

Summary written in front,Summary:When Java through the JDBC link MySQL inserted in Chinese, to ensure that the program can execute normally, and the inserted Chinese is not garbled, MySQL server side, the data table (not the database)

Database transaction isolation level and dirty read, phantom read, non-repeated read, transaction level I. database transaction isolation level   There are four database transaction isolation levels, from low to high: Read uncommitted, Read

The cause of this problem is:The number of connections exceeds the value set by MySQL. It is related to max_connections and wait_timeout. The larger the value of wait_timeout, the longer the idle waiting time for the connection, which leads to the

I have always been interested in Mysql database/table sharding, but I am still at the stage of interest and have not encountered any applicable scenarios. Life is short. Instead of waiting for an opportunity, you can create it yourself. After a

If you use pip install MySQL-python to install MySQL, you may encounter the following problems:1. Error message: EnvironmentError: mysql_config not foundThis is because the local host is a Mac OSX system and MySQL is installed in the MAMP