有台mysql数据库
今天网站流量较大,发现mysql占内存上升了不少。 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28066 mysql 15 0 9926m 5.1g 4556 S 0.0 65.5 3818:46 mysqld平时也就10到20之间
相看一下是哪些数据造成的内存占用变多。进mysqlmysql> show full processlist;
+----------+------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+------+-----------+------+---------+------+-------+-----------------------+
| 34629296 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+----------+------+-----------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec)结果什么都没有。奇怪了。因本人对mysql不太了解,所以想问一下,有什么方法能看出是哪些数据库操作占用了内存。
今天网站流量较大,发现mysql占内存上升了不少。 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28066 mysql 15 0 9926m 5.1g 4556 S 0.0 65.5 3818:46 mysqld平时也就10到20之间
相看一下是哪些数据造成的内存占用变多。进mysqlmysql> show full processlist;
+----------+------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+------+-----------+------+---------+------+-------+-----------------------+
| 34629296 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+----------+------+-----------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec)结果什么都没有。奇怪了。因本人对mysql不太了解,所以想问一下,有什么方法能看出是哪些数据库操作占用了内存。
看下innodb_buffer_pool的使用情况