mysql occupation cpu100% of solution

2010-09-15  来源:本站原创  分类:Database  人气:140 

Site visits today there time-out error!
The server through the top command to see the mysql actually takes up 200 cpu resources!
Open the mysql command execution show processlist! Found in two fields in sql the time has exceeded 10,000! status for the Copying to tmp table on disk!
The state said: As the temporary result set is greater than tmp_table_size, the temporary table is stored from memory to disk storage in order to save memory.
kill two sql's id!

cpu down immediately!

相关文章
  • mysql occupation cpu100% of solution 2010-09-15

    Site visits today there time-out error! The server through the top command to see the mysql actually takes up 200 cpu resources! Open the mysql command execution show processlist! Found in two fields in sql the time has exceeded 10,000! status for th

  • MySQL error code 28 solution 2011-03-04

    MySQL error code 28 solution collection Today opened the virtual machine, create a trigger, you can succeed, but the show triggers when the report about the error: Got error 28 from storage engine The following is a detailed error code. mysql> show t

  • mysql load balancing perfect solution V1.0 (1) 2011-06-30

    mysql load balancing perfect solution V1.0 1 Environment: mysql 5 ubuntu10.04 x86_64 mdb1 eth0 192.168.5.11 mdb2 eth0 192.168.5.12 sdb1 eth0 192.168.5.21 sdb2 eth0 192.168.5.22 sdb3 eth0 192.168.5.23 sdb4 eth0 192.168.5.24 haproxy eth0 192.168.5.10 (

  • MYSQL ERROR 1045 error solution 2010-02-23

    MYSQL ERROR 1045 error about a solution 1, mysql-u root 2, use mysql 3, update user set password = old_password ('scf') where user = 'root' and host = 'localhost'; 4, FLUSH PRIVILEGES;

  • MYSQL Slow remote connection solution 2010-04-01

    MYSQL remote connectivity solutions to slow the other machines in the LAN connection of MYSQL, found it slow, do not know why, there is always a few seconds delay. Was found in the online solution, my.ini which add [Mysqld] skip-name-resolve skip-gra

  • [MySQL Error number: 1030] solution 2010-07-07

    References Bowen: http://www.webjx.com/database/mysql-15516.html Test database performance, to the MySQL database into the tens of millions of pieces of data, resulting in a database crash error → [Got error 28 from storage engine ]...... The followi

  • Mysql remote connection slow solution change 2010-08-02

    MYSQL slow remote connection, sometimes used when a remote connection to MYSQL ranging from 4-20 seconds, the local connection MYSQL normal, the problem occurs mainly because the default installation of MYSQL opened the reverse DNS resolution, in MY.

  • navicat for mysql navicat for mysql display Chinese garbled solution 2011-05-27

    Recently encountered a problem, open the database with navicat for mysql display is garbled when you are all (insert the data in the application code to ensure that characters are not garbled before), encountered problems in seeking solutions, Baidu

  • Mysql remote connection slow solution: skip-name-resolve to cancel the DNS reverse lookup 2011-04-28

    PHP MYSQL remote connection is slow, sometimes used when a remote connection to MYSQL ranging from 4-20 seconds, the local connection MYSQL normal, this problem is mainly due to the default installation of MYSQL on the reverse DNS resolution, in MY.

  • Separate mysql server connection slow solution 2011-10-18

    mysql and web server separately, and feel very slow to open the page. In the test server did not have this problem, separated only to be faster, but rather more slowly. Remember to turn over such problems, a long time, forgotten. Old, bad memory. Hah

  • super administrator under windows mysql root password forgotten solution 2010-03-09

    Reprinted from: http://www.kuqin.com/database/20080306/4249.html Today to help a friend retrieve a MYSQL ROOT super administrator password, enter the command when starting a small punched a "point" harm's tossing a few hours, finally resolved, w

  • Mysql error errno: 13 solution 2010-02-04

    Implementation of the directive sudo chown-R mysql: mysql / var / lib / mysql Where / var / lib / mysql for the mysql database to store directory

  • MySQL Font error 1130 solution! 2010-02-18

    mysql-u root-p mysql> use mysql; mysql> select user, host from user; mysql> update user set host = '%' where user = 'root'; mysql> flush privileges; mysql> select user, host from user;

  • MySQL remote connection error solution 2010-02-06

    Recently come across a more representative problems. In the one installed on the MySQL server, you use a PC, in the tomcat environment, connection closed this server, report the error cannot open connection. Use the various tools can not connect remo

  • mysql Forgot your password solution 2010-06-12

    windows systems: 1: Stop mysql service net stop mysql 2: Start mysql, mysqld-nt - skip-grant-tables 3: Open a window. Cmd, implementation of the mysql 4: use mysql 5: update user set password = password ("new password") where user = "root&q

  • forgot mysql root password linux solution 2010-07-02

    As follows: 1, close the mysql service / etc / init.d / mysqld stop 2, using the-skip-grant-tables option to start the MySQL service, you can modify / etc / inin.d / mysqld script to start the position to increase this option, vi / etc / init.d / mys

  • mysql error nr.1045 solution 2010-07-20

    1. Into the cmd manually stop the mysql service: net stop mysql. 2. Modify the C: \ Program Files \ MySQL \ MySQL Server 5.1 \ directory under the my.ini file in the [mysqld] add the next skip-grant-tables 3. In the cmd to start mysql service: net st

  • mysql root password forgotten solution 2010-07-21

    1. MySQL password recovery methods if they have forgotten the root MySQL password, you can reset the following way: 1. KILL off system in the MySQL process; killall-TERM mysqld 2. With the following command to start MySQL, do not check the permission

  • Mysql garbled on the solution to the problem under linux 2010-07-26

    mysql's garbage problem has more headaches, because it is the default character set is latin, the implementation in the database mysql> SHOW VARIABLES LIKE 'character_set_%'; +--------------------------+---------------------- ------+ | Variable_name

  • Connection to mysql server on 10065 solution 2010-08-24

    Remote access to mysql on linux has not, has been reported error 2003: connection to mysql server on 10065 I use Navicat for MySQL landing 1. Modify the way a code change table method. Your account may be allowed from a remote landing, only localhost