Bucle infinito que consume memoria y provoca la caída del sitio
$30-250 USD
Paid on delivery
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
Project ID: #38049056
About the project
Awarded to:
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
16 freelancers are bidding on average $155 for this job
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 More
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
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 More
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 More
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 More
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 More
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 More
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 More
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 More
