Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Showing results 1 to 6 of 6
Search took 0.00 seconds. Search: Posts Made By: Barabaika
Forum: vBulletin 3 Articles 03-08-2009, 02:05 AM
Replies: 13
Views: 8,996
Posted By Barabaika
* The 'rel' attribute is rel="Lightbox_11111111"...

* The 'rel' attribute is rel="Lightbox_11111111" now - Lightbox_ + unique ID for all images in the set.
* <a href should be a script that returns an XML page that has html (with link inside), date,...
Forum: ibProArcade Archive 09-27-2006, 03:56 PM
Replies: 53
Views: 5,645
Posted By Barabaika
You should put this in your my.cnf: ...

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....
Forum: ibProArcade Archive 09-27-2006, 05:02 AM
Replies: 53
Views: 5,645
Posted By Barabaika
At least, it's much faster for me now. I've...

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...
Forum: ibProArcade Archive 09-26-2006, 10:33 PM
Replies: 53
Views: 5,645
Posted By Barabaika
Ok. I've found the main problem. Now it...

Ok. I've found the main problem.

Now it creates a query like this:
function/dbclass.php, line 85
SELECT user.userid,.... WHERE customavatar.userid=111111 OR user.userid=111111;

We don't need...
Forum: ibProArcade Archive 09-14-2006, 04:59 AM
Replies: 53
Views: 5,645
Posted By Barabaika
I just gave a quick look at the mysql.log file...

I just gave a quick look at the mysql.log file for an arcade.php call.
The user table has thousands of entries and full scan can take a long time.
I found this SELECT in the log:
SELECT...
Forum: ibProArcade Archive 09-11-2006, 07:17 PM
Replies: 53
Views: 5,645
Posted By Barabaika
There are no appropriate indexes, that is the...

There are no appropriate indexes, that is the source of the problem.
What about adding an index to the "avatarid" field in the "user" table?

Also, why do you need this garbage: " AND...
Showing results 1 to 6 of 6

 
Forum Jump

All times are GMT. The time now is 05:09 AM.

Contact Us - Archive - Top

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.01187 seconds
  • Memory Usage 1,911KB
  • 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)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (6)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (17)threadbit_pagelink 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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/functions_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • forumjump
  • search_complete
  • navbits
  • navbits_complete