Problema baza de date user_max_connection
Scris: 30-Mar-2011, 23:37:14
Un fost administrator mia instalat foarte multe moduri ... uneel chiar nefolositoare gen phpbb optimize .. acest mod a modificat tabelele si toata baza astfel incat imi da eroarea user_max_connection
Ma poate ajuta cineva dintre administratori sa o rezolv la loc ..
Hostul mia zis ca daca nu rezolv aceasta problema va ramane asa , cica din 12 coreuri , forumul meu le foloseste 4
Uitati logurile catre baza de date pe care le face queriurile
Ma poate ajuta cineva dintre administratori sa o rezolv la loc ..
Hostul mia zis ca daca nu rezolv aceasta problema va ramane asa , cica din 12 coreuri , forumul meu le foloseste 4
Uitati logurile catre baza de date pe care le face queriurile
Cod: Selectaţi tot
| 7094187 | xtremexp_forumer | 89.44.246.252:39249 | xtremexp_forumer | Query | 22 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094220 | xtremexp_forumer | 89.44.246.252:39267 | xtremexp_forumer | Query | 22 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094240 | xtremexp_forumer | 89.44.246.252:39277 | xtremexp_forumer | Query | 21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094241 | xtremexp_forumer | 89.44.246.252:39278 | xtremexp_forumer | Query | 21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094278 | xtremexp_forumer | 89.44.246.252:39301 | xtremexp_forumer | Query | 20 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094294 | xtremexp_forumer | 89.44.246.252:39309 | xtremexp_forumer | Query | 21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094295 | xtremexp_forumer | 89.44.246.252:39310 | xtremexp_forumer | Query | 21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094300 | xtremexp_forumer | 89.44.246.252:39312 | xtremexp_forumer | Query | 21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094354 | xtremexp_forumer | 89.44.246.252:39339 | xtremexp_forumer | Query | 20 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094360 | iconszon_smf | 89.44.246.250:50178 | iconszon_smf | Sleep | 20 | | NULL |
| 7094366 | xtremexp_forumer | 89.44.246.252:39345 | xtremexp_forumer | Query | 18 | Locked | UPDATE phpbb_topics
SET topic_views = topic_views + 1, topic_last_view_time = 1300469659
WHERE t |
| 7094380 | xtremexp_forumer | 89.44.246.252:39353 | xtremexp_forumer | Query | 19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094382 | xtremexp_forumer | 89.44.246.252:39354 | xtremexp_forumer | Query | 19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094393 | xtremexp_forumer | 89.44.246.252:39356 | xtremexp_forumer | Query | 19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094406 | xtremexp_forumer | 89.44.246.252:39361 | xtremexp_forumer | Query | 19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094410 | xtremexp_forumer | 89.44.246.252:39364 | xtremexp_forumer | Query | 19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094439 | xtremexp_forumer | 89.44.246.252:39370 | xtremexp_forumer | Query | 18 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094453 | xtremexp_forumer | 89.44.246.252:39377 | xtremexp_forumer | Query | 18 | Locked | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094459 | xtremexp_forumer | 89.44.246.252:39381 | xtremexp_forumer | Query | 18 | Locked | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094482 | xtremexp_forumer | 89.44.246.252:39393 | xtremexp_forumer | Query | 18 | Locked | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094498 | xtremexp_forumer | 89.44.246.252:39398 | xtremexp_forumer | Query | 18 | Locked | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
Cel mai bine... este de la php-ul serverului node.