PHP

MySQL remote access command format: mysql-h host address-u user name-p user password first modify mysql mycnf file on the target server (1151596651): After modification and exit, restart mysql Service Command: sudoservicemysqlre MySQL remote access

This article is a supplement to the previous article. it focuses on the following two aspects: one-connection-per-thread implementation and epoll usage in the thread pool. One-connection-per-thread according to the scheduler_functions template, we

Under what backup conditions, the data file is deleted and some restrictions are restored. 1. the data block to be restored should not be used. 2. the file system itself is not damaged. use the tool ext3grep, http: codegooglecompext3grep: when

Mysql table creation and column attributes: 1. table creation principles 2. detailed description of column attributes 1. table creation principles: in fact, it is the process of declaring columns, data is stored in the hard disk (memory) column in

Mysql from version 55, no longer use configure compilation, but use the cmake compiler, the specific cmake compilation parameters can refer to the mysql official site documentation (※very important) http: devmysqlcomdocrefman56ensource-configuration-

This article describes how to use mysqladmin to check the running status of MySQL, including the simple awk usage of mysqladmin. For more information, see mysqladmin as an important MySQL client, the most common is to use it to shut down the

This article describes how to find the deadlock ID in the MySQL thread. the method described in this article is mainly to find the deadlock from the data dictionary. if you need a friend, you can refer to it, how can this problem be solved? Find the

This article describes how to install phpMyAdmin on CentOS. phpMyAdmin is a tool that uses PHP scripts to operate MySQL. it is very popular. For more information, see. Prerequisites To install phpMyAdmin on CentOS, set up a Web server (such as

This article describes how to use the Memcached plug-in of InnoDB in MySQL. with the replication function of MySQL, we can say that if you need to implement Memcached replication in disguise, you can refer Install To make the article more complete,

At that time, we were preparing to build a project, so I built the lamp server and directly yuminstall all the files, because centos is a relatively stable system, therefore, none of the above Software is the latest. apache is version 2215, php is

This article mainly introduces how to use innodb_force_recovery to solve the problem that MySQL crashes and cannot be restarted. this is a successful case and is not a panacea. you need to consider it as appropriate. if you need it, refer to the

Today, in centos6, copy the database folder that mysql cannot start to usrlocalmysqlvar. the tableisreadonly error is prompted when you modify the table. First of all, I encountered a Permission problem, so I went to usrlocalmysqlvar to check it.

This article mainly introduces four methods for viewing the mysql version in Linux, this article describes four methods, including using mysql-V in the terminal, using mysqlstatus, searching in help, and using mysql functions. For more information,

This article describes how to use the MIN () function in MySQL, you can refer to the MySQL MIN function to find the minimum value of a record set. The EMPLOYEE_TBL table for MIN functions has the following records: mysql> SELECT * FROM

This article mainly introduces the MySQL latency association performance optimization method. This article describes the background of latency Association, latency association analysis, and solution of latency Association. For more information,

This article mainly describes the null value in the database language and explains the MySQL instances. if you need it, you can refer to those who are familiar with SQL and have no doubt about Null, however, it is still difficult to find a

This article mainly introduces a specific case analysis of optimizing MySQL Query operations. it mainly adjusts the use of join fields. For more information, see Problem Description A user reports that the execution time of an SQL statement is too

This article mainly introduces the issues that should be paid attention to when using wildcards in MySQL, mainly the errors that are easily caused by the use of underlines. For more information, see Symptom: There is a table action_conf with

This article mainly introduces the permissions in MySQL, including the transactions that can be operated by each permission and some common command statements for the operation permission. For more information, see I. Preface In many articles, we

This article describes how to build a MySQLMMM architecture from scratch. This article describes how to configure MySQLRelication, users required to create a synchronization database, synchronize master-slave databases, install MMM, configure MMM,