vb.org Archive
Page 12 of 44 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=127980)

Phooey 10-30-2006 01:31 PM
I'm having issues where the Display Colors & Resolutions page isn't showing any data. Everything else is working fine, it's just that page. I've double checked everything and I think I have it installed correctly.

Any suggestions?

You can see my stats page at http://www.digitallywise.com/forums/psistats.php

Lottis 10-30-2006 05:55 PM
Thank you, Psionic Vision.
This was a great product and it works great. No problem at all. Thanks and nominating.

Lottis 10-30-2006 05:56 PM
Hmm, why cant this be nominated?

transitbus 10-30-2006 07:33 PM
Edit NM Can't use this mod due to the lock issue. Oh well, looked good at the time.

akanevsky 10-30-2006 09:34 PM
Quote:
Originally Posted by Phooey
I'm having issues where the Display Colors & Resolutions page isn't showing any data. Everything else is working fine, it's just that page. I've double checked everything and I think I have it installed correctly.

Any suggestions?

You can see my stats page at http://www.digitallywise.com/forums/psistats.php
Did you do template modifications?

Quote:
Originally Posted by Lottis
Hmm, why cant this be nominated?
What do you mean - it can't be nominated?

As for the lock issue, why not fix it?

transitbus 10-31-2006 12:13 AM
Quote:
Originally Posted by Psionic Vision
As for the lock issue, why not fix it?
Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?

Nandakal 10-31-2006 06:12 AM
Quote:
Originally Posted by transitbus
Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?
Same, cant use it due to lock issue, had to deinstall it.

-N.

akanevsky 10-31-2006 10:09 PM
Quote:
Originally Posted by transitbus
Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?
Because that's the only method of locking data.

transitbus 11-01-2006 01:30 AM
Not sure why you need to use locking in the form you do for this type of database but seeing how many of us can not have that access (no everyone runs their own mysql server) and almost no other add on here uses this method, I would think you would choose a different way to make this compatible.

and I am going to quote mysql.com because I like to back up my statements with evidence ;)

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

Quote:
Normally, you do not need to lock tables, because all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. However, there are a few cases when locking tables may provide an advantage:
  • If you are going to run many operations on a set of MyISAM tables, it is much faster to lock the tables you are going to use. Locking MyISAM tables speeds up inserting, updating, or deleting on them. The downside is that no thread can update a READ-locked table (including the one holding the lock) and no thread can access a WRITE-locked table other than the one holding the lock.
    The reason some MyISAM operations are faster under LOCK TABLES is that MySQL does not flush the key cache for the locked tables until UNLOCK TABLES is called. Normally, the key cache is flushed after each SQL statement.
  • If you are using a storage engine in MySQL that does not support transactions, you must use LOCK TABLES if you want to ensure that no other thread comes between a SELECT and an UPDATE. The example shown here requires LOCK TABLES to execute safely:

Code:
LOCK TABLES trans READ, customer WRITE;
SELECT SUM(value) FROM trans WHERE customer_id=some_id;
UPDATE customer
  SET total_value=sum_from_previous_statement
  WHERE customer_id=some_id;
UNLOCK TABLES;
Without LOCK TABLES, it is possible that another thread might insert a new row in the trans table between execution of the SELECT and UPDATE statements.
You can avoid using LOCK TABLES in many cases by using relative updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function. See Section 1.9.5.3, “Transactions and Atomic Operations”.
You can also avoid locking tables in some cases by using the user-level advisory lock functions GET_LOCK() and RELEASE_LOCK(). These locks are saved in a hash table in the server and implemented with pthread_mutex_lock() and pthread_mutex_unlock() for high speed. See Section 12.9.4, “Miscellaneous Functions”.

Lottis 11-01-2006 09:55 AM
Quote:
Originally Posted by Psionic Vision
What do you mean - it can't be nominated?
Earlyer it was a nominating button on the hack. But now it issent.
Do we have to nominat manually now?


All times are GMT. The time now is 04:06 PM.
Page 12 of 44 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

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.01348 seconds
  • Memory Usage 1,747KB
  • 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_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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