Pagina 1 di 1

Query che superano i valori consentiti, come mai?

Inviato: 14/05/2014, 18:30
da Polv89
Qualcuno può darmi una mano nel risolvere questo problema?
Il forum non è neanche frequentatissimo...

Codice: Seleziona tutto

il servizio di hosting è stato sospeso per la violazione delle policy QoS pubbliche e presenti all'indirizzo: https://www.netsons.com/knowledgebase.php?action=displayarticle&id=1

Nella fattispecie alcune sue query superano di gran lunga i valori consentiti. Le riporto una delle query in questione:

# User@Host: ********[*********] @ localhost [127.0.0.1]
# Query_time: 13.639507 Lock_time: 0.001257 Rows_sent: 0 Rows_examined: 0
use ***************;
SET timestamp=1396339658;
DELETE FROM ********_search_wordmatch
WHERE word_id IN ('1', '4', '6', '8', '9', '10', '18', '19', '21', '22', '28', '30', '44', '46', '56', '59', '60', '62', '64', '70', '71', '74', '75', '81', '82', '83', '90', '91', '93', '98', '99', '103', '107', '108', '111', '117', '118', '122', '123', '133', '138', '143', '145', '146', '152', '159', '163', '183', '184', '191', '195', '203', '205', '215', '220', '244', '246', '249', '257', '259', '265', '273', '274', '280', '282', '317', '322', '327', '346', '356', '364', '365', '370', '376', '384', '395', '397', '412', '417', '418', '419', '423', '424', '428', '434', '436', '437', '442', '444', '449', '450', '452', '453', '455', '456', '460', '462', '464', '466', '467', '468', '469', '471', '474', '480', '483', '484', '489', '500', '502', '503', '506', '511', '514', '515', '516', '518', '520', '521', '526', '527', '530', '532', '533', '536', '537', '539', '543', '551', '553', '555', '561', '563', '564', '565', '567', '576', '578', '579', '582', '583', '584', '585', '587', '588', '589', '595', '597', '601', '608', '609', '610', '611', '612', '613', '615', '616', '621', '624', '627', '632', '633', '635', '641', '643', '644', '647', '649', '651', '653', '654', '656', '661', '664', '665', '667', '668', '670', '672', '673', '677', '678', '679', '680', '687', '688', '689', '691', '693', '694', '697', '699', '701', '705', '708', '711', '717', '718', '722', '725', '729', '731', '732', '733', '739', '741', '745', '746', '748', '757', '762', '763', '766', '769', '770', '773', '777', '779', '786', '818', '822', '827', '829', '841', '848', '850', '860', '861', '870', '873', '934', '955', '985', '986', '987', '988', '989', '992', '993', '994', '997', '998', '1004', '1007', '1010', '1014', '1015', '1018', '1021', '1022', '1023', '1026', '1028', '1029', '1031', '1034', '1051', '1056', '1063', '1069', '1071', '1073', '1074', '1076', '1077', '1078', '1082', '1084', '1085', '1098', '1108', '1110', '1111', '1113', '1119', '1121', '1125', '1126', '1127', '1128', '1131', '1135', '1138', '1140', '1141', '1145', '1148', '1151', '1153', '1161', '1164', '1168', '1175', '1176', '1177', '1182', '1185', '1186', '1187', '1190', '1191', '1192', '1198', '1200', '1201', '1202', '1205', '1207', '1208', '1210', '1211', '1215', '1216', '1217', '1218', '1220', '1221', '1222', '1223', '1224', '1225', '1228', '1230', '1231', '1234', '1237', '1240', '1243', '1245', '1250', '1251', '1252', '1258', '1259', '1260', '1263', '1264', '1266', '1267', '1270', '1272', '1275', '1278', '1279', '1282', '1286', '1287', '1289', '1291', '1293', '1297', '1303', '1304', '1306', '1309', '1310', '1311', '1312', '1313', '1314', '1326', '1327', '1329', '1330', '1331', '1332', '1333', '1335', '1338', '1339', '1341', '1343', '1345', '1347', '1348', '1356', '1359', '1362', '1365', '1368', '1369', '1382', '1384', '1386', '1389', '1391', '1394', '1397', '1400', '1401', '1404', '1405', '1413', '1416', '1423', '1424', '1427', '1428', '1429', '1430', '1432', '1433', '1437', '1438', '1439', '1440', '1441', '1442', '1445', '1450', '1451', '1453', '1454', '1459', '1460', '1464', '1468', '1469', '1473', '1474', '1478', '1482', '1494', '1496', '1501', '1502', '1503', '1506', '1508', '1509', '1510', '1512', '1523', '1524', '1526', '1527', '1529', '1533', '1535', '1538', '1542', '1544', '1546', '1548', '1549', '1553', '1554', '1555', '1557', '1565', '1567', '1568', '1569', '1572', '1573', '1578', '1589', '1591', '1592', '1602', '1606', '1607', '1612', '1614', '1615', '1622', '1642', '1645', '1647', '1651', '1659', '1662', '1666', '1669', '1670', '1678', '1681', '1689', '1690', '1691', '1692', '1694', '1702', '1703', '1704', '1719', '1720', '1726', '1727', '1735', '1740', '1747', '1752', '1765', '1766', '1769', '1770', '1774', '1777', '1778', '1781', '1795', '1817', '1841', '1852', '1853', '1856', '1909', '1915', '1930', '1941', '1945', '1949', '1964', '1965', '1966', '1971', '1979', '1980', '1990', '2003', '2017', '2021', '2034', '2035', '2036', '2037', '2038', '2043', '2047', '2048', '2066', '2067', '2082', '2086', '2095', '2099', '2106', '2111', '2129', '2156', '2163', '2166', '2186', '2195', '2196', '2198', '2199', '2200', '2208', '2211', '2214', '2220', '2223', '2236', '2265', '2274', '2341', '2343', '2352', '2384', '2419', '2420', '2435', '2438', '2447', '2448', '2449', '2451', '2456', '2471', '2483', '2485', '2490', '2491', '2493', '2497', '2504', '2505', '2508', '2509', '2513', '2515', '2519', '2530', '2534', '2536', '2539', '2544', '2548', '2549', '2551', '2606', '2616', '2633', '2639', '2648', '2651', '2678', '2718', '2723', '2725', '2770', '2793', '2805', '2823', '2824', '2854', '2888', '2891', '2927', '2967', '2977', '3051', '3053', '3082', '3097', '3215', '3232', '3233', '3243', '3265', '3266', '3267', '3268', '3270', '3273', '3276', '3319', '3330', '3331', '3332', '3349', '3371', '3377', '3380', '3385', '3402', '3408', '3410', '3421', '3423', '3426', '3436', '3442', '3450', '3451', '3452', '3453', '3459', '3464', '3470', '3472', '3475', '3500', '3502', '3525', '3527', '3534', '3545', '3591', '3605', '3633', '3655', '3677', '3685', '3690', '3692', '3708', '3727', '3729', '3731', '3747', '3757', '3759', '3791', '3817', '3820', '3831', '3927', '3940', '3963', '3964', '3971', '3981', '3985', '3988', '3989', '3995', '3997', '4006', '4011', '4022', '4024', '4026', '4027', '4028', '4034', '4044', '4051', '4052', '4068', '4096', '4099', '4123', '4135', '4142', '4148', '4150', '4153', '4156', '4160', '4168', '4170', '4173', '4174', '4186', '4199', '4203', '4222', '4321', '4322', '4330', '4333', '4342', '4381', '4423', '4424', '4444', '4449', '4450', '4452', '4457', '4458', '4460', '4462', '4472', '4477', '4479', '4482', '4500', '4503', '4557', '4587', '4608', '4618', '4629', '4662', '4664', '4665', '4666', '4670', '4671', '4677', '4679', '4681', '4683', '4684', '4686', '4688', '4689', '4691', '4696', '4701', '4704', '4705', '4707', '4713', '4730', '4734', '4736', '4737', '4741', '4761', '4762', '4763', '4767', '4771', '4775', '4776', '4854', '4871', '5054', '5057', '5062', '5063', '5065', '5085', '5116', '5198', '5293', '5430', '5434', '5436', '5437', '5441', '5500', '5519', '5583', '5592', '5601', '5611', '5641', '5643', '5708', '5719', '5805', '5818', '5862', '5863', '5866', '5868', '5869', '5927', '5951', '5954', '6148', '6306', '6311', '6313', '6314', '6338', '6357', '6358', '6426', '6429', '6447', '6497', '6521', '6570', '6587', '6625', '6627', '6636', '6676', '6677', '6702', '6708', '6712', '6715', '6780', '6793', '6795', '6796', '6838', '6846', '6848', '6853', '6885', '6887', '6903', '7157', '7164', '7166', '7178', '7184', '7209', '7225', '7233', '7276', '7316', '7322', '7438', '7447', '7488', '7490', '7495', '7500', '7508', '7513', '7516', '7518', '7528', '7530', '7535', '7651', '7695', '7711', '7714', '7797', '7840', '7841', '7869', '7881', '7902', '7923', '7992', '8005', '8034', '8045', '8056', '8058', '8074', '8082', '8088', '8099', '8119', '8127', '8128', '8131', '8154', '8208', '8211', '8214', '8221', '8236', '8251', '8255', '8256', '8270', '8282', '8337', '8356', '8409', '8411', '8413', '8418', '8421', '8441', '8442', '8443', '8444', '8447', '8449', '8452', '8467', '8468', '8472', '8475', '8478', '8492', '8504', '8507', '8535', '8550', '8581', '8585', '8587', '8613', '8635', '8660', '8661', '8662', '8704', '8705', '8707', '8711', '8720', '8721', '8722', '8724', '8725', '8727', '8729', '8730', '8731', '8739', '8746', '8749', '8752', '8753', '8756', '8797', '8869', '8872', '8876', '8878', '8880', '8883', '8885', '8887', '8889', '8900', '8901', '8904', '8907', '8913', '8914', '8915', '8917', '8930', '8945', '8946', '8947', '8956', '8960', '8963', '8966', '8972', '8979', '8991', '9001', '9003', '9007', '9008', '9016', '9021', '9025', '9030', '9034', '9038', '9051', '9055', '9057', '10262', '10263', '9080', '9168', '9289', '9318', '9432', '9452', '10415', '10366', '10359', '9921', '9949', '9950', '9951', '10421', '10513', '10516', '10518', '10519', '10526', '10530', '10531', '10532', '10535', '10536', '10538', '10540', '10543', '10545', '10549', '10552', '10554', '10555', '10558', '10561', '10568', '10580', '10581', '10587', '10589', '10600', '10606', '10609', '10613', '10614', '10621', '10623', '10624', '10625', '10626', '10631', '10633', '10636', '10637', '10638', '10640', '10644', '10648', '10661', '10662', '10668', '10693', '10696', '10697', '10698', '10702', '10703', '10704', '10707', '10708', '10709', '10713', '10716', '10720', '10722', '10724', '10727', '10728', '10735', '10736', '10737', '10740', '10743', '10762', '10766', '10768', '10769', '10770', '10776', '10781', '10782', '10785', '10789', '10801', '10802', '10805', '10807', '10811', '10813', '10814', '10816', '10817', '10824', '10831', '10832', '10842', '10859', '10861', '10885', '10886', '10888', '10890', '10892', '10894', '10898', '10926', '10931', '10933', '10940', '10948', '10963', '10967', '10980', '10984', '11004', '11005', '11008', '11010', '11014', '11018', '11020', '11024', '11025', '11026', '11027', '11031', '11038', '11045', '11046', '11047', '11053', '11055', '11057', '11060', '11061', '11066', '11069', '11071', '11074', '11556', '11543', '11546', '11547', '11548', '11550', '11552', '11553', '11525', '11526', '11528', '11530', '11531', '11536', '11538', '11539', '11089', '11092', '11106', '11108', '11116', '11118', '11119', '11122', '11125', '11126', '11128', '11134', '11135', '11144', '11150', '11151', '11157', '11158', '11169', '11190', '11198', '11199', '11202', '11203', '11278', '11281', '11282', '11287', '11291', '11295', '11303', '11565', '11521', '11567', '11569', '11571', '11523', '11514', '11517', '11322', '11325', '11326', '11328', '11329', '11332', '11335', '11340', '11349', '11381', '11383', '11386', '11406', '11409', '11411', '11418', '11430', '11434', '11436', '11559', '11563', '11466', '11498', '11499', '11586', '11587', '11600', '12370', '11705', '11722', '11723', '11724', '11726', '11729', '11730', '11733', '11737', '11739', '11740', '11742', '11753', '11754', '11755', '11758', '11759', '11766', '11771', '11772', '11773', '11774', '11779', '11789', '11794', '11798', '11799', '11803', '11804', '11805', '11806', '11807', '11808', '11815', '11816', '11817', '11828', '11835', '11851', '14071', '11895', '11913', '11921', '11941', '11949', '11958', '11959', '11961', '11963', '11966', '11969', '11971', '11979', '11982', '11983', '11984', '11989', '11990', '11991', '11995', '11996', '11997', '12001', '12002', '12023', '12025', '12029', '12030', '12031', '12033', '12035', '12048', '12045', '12063', '12070', '12079', '12080', '12086', '12090', '12092', '12113', '12121', '12129', '12130', '12131', '12133', '12135', '12159', '12163', '12170', '12186', '12484', '12199', '12200', '12203', '12204', '12208', '12211', '12215', '12221', '12223', '12230', '12231', '12241', '12243', '12244', '12246', '12251', '12258', '12260', '12262', '12265', '12269', '12271', '12279', '12280', '12289', '12292', '12294', '12300', '12469', '12347', '12348', '12397', '12400', '12421', '12422', '12423', '12431', '12457', '12535', '12536', '12560', '12564', '12565', '12566', '12568', '12571', '12575', '12583', '12589', '12591', '12597', '12601', '12602', '12603', '12604', '12611', '12612', '12616', '12625', '12626', '12629', '12642', '12646', '12647', '12660', '12663', '12666', '12668', '12669', '12673', '12680', '12685', '12687', '12698', '12700', '12707', '12714', '12717', '12720', '12732', '12733', '12737', '12738', '12739', '12747', '12749', '12750', '12757', '12802', '12818', '12834', '12884', '12913', '12915', '12918', '12919', '12963', '12969', '12970', '12975', '12977', '12983', '12986', '12997', '13004', '13043', '13044', '13049', '13053', '13054', '13057', '13062', '13063', '13064', '13066', '13067', '13069', '13074', '13093', '13098', '13102', '13103', '13107', '13112', '13113', '13115', '13127', '13131', '13139', '13140', '13144', '13149', '13150', '13166', '13159', '13165', '13167', '13160', '13177', '13178', '13181', '13186', '13188', '13191', '13193', '13196', '13197', '13199', '13206', '13212', '13217', '13218', '13225', '13228', '13241', '13247', '13253', '13257', '13320', '13325', '13337', '13378', '13385', '13454', '13457', '13472', '13487', '13537', '13571', '13576', '13591', '13609', '13610', '13616', '13623', '13631', '13633', '13636', '13656', '13659', '13660', '13671', '13681', '13692', '13700', '13719', '13754', '13856', '13858', '13866', '13871', '13875', '13878', '13891', '13934', '13933', '13935', '13936', '13941', '13943', '13944', '13952', '13953', '13954', '13961', '13963', '13969', '13973', '13975', '13978', '14045', '14040', '14015', '14024', '14048', '14073', '14079', '14084', '14341', '14383', '14394', '15340', '14531', '14575', '14623', '14682', '14745', '14885', '14953', '14977', '14986', '15157', '15160', '15165', '15169', '15173', '15223', '15238', '15248', '15299', '15349', '15360', '15395', '15444', '15445', '15452', '15565', '15627', '15938', '15937', '15661', '15664', '15692', '15739', '15768', '15889', '15899', '15950', '15996', '15999', '16002', '16005', '16006', '16008', '16009', '16075', '16238', '16240', '16244', '16442', '16470', '16481', '16496', '16506', '16507', '16574', '16576', '16621', '16623', '16684', '16734', '16792', '16801', '16804', '16816', '16867', '16872', '16978', '17023', '18622', '17194', '17200', '17209', '17226', '17245', '17248', '17263', '17298', '17334', '17385', '17428', '17581', '17653', '17666', '17693', '17818', '17857', '17866', '17883', ':

Re: Query che superano i valori consentiti, come mai?

Inviato: 14/05/2014, 22:12
da Barrnet
Il forum ha mod?
su quale fascia di hosting è hostato?

Re: R: Query che superano i valori consentiti, come mai?

Inviato: 15/05/2014, 17:35
da Polv89
Barrnet ha scritto:Il forum ha mod?
su quale fascia di hosting è hostato?
Si, ha delle mod...
Ha l'hosting fast di netsons

Re: Query che superano i valori consentiti, come mai?

Inviato: 15/05/2014, 21:35
da Barrnet
Quant'è il carico di utenza e di visite?
Quali mod sono installate?

Re: R: Query che superano i valori consentiti, come mai?

Inviato: 16/05/2014, 16:46
da Polv89
Sinceramente il forum era fermo quindi per questo mi è sembrato strano... Gli utenti sono un centinaio o poco più ma poco attivi come dicevo
Provo a ricordare :Ho tapatalk, la mod per il menù in alto , il seo (http://www.nexusarena.it/forum)

Inviato dal mio Nexus 5 (by Nexusarena.it)

Re: Query che superano i valori consentiti, come mai?

Inviato: 16/05/2014, 23:22
da Barrnet
Ok, abilita il debug di phpBB decommentando le ultime due righe del file config.php, nel footer ti apparirà un link per vedere tutte le query ed il loro tempo di esecuzione, riportale qui.