MySQL

MySQL database backup and restore of common command summary, learn MySQL friends can refer to the next.Commands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database for a

The company has a project that requires frequent insertion of data into the MySQL database, and the design goal requires the ability to support an average of more than 1000 data per second. At present, the function has been realized, but a stress

This error means that you cannot select some of the values in the same table, then update the table (in the same statement), the solution does not directly query the same, assuming that the table to be updated to a, the data of a is first put to

In MySQL configuration file my.cnf, there is a one-line skip-external-locking parameter, which is "Skip external lock". According to the official explanation of the MySQL development website, external-locking is used for locking MyISAM data tables

The 1.centos5.8 x86_64 is minimized, and the system has undergone a basic optimization2.nginx version: nginx-1.4.73. Source Package storage Location:/home/oldboy/tools4. Source Package Compilation Installation Location:/application/5. A

Due to background reasons, the master-slave synchronization is to be based on the MySQL 5.1 version, master-slave synchronization is mainly a database read and write access to the original database heat is too large, need to be used from the library

Today, try to write a small demo implementation of the code that was seen before, the purpose of understanding the different files of data access, how to get the foreground data, how to put the database data on the front page display.The AWT

Background: The previously implemented MySQL synchronous replication feature (see author before article http://blog.csdn.net/kingofworld/article/details/39210937) is just a dual-machine hot standby feature, It is not possible to automatically

Scenario: The company recently in the database from Oracle to MySQL, because the table name is not case-sensitive in Oracle, so there is no table in MySQL problem, the Internet query, found in Linux MySQL table name is case-sensitive, However, there

In MySQL database, you often encounter the content of the day of statistics.For example, in the user table, the Date field is: Log_timeStatistics DayThe SQL statement is:SELECT * from user where date (log_time) = Curdate ();Curdate () indicates the

If Table A's primary key is a field in table B, the field is called the Foreign key of Table B, table A is called the primary table, and table B is called from the table. Foreign keys are used to achieve referential integrity, and different foreign

1. Download MySQL Community Server 5.6.132. Unzip the MySQL archive packageUnzip the downloaded MySQL package into a custom directory, and my unzip directory is:"D:\Program Files\mysql\mysql-5.6.13-win32"Will unzip the directory under the default

Tag:io   os    use    ar   for    data    sp   div   on    User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user  zx_ Root   identified by ' xxxxx ';  //identified by will use plaintext

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

Scale out: Scaling out, adding processing nodes to improve overall processing powerScale up: vertically scaled to improve the overall processing power by increasing the processing power of a single nodeReplicationMySQL's replication is asynchronous

First enter the terminal1. Enter the following command to display the MySQL process numberPs-a |grep-i MySQL2. Enter the following command to kill the process shown aboveKill-9 Process number 1 process number 23. Enter the following command to enter

MySQL database is one of the most common and common database of DBAs, MySQL is widely used, but also more people to join the ranks of learning it. Here are some of the most common and frequently used experiences and tips from the MySQL database that

General traffic is larger than the Web site, and the request log table is created independently of one table per day. The business needs to add a new column for each table, and for half a day, write a stored procedure like this:Log table structure

How to optimize SQL statements for slow queries-SQL Optimization In actual log analysis, there are usually a large number of slow logs, and there will be a large number of records for the same query, here we need to find the most problematic and

The mysql pid file cannot be started after it is deleted. How can this problem be solved? Tip: "Starting MySQL ...... ERROR! Manager of pid-file quit without updating file "solution. After you delete the mysql binary log file and restart mysql,