what command can i use to kill these sql quries wich make a big server load

SUBMITTED BY: Guest

DATE: Sept. 30, 2019, 8:10 a.m.

FORMAT: Text only

SIZE: 4.7 kB

Raw Download

HITS: 453

Report
  1. what command can i use to kill these sql quries wich make a big server load
  2. after a big number of visitors who visit my site at the same time (near 800 people)
  3. i am taking hundrends of these queries
  4. ++++++++++++++
  5. If You want to buy cheap web hosting then visit http://Listfreetop.pw and select the cheapest hosting. it can be suitable for all your needs.
  7. Top 200 best traffic exchange sites http://Listfreetop.pw/surf
  9. list of top gpt sites
  10. list of top ptc sites
  11. list of top ptp sites
  12. list of top crypto currency Wallets sites
  13. Listfreetop.pw
  14. Listfreetop.pw
  15. Listfreetop.pw
  16. +++++++++++++++
  17. mysql> SELECT post_id FROM wp_postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = ‘medium’ limit 10; Empty set (40.03 sec)
  18. these make my site loads very slowly, even now the number of visitors are very very low (near 300)
  19. i have a powerfull vps with 8 cores and 16 gbyte ram.i use MySQL Version: 5.7.25-0ubuntu0.16.04.2 nad Ubuntu operating system
  20. I repeat the server was working VERY good the problem created nad remains after the big number of visitors
  21. i have the last version of wordpress and i am using the basic plugins
  23. after a big number of visitors who visit my site at the same time (near 800 people)
  24. i am taking hundrends of these queries
  25. mysql> SELECT post_id FROM wp_postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = ‘medium’ limit 10; Empty set (40.03 sec)
  26. these make my site loads very slowly, even now the number of visitors are very very low (near 300)
  27. i have a powerfull vps with 8 cores and 16 gbyte ram.i use MySQL Version: 5.7.25-0ubuntu0.16.04.2 nad Ubuntu operating system
  28. I repeat the server was working VERY good the problem created nad remains after the big number of visitors
  29. i have the last version of wordpress and i am using the basic plugins
  30. Killing the query is the wrong answer and starting with doing this could cause application and database problems that might be unrecoverable. You need to find out why it is taking 40 seconds for the query to run. It is more than likely due to slow disks, unoptimized queries or unindexed queries. If this is supposed to be long running it needs to be run on another server or may need to setup multiple separate database servers to handle your queries.
  32. How large is your database, are you able to store all of the data in RAM to increase query performance so it does not have to hit the disk?
  34. Check your MySQL logs to figure out what your slow queries are for the first step of performance running and check to see if there are other queries running at the same time. You should also look into implementing caching (redis, memcached, etc.) so you can store the results of the queries in memory.
  36. You need to optimize it properly and not just killing it.
  37. Specially 4 You ||| Elevate Your Sites
  39. Agreed with all, killing it is not the solution, you need to find the reason and fix it.
  40. Also you can consider using mariadb as server instead of mysql as it perform faster. (make sure you have a backup before doing the server change.)
  41. Panamaserver.com
  42. Offshore Shared Hosting, VPS and Dedicated Servers in Panama
  44. [FONT="]after a big number of visitors who visit my site at the same time (near 800 people)[/FONT]
  45. [FONT="]i am taking hundrends of these queries[/FONT]
  46. [FONT="]mysql> SELECT post_id FROM wp_postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = ‘medium’ limit 10; Empty set (40.03 sec)[/FONT]
  47. [FONT="]these make my site loads very slowly, even now the number of visitors are very very low (near 300)[/FONT]
  48. [FONT="]i have a powerfull vps with 8 cores and 16 gbyte ram.i use MySQL Version: 5.7.25-0ubuntu0.16.04.2 nad Ubuntu operating system[/FONT]
  49. [FONT="]I repeat the server was working VERY good the problem created nad remains after the big number of visitors[/FONT]
  50. i have the last version of wordpress and i am using the basic plugins
  51. Like others have said, don't kill the queries. It can corrupt the tables/DB. If you need a temp band-aid use a SQL proxy to either cache these queries or filter them out. That'll buy you some time.
  53. Cheers
  54. UNIXy - Fully Managed Servers and Clusters - Established in 2006
  55. Server Management - Unlimited Servers. Unlimited Requests. One Plan!
  56. cPanel Varnish Plugin -- Seamless SSL Caching (Let's Encrypt, AutoSSL, etc)
  57. Slow Site or Server? Unable to handle traffic? Same day performance fix: joe@unixy
  59. I'd say to implement OPCache, and perhaps convert the wp_postmeta table to InnoDB (ALTER TABLE wp_postmeta ENGINE=InnoDB and re-test after 24 hours.
  61. 5 hostages venezuela
  62. ibalink.com
  63. make money college student
  64. host vs server
  65. 1 domain drive
  66. host explorer
  67. host 99
  68. e- domain geometry
  69. kryptomachine.com
  70. surfskeleton.com
  71. host home
comments powered by Disqus