Bucle infinito que consume memoria y provoca la caída del sitio
$30-250 USD
Paguhet në dorëzim
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
ID Projekti: #38049056
Rreth projektit
Është zgjedhur fitues:
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 profesionistë freelancer dërguan një ofertë mesatare prej $155 për këtë punë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë