mvogel4949
(mvogel4949)
1
My system is super slow. Looking at htop I see the following command is running around 170% CPU
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pic --socket=/var/lib/mysql/mysql.sock
Reboot took care of it for a bit but then it came right back.
V15 FreePBX Distro
mvogel4949
(mvogel4949)
2
MariaDB [(none)]> SHOW PROCESSLIST\G;
*************************** 1. row ***************************
Id: 208
User: freepbxuser
Host: localhost:45466
db: asterisk
Command: Sleep
Time: 6513
State:
Info: NULL
Progress: 0.000
*************************** 2. row ***************************
Id: 211
User: freepbxuser
Host: localhost:45478
db: asterisk
Command: Sleep
Time: 6510
State:
Info: NULL
Progress: 0.000
*************************** 3. row ***************************
Id: 218
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 6501
State:
Info: NULL
Progress: 0.000
*************************** 4. row ***************************
Id: 236
User: freepbxuser
Host: localhost:45640
db: asterisk
Command: Sleep
Time: 6490
State:
Info: NULL
Progress: 0.000
*************************** 5. row ***************************
Id: 427
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 6. row ***************************
Id: 429
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '38464'
Progress: 0.000
*************************** 7. row ***************************
Id: 447
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 8. row ***************************
Id: 448
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '38867'
Progress: 0.000
*************************** 9. row ***************************
Id: 520
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 10. row ***************************
Id: 523
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '39153'
Progress: 0.000
*************************** 11. row ***************************
Id: 606
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 12. row ***************************
Id: 607
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '39406'
Progress: 0.000
*************************** 13. row ***************************
Id: 614
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 14. row ***************************
Id: 616
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '39409'
Progress: 0.000
*************************** 15. row ***************************
Id: 631
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 16. row ***************************
Id: 634
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '39463'
Progress: 0.000
*************************** 17. row ***************************
Id: 729
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 18. row ***************************
Id: 730
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '40579'
Progress: 0.000
*************************** 19. row ***************************
Id: 844
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 20. row ***************************
Id: 848
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '41416'
Progress: 0.000
*************************** 21. row ***************************
Id: 1088
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 22. row ***************************
Id: 1092
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '44304'
Progress: 0.000
*************************** 23. row ***************************
Id: 1100
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 24. row ***************************
Id: 1101
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '44305'
Progress: 0.000
*************************** 25. row ***************************
Id: 1142
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 26. row ***************************
Id: 1145
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '44355'
Progress: 0.000
*************************** 27. row ***************************
Id: 1151
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 28. row ***************************
Id: 1153
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Opening tables
Info: SELECT * FROM sms_media WHERE `mid` = '44392'
Progress: 0.000
*************************** 29. row ***************************
Id: 1158
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 1
State:
Info: NULL
Progress: 0.000
*************************** 30. row ***************************
Id: 1159
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 1
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '44485'
Progress: 0.000
*************************** 31. row ***************************
Id: 1166
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 32. row ***************************
Id: 1168
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '44507'
Progress: 0.000
*************************** 33. row ***************************
Id: 1237
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 1
State:
Info: NULL
Progress: 0.000
*************************** 34. row ***************************
Id: 1242
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 1
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '45535'
Progress: 0.000
*************************** 35. row ***************************
Id: 1254
User: freepbxuser
Host: localhost:52468
db: asterisk
Command: Sleep
Time: 4375
State:
Info: NULL
Progress: 0.000
*************************** 36. row ***************************
Id: 1371
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 37. row ***************************
Id: 1373
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '47897'
Progress: 0.000
*************************** 38. row ***************************
Id: 1655
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 39. row ***************************
Id: 1664
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '50116'
Progress: 0.000
*************************** 40. row ***************************
Id: 1671
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 41. row ***************************
Id: 1675
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '50118'
Progress: 0.000
*************************** 42. row ***************************
Id: 1749
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 43. row ***************************
Id: 1756
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '50333'
Progress: 0.000
*************************** 44. row ***************************
Id: 1865
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 45. row ***************************
Id: 1868
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Sending data
Info: SELECT * FROM sms_media WHERE `mid` = '50516'
Progress: 0.000
*************************** 46. row ***************************
Id: 1906
User: freepbxuser
Host: localhost
db: asteriskcdrdb
Command: Sleep
Time: 50
State:
Info: NULL
Progress: 0.000
*************************** 47. row ***************************
Id: 1937
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 381
State:
Info: NULL
Progress: 0.000
*************************** 48. row ***************************
Id: 1938
User: freepbxuser
Host: localhost
db: asteriskcdrdb
Command: Sleep
Time: 3016
State:
Info: NULL
Progress: 0.000
*************************** 49. row ***************************
Id: 2149
User: freepbxuser
Host: localhost
db: asteriskcdrdb
Command: Sleep
Time: 12
State:
Info: NULL
Progress: 0.000
*************************** 50. row ***************************
Id: 3074
User: freepbxuser
Host: localhost
db: asterisk
Command: Sleep
Time: 16
State:
Info: NULL
Progress: 0.000
*************************** 51. row ***************************
Id: 3078
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: SHOW PROCESSLIST
Progress: 0.000
*************************** 52. row ***************************
Id: 3079
User: freepbxuser
Host: localhost
db: asterisk
Command: Query
Time: 0
State: Copying to tmp table
Info: SELECT sm.* FROM sms_messages sm, sms_routing sr WHERE sr.uid = '85' AND (sm.from = sr.did OR sm.to
Progress: 0.000
52 rows in set (0.00 sec)
system
(system)
Closed
4
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.