Mysql Usage

rmzy

• May 04, 2017 11:28

please solve the problem The problem of high pressure on the rules without reason She has a vps 1 Core Intel" Xeon" E5-2650L P4 Rum 1 ssd 20 Load 20 9088 mysql 20 0 913376 49744 1240 S 31.3 4.9 56:36.95 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/+

• 

  cPanelMichael

  • May 04, 2017 16:52

  Hello, You can run the following command to get a better idea of what databases and tables are using the most resources:
  mysqladmin processlist
  Thank you.

  0
• 

  rmzy

  • May 04, 2017 17:01

  Results +--------+------------+-----------+------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+------------+-----------+------------+---------+------+-------+------------------+ | 221417 | xxxx_vb | localhost | xxxxx_vb | Sleep | 0 | | | | 221418 | xxxx_s | localhost | xxxx_s | Sleep | 0 | | | | 221419 | root | localhost | | Query | 0 | init | show processlist | +--------+------------+-----------+------------+---------+------+-------+------- Results [mysqld] innodb_file_per_table=1 default-storage-engine=MyISAM performance-schema=0 max_allowed_packet=268435456 Is there a problem with this

  0
• 

  cPanelMichael

  • May 04, 2017 17:03

  Hello, I don't see any issues based on that output. The following thread is helpful if you want to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.