مشکل بالا رفتن مصرف cpu در سرور به دلیل افزایش بیش از حد مصرف دیتابیس رو دارم

بعد اینکه دیتابیس در سرور stop میشه مصرف cpu شدیدا کاهش پیدا می کنه نتیجه SHOW PROCESSLIST در mysql این هست

لطفا دوستانی که می دونن چطور حل کنم کمک کنن

به نظرم می رسه مشکل به دلیل table cache یا query cache یا innodb_buffer_pool_size باشه اما نمی دونم چی کار کنم لود بالا نره

اگه عزیزان بتونن راهکار این مشکل رو با دستوری به من بگن می تونم کرون بکنمش

چون یکم سی پی یو سرورم ضعیفه باید کنار بیام

نتیجه SHOW PROCESSLIST

+-----+------------+-----------+------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------------+-----------+------------+---------+------+-------+------------------+
| 567 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 574 | jambo_head | localhost | jambo_head | Sleep | 138 | | NULL |
| 638 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 652 | jambo_head | localhost | jambo_head | Sleep | 52 | | NULL |
| 656 | jambo_head | localhost | jambo_head | Sleep | 11 | | NULL |
| 662 | jambo_head | localhost | jambo_head | Sleep | 44 | | NULL |
| 664 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 667 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 670 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 671 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 672 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 673 | jambo_head | localhost | jambo_head | Sleep | 5 | | NULL |
| 675 | jambo_head | localhost | jambo_head | Sleep | 13 | | NULL |
| 676 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 677 | jambo_head | localhost | jambo_head | Sleep | 6 | | NULL |
| 678 | jambo_head | localhost | jambo_head | Sleep | 33 | | NULL |
| 680 | jambo_head | localhost | jambo_head | Sleep | 30 | | NULL |
| 681 | jambo_head | localhost | jambo_head | Sleep | 29 | | NULL |
| 682 | jambo_head | localhost | jambo_head | Sleep | 27 | | NULL |
| 683 | jambo_head | localhost | jambo_head | Sleep | 25 | | NULL |
| 684 | jambo_head | localhost | jambo_head | Sleep | 28 | | NULL |
| 685 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 686 | jambo_head | localhost | jambo_head | Sleep | 25 | | NULL |
| 687 | jambo_head | localhost | jambo_head | Sleep | 3 | | NULL |
| 688 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 689 | jambo_head | localhost | jambo_head | Sleep | 25 | | NULL |
| 690 | jambo_head | localhost | jambo_head | Sleep | 25 | | NULL |
| 692 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 693 | jambo_head | localhost | jambo_head | Sleep | 10 | | NULL |
| 695 | jambo_head | localhost | jambo_head | Sleep | 26 | | NULL |
| 696 | jambo_head | localhost | jambo_head | Sleep | 18 | | NULL |
| 698 | jambo_head | localhost | jambo_head | Sleep | 17 | | NULL |
| 700 | jambo_head | localhost | jambo_head | Sleep | 22 | | NULL |
| 701 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 703 | jambo_head | localhost | jambo_head | Sleep | 38 | | NULL |
| 705 | jambo_head | localhost | jambo_head | Sleep | 17 | | NULL |
| 707 | jambo_head | localhost | jambo_head | Sleep | 37 | | NULL |
| 708 | jambo_head | localhost | jambo_head | Sleep | 36 | | NULL |
| 709 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 710 | jambo_head | localhost | jambo_head | Sleep | 30 | | NULL |
| 711 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST |
| 712 | jambo_head | localhost | jambo_head | Sleep | 33 | | NULL |
| 713 | jambo_head | localhost | jambo_head | Sleep | 6 | | NULL |
| 714 | jambo_head | localhost | jambo_head | Sleep | 30 | | NULL |
| 716 | jambo_head | localhost | jambo_head | Sleep | 29 | | NULL |
| 717 | jambo_head | localhost | jambo_head | Sleep | 29 | | NULL |
| 718 | jambo_head | localhost | jambo_head | Sleep | 5 | | NULL |
| 719 | jambo_head | localhost | jambo_head | Sleep | 4 | | NULL |
| 721 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 722 | jambo_head | localhost | jambo_head | Sleep | 24 | | NULL |
| 723 | jambo_head | localhost | jambo_head | Sleep | 25 | | NULL |
| 726 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 727 | jambo_head | localhost | jambo_head | Sleep | 7 | | NULL |
| 729 | jambo_head | localhost | jambo_head | Sleep | 6 | | NULL |
| 730 | jambo_head | localhost | jambo_head | Sleep | 7 | | NULL |
| 731 | jambo_head | localhost | jambo_head | Sleep | 19 | | NULL |
| 733 | jambo_head | localhost | jambo_head | Sleep | 17 | | NULL |
| 734 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 735 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 736 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 737 | jambo_head | localhost | jambo_head | Sleep | 14 | | NULL |
| 738 | jambo_head | localhost | jambo_head | Sleep | 14 | | NULL |
| 739 | jambo_head | localhost | jambo_head | Sleep | 13 | | NULL |
| 740 | jambo_head | localhost | jambo_head | Sleep | 13 | | NULL |
| 741 | jambo_head | localhost | jambo_head | Sleep | 12 | | NULL |
| 742 | jambo_head | localhost | jambo_head | Sleep | 3 | | NULL |
| 743 | jambo_head | localhost | jambo_head | Sleep | 9 | | NULL |
| 744 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 745 | jambo_head | localhost | jambo_head | Sleep | 15 | | NULL |
| 746 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 747 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 748 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 749 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 750 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 751 | jambo_head | localhost | jambo_head | Sleep | 5 | | NULL |
| 752 | jambo_head | localhost | jambo_head | Sleep | 4 | | NULL |
| 753 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 754 | jambo_head | localhost | jambo_head | Sleep | 3 | | NULL |
| 755 | jambo_head | localhost | jambo_head | Sleep | 12 | | NULL |
| 756 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 757 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
| 758 | jambo_head | localhost | jambo_head | Sleep | 6 | | NULL |
| 759 | jambo_head | localhost | jambo_head | Sleep | 7 | | NULL |
| 760 | jambo_head | localhost | jambo_head | Sleep | 6 | | NULL |
| 761 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 762 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 763 | jambo_head | localhost | jambo_head | Sleep | 5 | | NULL |
| 764 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 765 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 766 | jambo_head | localhost | jambo_head | Sleep | 2 | | NULL |
| 767 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 768 | jambo_head | localhost | jambo_head | Sleep | 1 | | NULL |
| 769 | jambo_head | localhost | jambo_head | Sleep | 0 | | NULL |
+-----+------------+-----------+------------+---------+------+-------+------------------+