vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   PROBELM - forum ultraslow (https://vborg.vbsupport.ru/showthread.php?t=197714)

KHALIK 12-01-2008 01:41 AM
PROBELM - forum ultraslow
 
My forum/site was upgraded to another business package. It has now become extremely slow after the upgrade. I am blaming the host as the forum was fine before it was relocated. Even now when I am updating the usernames, under counters within admincp, it is very slow, previously lightning fast.

http://www.fragmasters.co.uk/forum/

This is the reply that was given.

Quote:
Dear Customer,

Please pay attention at the work of your forum with the MySQL database. Your script is trying to copy table and lock it simultaneously. In case of many queries, some mysql process may be not droped correctly, therefore your database status may be "locked" and no new queries could work with it further. Such situation can cause dramatical slowdown.


################################################## #######
[root@XXXXXX ~]# mysqladmin pr| grep fragmast

| 285397 | fragmast_frag | localhost | fragmast_kh | Query | 11 | Copying to tmp table | SELECT COUNT(post.postid) AS posts, post.userid, post.dateline, user.usergroupid, user.displaygroupi |
| 285399 | fragmast_frag | localhost | fragmast_kh | Query | 11 | Locked | UPDATE user
SET lastactivity = 1228091834
WHERE userid = 2679 |


I am cluess, what does this mean and what can I DO to solve this issue?



Advice welcomed.


All times are GMT. The time now is 02:28 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00980 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete