vb.org Archive - [HELP] 2.5.6 is putting a load in my server

Page 5 of 6

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - [HELP] 2.5.6 is putting a load in my server (https://vborg.vbsupport.ru/showthread.php?t=116053)

Barabaika

09-27-2006 03:56 PM

You should put this in your my.cnf:

long_query_time=1
log-slow-query=/var/log/mysql/mysql-slow.log

1 second is the lowest setting for now, but that's good enough to find the slowest queries.
If the log says that to find 1 entry it scanned 50000 entries, that means something is wrong with the query.

You can analyze the slow query:
EXPLAIN SELECT .... WHERE user.avatarid=avatar.userid ...
If it says ALL entries, that's bad.
For example, in the former statement there must be indexes ON
user.avatarid
avatar.userid

MrZeropage

10-02-2006 10:35 AM

Quote:

Originally Posted by Barabaika

Maybe you can hand those changes to me for integrating in v2.5.7 ? :)

scdurwood

10-24-2006 03:34 AM

Quote:

Originally Posted by MrZeropage

I think I found the code that causes a higher serverload, just waiting for confirmation of that.

Well, "it's not a bug, it's a feature" ;)
It is a feature I implemented and if that was the reason I will do a switch in AdminCP to turn it on/off ... Until v2.5.7+ is out I will provide a QuickFix for that here

Have you released the quickfix?

Server loads via the arcade are an issue on my site as well...

Quote:

Originally Posted by Barabaika

At least, it's much faster for me now.
I've created indexes and fixed several queries.

When I had looked at the server load, it was mainly MySQL that created it by getting the data for the arcade page.

The easiest way is to log slow queries in MySQL and then investigate them.
http://dev.mysql.com/doc/refman/5.0/...query-log.html

There can be other problems as well.

Please explain how you indexed each table and the other query fixes you implemented...

MrZeropage

10-24-2006 09:09 AM

I am also waiting for response on the improvements he did ... :)

ArchangelX

10-26-2006 10:29 PM

Oh man...I just upgraded to 2.5.6...is this a problem for everyone? Quickfix please, just in case!

MrZeropage

10-31-2006 11:40 AM

just update to v2.5.7+ now

gazzak

11-04-2006 08:57 AM

Just as a side note. I had a big load on my server at all times when the arcade was running. Turning off the option to show high scores in the postbit totally cut the load. I've not seen that mentioned in this thread so give it a try.

MrZeropage

11-04-2006 10:52 AM

did you use v2.5.7+ ?

TonyLuong

11-23-2006 08:19 AM

I just installed ibProArcade 2.5.7+ for 2 days on a dedicated 3.2 Dual Xeon 2GB RAM. My server crashes so often right after having ibProArcade there.

My site is busy on forums 1000+ current online but not many people on arcade (around 10 at once max) my board having about 500,000 members and about 457,000 posts.

I don't have "Show Highscores in Postbit" set
I don't have "Show Tournaments won in Postbit" set
I don't have any tournament created

Just the arcade home itself take very long time to load. My forumhome takes about 1 sec to load for me where arcade home takes about 20 sec.

Anyone running 2.5.7+ and experience this slow and high server load? Any fix here?

MrZeropage

11-23-2006 09:20 AM

wwhat are your settings about score-saving ? should be "save users top score per game" ...

Also make sure not to display 100 games per page

All times are GMT. The time now is 08:36 PM.

Page 5 of 6

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01146 seconds Memory Usage 1,740KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: