PHP

Explanation of mysql Master-Slave configuration and its principle (Master-Slave) bitsCN. com1. add a user with the permission to access the Master database to the Slave server on the Master database server: Grant replication slave on *. * TO 'test' @

Windowsmysql bidirectional synchronization settings 1.1 Environment Construction Prepare two Windows NT hosts, install the iKEY Server windows version, and confirm that the version is correct. ensure that the mysql service starts properly and

How to modify the maximum number of connections of MYSQL: share bitsCN.com Method 1: Go to the MYSQL installation directory and open the MYSQL configuration file my. ini or my. cnf to find max_connections = 100 and change it to max_connections = 1000

The InnoDB configuration parameter bitsCN.com can improve mysql Performance. as InnoDB is a robust transactional storage engine, it has been around for more than 10 years. some important internet companies (Yahoo, Google Netease, Taobao) also

Some mysql startup parameters and optimization methods: bitsCN. comback_log indicates how many requests can be stored in the stack in a short period of time before MySQL temporarily stops answering new requests. Only if you want to have many

Difference analysis of MySQLInnoDB and MyISAM data engines bitsCN. the comMyISAM type Table emphasizes performance, and its execution speed is faster than that of InnoDB, but does not support transactions. InnoDB provides advanced database functions

MYSQL cannot be started. prompt: defastorstorageengine (InnoDB) isnotavailable solution: add skip-innodb to my. ini (linux/etc/my. cnf) in bitsCN.com. After I set it like this, there is no problem in linux. I started MYSQL in winXP on my local

MySQL features unknown: bitsCN.com this article will introduce you to these unknown features. View query results in XML format By calling the MySQL command line client program using the traditional xml option, you can view MySQL Query results in

Can 'topenfile: bitsCN.com in most cases, the database is damaged only when the index file is damaged, and the real data is rarely damaged. Most forms of database corruption can be easily repaired. As with the previous verification, there are three

MySQL server process CPU usage of 100% solution bitsCN.com friend host (Windows 2003 + IIS + PHP + MYSQL) recently MySQL service process (mysqld-nt.exe) CPU usage is 100% high. This host has about 10 databases, which are called for 10 websites

Introduction to the basic usage of MySQL stored procedures bitsCN.com organizes a lot of SQL statements when an external program accesses a database (such as PHP. Especially when the business logic is complex, a lot of SQL statements and conditions

Mysql master/slave server configuration special problem bitsCN. com1. because slave configuration information is set, mysql generates master.info in the database data directory. Therefore, if you want to modify the related slave configuration,

Linux: MySQL installation and logon methods bitsCN. comFedora5: Configure MySQL (for reference, MySQL data includes how to move the MySQL database location in the linux file system) 1. download the MySQL installation file To fully install

MySQLALTER syntax usage method bitsCN.com the following articles mainly introduce the practical use of MySQL ALTER syntax. we all know that the proportion of MySQL ALTER syntax in actual application is still very large, so you can have a good idea

MySQL database remote connection enabling method bitsCN.com Method 1: more detailedThe following articles mainly introduce the operation process of enabling remote connection for MySQL database. In fact, it is not difficult to start the actual

BitsCN.com I. definition of variablesMysql uses declare to define a local variable. the scope of use of this variable can only be in begin... used in the end block, the variable must be defined at the beginning of the composite statement, and can

Mysql command line imports SQL data bitsCN.com my personal practice is: phpmyadmin export UTF-8 insert mode abc. SQL Ftp abc. SQL to server Ssh to server Mysql-u abc-p use KKK (database name, if not, create database KKK) set names 'utf8' source abc.

Summary of common mysql commands and usage bitsCN.com 1. start and exit 1. go to MySQL: start MySQL Command Line Client (MySQL DOS interface) and enter the password for installation. The prompt is: mysql> 2. exit MySQL: quit or exit II. database

Statement bitsCN.com for obtaining the last record in MYSQL In MySQL, the auto_increment type id field is used as the primary key of the table and as the foreign key of other tables to form a "master-slave table structure". This is a common usage

The output result of the mysqlshowprocesslist command to check the mysql lock method bitsCN. comprocesslist command shows which threads are running. this command can be used to identify problematic query statements. 1. enter mysqladmin processlist