MySQL

recently started to play PHP, so try to build a development environment and make a record, in case you can use it later to be easily checked. The first step is to ensure that the package is up to datesudo Apt-get updateStep two install Apache2sudo

Lab Environment:vm1:192.168.1.132, for Apache serversvm2:192.168.1.134, for PHP servervm3:192.168.1.137, User mariadb serverSoftware version: httpd-2.4.9,php-5.4.26,mariadb-5.5.39First, compile and install httpd-2.4.91. Solve the dependency

A unibilling machine suddenly had a heavy load in the first few days. The CPU is found to be heavily occupied in top. The AGI program runs very slowly, and a zombie process occurs. In fact, there were only about 50 concurrent calls. Far from the

Recent projects have used the ability to query data records in the current month, the initial idea is to construct a time period in the logical business query, when writing SQL statements feel very troublesome. So I went to search the Internet to

With the help of explain, you know when to add an index to the table to use the index to find records and make the select run faster.If some problems arise due to improper use of the index, you can run analyze table to update the table's statistics,

The MySQL transaction isolation level is the "phantom read" phenomenon under "Repeatable-read" Statements about transaction control in the MySQL command line see this article:http://my.oschina.net/xinxingegeya/blog/296459 This film reference

Problem: A large number of warning occur when executing the following statement 1292mysql> UPDATE show_info INNER JOIN show_like on show_like.show_id = show_info.show_id SET show_info.status = 0 WHERE sh ow_like.show_id = 1 and show_like.cid = '

Preparatory work:Master-Slave operation----Close SELinux and iptables or open 3306 ports (iptables-a input-p TCP--dport 3306-j ACCEPT iptables-a output-p TCP--spo RT 3306-j ACCEPT), time synchronization ntpdate time.windows.comMysql_1 Information:

How high can MySql performance be? Using PHP for more than half a year, really so deep to think about this problem or from the day before yesterday. There has been pain and despair, to now full of confidence! MYSQL This database is definitely

Original: My MySQL learning experience (12)My MySQL Learning experience (12)My MySQL learning experience (a)My MySQL learning Experience (ii)My MySQL learning Experience (iii)My MySQL learning experience (iv)My MySQL learning experience (v)My MySQL

MySQL Insert data failed method to prevent self-growing primary key growthMySQL set the self-growth of the primary key ID, insert the failure of the self-growth ID also added one, such as Failure 5, the next success is not in the original last

June results List Rank Partner performance sign interview daily goals 1 Du Yan Flower 12367 2 0 View Target 2 Zhengdongjie 2345

I was just trying to build a simple lamp environment, but I found that there were so many problems. (by default7#zbphp.com)A lot of places to install the MySQL hint is via yum one click Install. The shell command is as follows:Yum Install Mysqlyum

The film service environment of Red Hat Enterprise Edition 6.5, 6.3 of the test may be slightly different, but the method is roughly the same.The postfix version of the current system is postfix-2.6.6-2.2.el6_1.x86_64We want to use the latest to go

MySQL deadlock analysis, mysql deadlock1. Test Description Environment Description: RHEL 6.4 x86_64 + MySQL 5.5.37. The transaction isolation level is RC. Test Table: mysql> show create table t1\G*************************** 1. row ******************

Stored Procedure 6-trigger and Stored Procedure 6 I. triggers A trigger is a table-related named database object. This object is called when a specific event occurs on the table. It is a special stored procedure related to table events. Its

MySQL shutdown process details and methods for safely disabling MySQL. mysql shutdown process details This article analyzes the mysqld process and how to safely and easily shut down MySQL instances. If you are not clear about this process, refer to

How to run the script in mysql, mysql run the script Suppose you want to run the Script: F: \ hello world \ niuzi. SQL Method 1:In the command line (Database not connected), enter mysql-h localhost-u root-p Method 2:In the command line (the

16. Simple SQL Optimization for mysql partitions 1. SQL Optimization for mysql partitions 1. use show session status like '% Com _ %'; to view the execution frequency of each currently connected SQL statement: show global status like '% Com _ % ';

11. mysql input security: mysql 1. Try to use the "bind parameter" function. pdo can be used in php to perform a series of operations. 2. php can use the mysql_real_escape_string () function to filter input;   How to configure the security of the