mysql process

1. Mysql databases do not have an incremental backup mechanism. when the data volume is too large, backup is a big problem. Fortunately, the mysql database provides a master-slave backup mechanism, which is to write all the data of the master

MySQL row-level lock, table-level lock, page-level lock details page-level: engine BDB. Table-level: engine MyISAM, which is interpreted as locking the entire table and reading at the same time. Row-level: engine INNODB, locking a single row of

MySQL prompt: the solution to the TheserverquitwithoutupdatingPIDfile problem was found by using the df command. the disk was full, because the partition was used by the system default at that time, and I don't know why I couldn't automatically

Mmm-master drift analysis I. problem description Online store applications occasionally experience slowness. Check and find that the writer role is drifting before master-backup. Check mysql-log for no exceptions and no front-end nginx/php or

Mysql dual-host exception and solution bitsCN.com Mysql dual-host exceptions and solutions Today, Mysql has two problems: Run the following command to view the exception information: SQL code Mysql> show slave status/G; For details, see the

Build mysql server load balancer and high-availability environment bitsCN.com Build a mysql server load balancer and high-availability environment Abstract: rhel5.8, mysql, keepalived, and haproxy are used to build a cluster with high availability

Port MySql to the embedded Linux platform bitsCN.com Recently in the attendance machine system, hardware used cortex-A8, haha, in fact, is a bit wasteful, 2410 can be. Therefore, we need to consider the storage of attendance data, which was

Recently, I have been developing ecms3000. I have encountered many problems when I want to use databases and install mysql databases on the development server. now I will summarize the issues and take notes for myself. One installation process 1.

Install MySQL-server-5.6.13-1.el6.x86_64.rpm under RedHat6.3 Install MySQL-server-5.6.13-1.el6.x86_64.rpm under RedHat 6.3 Install MySQL-server-5.6.13-1.el6.x86_64.rpm under RedHat 6.3 First, download the following three files: MySQL-client-5.6.

For more information about how to solve the MySQLserverhasgoneaway problem, see. MySQL server has gone away problem solution. For more information, see. Applications (such as PHP) execute MYSQL statements in batches for a long time. Execute an SQL

In a FreeBSD system, a standard FreeBSD system requires at least one network interface to communicate with other computers. It supports Token Ring and FDDI, as well as general dialing connections, ISDN, ATM and other WAN connections. This article

The MySQLroot password is correct, but you cannot log on to MySQL from the local machine. The prompt is 1ERROR1045 (28000): Accessdeniedforuserroot @ localhost (usingpassword: YES) the user table in the mysql database is missing a data item whose

Recently, a VPS customer complained that MySQL had crashed for no reason, and another customer complained that VPS often crashed. It was a common Outofmemory problem to log on to the terminal. This is usually because the system memory is

Highlights of mysql problems in CentOS Problem: 1. The problem [root @ rekfan mysql] # service mysql restart occurs.MySQL server PID file cocould not be found! [Failed]Starting MySQL... The server quit without updating PID file

101 optimization tips for MySQL databases under the CentOS ServerMySQL server hardware and operating system adjustment: 1. Have enough physical memory to load the entire InnoDB file into the memory. The speed of accessing files in the memory is much

✓ MySQL-test-5.6.12-2.linux_glibc2.5.i386.rpmMySQL-shared-5.6.12-2.linux_glibc2.5.i386.rpmMySQL-embedded-5.6.12-2.linux_glibc2.5.i386.rpmMySQL-c 1 decompress MySQL [root @ localhost test] # tar-xvf MySQL-5.6.12-2.linux_glibc2.5.i386.rpm-bundle.tar

Autocommit {0 | 1} sets whether MySQL transactions are automatically committed. 1 indicates immediate commit, and 0 indicates explicit commit. The role is global or session and can be used in the configuration file (but not in versions earlier than 5

MySQL database server optimization details I recently checked some information about MySql Optimization on the Internet, and completed some tuning settings in accordance with the MySql manual, but because the time is not busy, before you can

Because there are too many online mysql instances, Toomanyconnections is often encountered. This problem is also the most common problem. Let's take a look at it based on our own experience. Because there are Too many online mysql instances, the

Script for automatically clearing MYSQL Lock process the database server suddenly surges in the number of processes in a certain period of time recently, resulting in the database server to die, according to log query, the reason is that a large