August 25 night Baidu again action, who was implicated
Last night, 21 o ' clock 50 or so, Baidu has a big sweep, this sweep of Shandong SEO feeling is the most fierce in the previous sweep of this year, straight scare me out of a cold sweat. Why is this sweep the most violent because, as for my little station, experienced an unprecedented shock, because, in the past raids, this station has been included and the reverse chain fluctuations are relative
composite index, you must put the high-sensitivity field in frontInterpretation: The ability to filter data more effectivelyVi.. SQL Usage Specification(19) Prohibit the use of select *, only get the necessary fields, need to display the Description column propertiesInterpretation:A) reading unwanted columns increases CPU, IO, net consumptionb) cannot effectively use the overlay indexc) Use SELECT * to easily add or remove fields after a program bug occurs(20) Disable INSERT INTO t_xxx VALUES (
Label:Troubleshoot database no connection issues PrefaceDatabase version type: Mysql5.5The database connection failed when the application connected to the database. Open database view, shown below.The reason for this is that the MySQL service is having problems, restarting the MySQL service, and the database is successfully connected.Reference documents1.http://jingyan.baidu.com/album/0a52e3f4158211bf62ed72e6.html?picindex=1American and American PicturesMySQL Advanced (
queue future19. Better idle connection processing. Instead of shutting down the connection directly, it can still connect the pool size and the smart algorithm of the free pool.20. You can decide when the connection is considered abandoned, when the pool is full, or directly in time-out by specifying a pool of usage thresholds.21. Discard the connection timer to post a statement of the Reset/query activity. Allows a connection to be used for a long period of time without timeouts. This is done
sec) mysql> Set long_query_time = 0.05;
Query OK, 0 rows Affected (0.00 sec) mysql> Show variables like ' long% '; +-----------------+----------+
| variable_name |
Value | +-----------------+----------+
| Long_query_time |
0.050000 | +-----------------+----------+ 1 row in Set (0.00 sec) mysql> Select COUNT (*) from payment p left joins customer C on
p.payment_id = c.customer_id ORDER by c.customer_id; +----------+
|
COUNT (*) | +----------+
|
16049 |
+----------+ 1 row in Set (0.07 sec) my
complexity has always been focused on the inception of the Dream space.18. Asynchronous retrieval--You can connect your connection request and receive queue future19. Better spare connection processing. Instead of shutting down the connection directly, it is still able to connect the pool size and the smart algorithm of the spare pool.20. You can decide when the connection is felt to be abandoned, when the pool is full, or directly in time-out by specifying a pool of usage thresholds.21. Discar
issueWhen do I "don't" create an index(1) The table often insert/update/delete operation(2) The table is very small (record very little)(3) Column names are not often used as join conditions or appear in the WHERE clauseDitto noteCreate index EMP_EMPNO_IDX for the Empno single field of the EMP table, called single-column index, create index name on table name (field,...)Create INDEX EMP_EMPNO_IDX on
EMP (EMPNO);650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M02/87/1A/wKioL1fUSyeC_YztAAA
table, and the other is called the child table (foreign key). In other words, the value of the foreign key depends on the value of the primary key. Inserting a foreign key value must have data corresponding to it in the primary key. Format: FOREIGN key (foreign key field) references primary key field table name (primary key field). Master Table Update On update[Cascade Operation] | Master Table Update On delete[Cascade Operation] | Primary table Delete Cascading Operations: 1.cascade | Synchro
25, Shell special symbol Cut command, sort_wc_uniq command, tee_tr_split command, Shell special symbol underFirst, shell special symbol Cut commandSpecial symbols*: Wildcard.?: any one character.#: Comment characters, add to command before command will not take effect.\: de-semantic characters. The following special symbols (such as *) are reverted to normal characters. Example:# ls-d 123\*LS: Unable to access 123*: No file or directoryCut command: In
that a machine can directly connect to the B machine's 22 port.Take my own environment for example, a machine for windos host, IP for 192.168.226.1b Machine for VMware inside LINUX1, there are two network cards, ENS33 IP for 192.168.226.129ENS37 to 192.168.100.1C Machine for virtual machine linux2, IP for 192.168.100.100Now how to configure can let the host SSH connection linux2?1. Route forwarding is still turned onecho "1" >/proc/sys/net/ipv4/ip_forward2 Configuring routing RulesA on the exec
Label:JDBC 1. JDBC (Java Data Base Connectivity,java database connection) is a Java API for executing SQL statements that provides unified access to a variety of relational databases, consisting of a set of classes and interfaces written in the Java language. JDBC provides a benchmark to build more advanced tools and interfaces that enable database developers to write database applications, while JDBC is a trademark name. 2. with JDBC, it's easy to send SQL statements to various relational data.
4.4 5 20A row that searches for one or more contiguous no.# egrep ' (NO) + ' testfile# grep-e ' (no) + ' testfile# grep ' \ (no\) \+ ' testfile #3个命令返回相同结果, Northwest NW Charles Main 3.0 98 3 34northeast NE AM Main Jr. 5.1 . 94 3 13north NO Margot Weber 4.5 . 5 9 do not use regular expressionsThe Fgrep query is faster than the grep command, but not flexible enough: it can
access log is the history of access/request.The directory of logs is/usr/local/apache/logsThe following can be seen in the access logBut this kind of log format is too simple, can not be customized, if you want to customize the words need to/usr/local/apache2/conf/httpd.conf to defineVim found Logformat after entering the configuration fileThe system uses common by default, so the log field you see above is in this format.Specifically pointed out that Referer is the source page user-agent is a
Configure JDK 1.8.0 _ 25 in Ubuntu 14.04 and switch the version.
Configure jdk 1.8.0 _ 25 in Ubuntu 14.04. You can switch the version to jdk.
Decompress:
Sudo mkdir/usr/lib/jvm
Sudo tar zxvf/home/user name/Downloads/jdk-8u25-linux-i586.tar.gz-C/usr/lib/jvm
Modify the environment variable: // The environment variable is not configured after the test. After the configuration, the following command cannot be u
Php-Smarty-cache 1 (25), phpsmarty-cache 25. Php-Smarty-cache 1 (25), phpsmarty-cache 25 I. cache principle: IE: save resource files to the local Smarty: save the cache to the server and compile the cache. static 2. Why php-Smarty-cache 1 (25) and phpsmarty-cache
The old left received an email from a previous VPS merchant today and mentioned that the SPAM message sent by VPS was suspended. This small VPS was also activated during the test. I forgot to use it later. It is estimated that the password was too simple or other factors were used to send emails. Many people may have encountered this problem.First of all, if you encounter such a problem, reinstall the system, set a complicated password, modify the port, set the key to log on, and so on. Then, ch
Comments: Disable port 21 \ 23 \ 25 in Windows. Sometimes, to ensure security, we need to disable port 21 for FTP (File Transfer Protocol) services.Port Description: port 21 is mainly used for the FTP (File Transfer Protocol) service. The FTP service is mainly used to upload and download files between two computers, one computer acts as the FTP client, and the other computer acts as the FTP server. you can log on to the FTP server using anonymous logo
The first wayora 25 to eat Wayland crabsGuideWayland is a new technology. This next-generation Display Server is designed to replace the old X. Org server (X11 ). X11 is used as the default display server by almost all GNU/Linux operating systems. However, X11 has many security risks and cannot be fixed for various reasons. Therefore, for many years there has been a call to design new display servers to replace X11 servers that have been used for deca
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.