Bucle infinito que consume memoria y provoca la caída del sitio

Imekamilika Ilichapishwa wiki 3 zilizopita Kulipwa wakati wa kujifungua

$30-250 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos.

A continuación, copio la query que genera el problema (ver captura para más información):

SELECT SQL_CALC_FOUND_ROWS [login to view URL] from vsnucam_posts left join vsnucam_term_relationships on ([login to view URL] = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ([login to view URL] = tt1.object_id) left join vsnucam_term_relationships as tt2 on ([login to view URL] = tt2.object_id) left join vsnucam_term_relationships as tt3 on ([login to view URL] = tt3.object_id) left join vsnucam_term_relationships as tt4 on ([login to view URL] = tt4.object_id) where 1=1 and ( vsnucam_term_relationships.Term_taxonomy_id in (55,1263,1265,1266,1268,1282,1284,1285,1289,1296,1297,1308,1317,1330,1331,1333,1345,1353,1354,1355,1359,1360,1369,1383,1384,1517,1518,1519,1533,1537,1542,1547,1556,1559,1583,1595,1596,1597,1598,1599,1601,1605,1622,1641,1670,1675,1682,1696,1697,1700,1702) and tt1.Term_taxonomy_id in (75,1271,1278,1303,1323,1324,1332,1337,1338,1341,1346,1382,1386,1499,1500,1520,1540,1544,1546,1552,1554,1555,1560,1562,1586,1588,1589,1592,1619,1644,1651,1653,1678,1688,1694,1695) and tt2.Term_taxonomy_id in (62,1279,1295,1307,1310,1315,1321,1322,1328,1329,1377,1504,1505,1506,1507,1526,1534,1539,1563,1564,1570,1584,1587,1590,1606,1652,1656,1674,1687,1692,1701,1704,1711,1718) and tt3.Term_taxonomy_id in (91,661,1140,1277,1293,1327,1343,1358,1378,1379,1380,1381,1388,1512,1513,1514,1515,1516,1521,1522,1524,1525,1529,1535,1536,1538,1541,1558,1582,1604,1608,1611,1621,1626,1630,1632,1634,1635,1637,1645,1654,1669,1672,1673,1676,1684,1686,1690,1703,1705,1706,1712,1714,1715,1716) and tt4.Term_taxonomy_id in (49,1272,1273,1274,1275,1276,1283,1286,1287,1288,1290,1291,1294,1298,1301,1302,1309,1311,1316,1318,1319,1325,1326,1334,1335,1344,1347,1348,1349,1351,1356,1357,1370,1371,1372,1373,1374,1375,1376,1387,1501,1508,1530,1549,1561,1565,1579,1631,1650,1679) ) and ((vsnucam_posts.post_type = 'post' AND (Vsnucam_posts.post_status = 'publish'))) group by [login to view URL] order by vsnucam_posts.post_date DESC LIMIT 0, 10

MySQL PHP SQL HTML Software Architecture

Kitambulisho cha Mradi: #38049056

Kuhusu mradi

16 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya usuf001
usuf001

Hi there, i have good experience in php and MySQL query optimisation. I can fix the query loading issue. Need plesk hosting access to review the issue and start the work. Thank you

$80 USD kwa siku 1
(Maoni 659)
7.6

16 wafanyakazi huru wanazabuni wastani wa $155 kwa kazi hii

Picha ya Profaili ya ssmlrehan0
ssmlrehan0

Project Title: Bucle infinito que consume memoria y provoca la caída del sitio Project Description: Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me bri Zaidi

$130 USD kwa siku 3
(Maoni 118)
7.4
Picha ya Profaili ya ayesha0124
ayesha0124

Hi, I can help u as i have done several similar jobs related to SQL, HTML, MySQL, Software Architecture and PHP, I have read the details and furthermore discuss about it, plz discuss with me in detail. Regards

$250 USD kwa siku 7
(Maoni 25)
6.7
Picha ya Profaili ya devbaloni1983
devbaloni1983

I have more than 15 years of experience in the development As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as poss Zaidi

$140 USD kwa siku 7
(Maoni 43)
5.6
Picha ya Profaili ya ssquare489
ssquare489

Dear Client, Just finished reading the brief details of your job. I possess a strong understanding of both the front-end and back-end which makes me a suitable candidate for your project. My ability to utilize relevan Zaidi

$120 USD kwa siku 7
(Maoni 9)
4.4
Picha ya Profaili ya qadrifreelancer
qadrifreelancer

Hello, To address the issue of the infinite loop causing excessive resource consumption and site crashes, we first need to analyze the SQL query provided. It seems that the query involves multiple joins and condition Zaidi

$80 USD kwa siku 2
(Maoni 6)
4.0
Picha ya Profaili ya aaravktech
aaravktech

Hello, I'm Dinesh Kumawat, and I'm committed to delivering high-quality work that guarantees 100% satisfaction. Your success is my priority, and I understand that the quality of my work directly impacts your achieveme Zaidi

$190 USD kwa siku 7
(Maoni 4)
2.9
Picha ya Profaili ya akhilkanaujiya98
akhilkanaujiya98

Hello Sir/Ma'am, We've come across your project brief and are eager to collaborate with you to achieve your project objectives. RoundWeb Infotech is a dynamic and agile tech firm based in India. Our team is highly ski Zaidi

$155 USD kwa siku 10
(Maoni 5)
3.0
Picha ya Profaili ya carlitanjuguna05
carlitanjuguna05

Hey! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specifi Zaidi

$100 USD kwa siku 3
(Maoni 1)
2.0
Picha ya Profaili ya masterraju686
masterraju686

Hello Sir/Ma'am, We've come across your project brief and are eager to collaborate with you to achieve your project objectives. RoundWeb Infotech is a dynamic and agile tech firm based in India. Our team is highly sk Zaidi

$140 USD kwa siku 15
(Maoni 2)
1.2
Tuma Mradi Kama huu