MySQL

Mysql cache function analysis: 1. The key Generation Principle of the mysql cache function is to generate a unique key based on the select statement according to certain hash rules. The select result generates a value, that is, key =>

　　PHP tutorial for helper House (www.bkjia.com)Recently, due to project requirements, you need to import an excel file to the mysql database through the php page. I searched the internet for a lot of such information and found that the excel file

DocumentWhen you create a foreign key reference constraint, the following error message about error code 105 is displayed:ERROR 1005 (HY000): Can't create table './test/role_resours.frm' (errno: 150)You can solve this problem from the following

On PyCon, some kids shoes share similar concepts, but it is not suitable for general Internet projects. It feels a little too different. However, I implemented this solution before seeing PyCon's sharing. The same requirement is different. Here, I

Typical MYSQL problems:(ERROR 1366 (HY000): Incorrect string value: '\ xD5 \ xD4' for column 'name' at row 1) There are a lot of posts on the Internet to solve Chinese Garbled text, basically speaking about modifying % MYSQL_DIR %/my. ini

In actual development, you always encounter this situation. Or in this case If you are still using select fields from table where like '/%', it is definitely a thankless practice, taking a closer look at the built-in functions of MYSQL is

Mysql supports many field types, including numeric, date/time, and string (character). storage space and storage efficiency must be taken into account during use;The following conventions are used for column type descriptions:· MThe maximum display

Max_user_connections has been mentioned in the mysql manual. It is used to restrict user resources. How can we limit user resources? A small test is conducted here.First, check the value of the global variable.Mysql> select @ max_user_connections;+ -

Method 1: Use the SQL Server proxy (Alert + Job)The procedure is as follows:1. First, use the following command to enable the trace flag.SQL codeDbcc traceon (3605, 1204, 1222,-1)Note:3605 output the result of DBCC to the error log.1204 return the

Profiling is a very useful mysql performance analysis tool. Today, we will test the profiling function. Thanks to the blog post "love Rose:The SQL Performance Analyzer of mysql is mainly used to display the usage of various resources during SQL

Generally, the master/slave Mechanism Based on LAN can meet the requirements of 'realtime' backup. If the latency is high, first confirm the following factors:1. network latency2. master Load3. slave LoadThe general practice is to use multiple slave

1. Start and exit1. Enter MySQL:Start MySQL Command Line Client (MySQL DOS Interface) and enter the password for installation. The prompt is: mysql>Or open the terminal and enter the SQL statement:Mysql-uroot-p123 2. Exit MySQL:Quit or exit Ii.

If there are less than 10 databases, You can manually enter ssh, and clean is enough. But if there are hundreds of databases, you have to write scripts. General idea: On a db jump machine, write a script to access slave, remotely obtain the binlog

The following two tables have the same structure. use SQL to find columns with different values. Student_1 NAME AGE SCORE Peter 26 100 Jack 25 96 Daniel 26 48 Bark 21 69

Xtrabackup has two main tools: xtrabackup and innobackupex.(1) xtrabackup can only back up InnoDB and XtraDB data tables, but cannot back up MyISAM data tables.(2) innobackupex-1.5.1 encapsulates xtrabackup, which is a script encapsulation, so

You have completed your brand's new application, and everything works like a charm. To use your network. Everyone is happy.Then, suddenly, an explosive user killed your MySQL server and your website was closed. What's wrong? How can you stop it?The

Tool Selection I. Sqlyog is a powerful tool, but in the face of a 5G database, it can only strike, simply put, the local import can be, from the local import server can not.II. Phpadmin comes with this, but it's okay, but it's never used in the end,

Preface: I recently started to use the Ubuntu system. There is really no good mysql interface program, so I can only operate it on a terminal.Procedure: open terminal, enter the following content, and press Enter.That's all!Purpose: copy the

There are three solutions to this problem:1. Increase the value of the wait_timeout attribute of MySQL.Modify the/etc/mysql/my. cnf file and set it in [mysqld:# Set a connection to wait 8 hours in idle status.Wait_timeout = 86400Related Parameters,

When the mysql client connects to the mysql server (the process is mysqld), mysqld creates a new thread to process the request. This thread first checks whether the host name is in the host name cache. If not, the thread tries to resolve the host