The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Comments |
#292
|
||||
|
||||
Great work this is my fave MOD! !
|
#293
|
||||
|
||||
Quote:
Code:
[--] Up for: 16m 54s (56K q [55.506 qps], 2K conn, TX: 2B, RX: 14M) [--] Reads / Writes: 83% / 17% [--] Total buffers: 602.0M global + 5.7M per thread (250 max threads) [OK] Maximum possible memory usage: 2.0G (49% of installed RAM) [OK] Slow queries: 0% (0/56K) [OK] Highest usage of available connections: 3% (8/250) [OK] Key buffer size / total MyISAM indexes: 64.0M/178.0M [OK] Key buffer hit rate: 99.5% (2M cached / 14K reads) [OK] Query cache efficiency: 59.5% (28K cached / 47K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts) [!!] Joins performed without indexes: 353 [OK] Temporary tables created on disk: 5% (98 on disk / 1K total) [OK] Thread cache hit rate: 99% (8 created / 2K connections) [OK] Table cache hit rate: 95% (238 open / 248 opened) [OK] Open file limit used: 4% (431/10K) [OK] Table locks acquired immediately: 99% (45K immediate / 45K locks) |
#294
|
|||
|
|||
Quote:
|
#295
|
||||
|
||||
u can see in any any mysql stats.
but I suggest using: http://wiki.mysqltuner.com/MySQLTuner for better visualization regards |
#296
|
|||
|
|||
Code:
-------- Performance Metrics ------------------------------------------------- [--] Up for: 103d 6h 0m 40s (6M q [0.772 qps], 501K conn, TX: 295B, RX: 1B) [--] Reads / Writes: 82% / 18% [--] Total buffers: 34.0M global + 2.7M per thread (100 max threads) [OK] Maximum possible memory usage: 729.8M (36% of installed RAM) [OK] Slow queries: 0% (0/1K) [OK] Highest usage of available connections: 3% (3/100) [OK] Key buffer size / total MyISAM indexes: 200.0M/11.0M [!!] Key buffer hit rate: 22.1% (10K cached / 8K reads) [!!] Query cache efficiency: 14.3% (27 cached / 189 selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 30 sorts) [OK] Temporary tables created on disk: 4% (3 on disk / 63 total) [OK] Thread cache hit rate: 94% (3 created / 59 connections) [OK] Table cache hit rate: 39% (865 open / 2K opened) [OK] Open file limit used: 44% (1K/3K) [OK] Table locks acquired immediately: 100% (1K immediate / 1K locks) [OK] InnoDB data size / buffer pool: 12.4M/24.0M |
#297
|
|||
|
|||
Quote:
So please do a backup of your database and run the following MySQL querys (adding a table prefix as necessary): Code:
ALTER TABLE `award_user` ADD INDEX `award_id` ( `award_id` ) Code:
ALTER TABLE `award_user` ADD INDEX `userid` ( `userid` ) Code:
OPTIMIZE TABLE `award_user` After doing this, check if the problem persists. If I guessed right it doesn't. |
#298
|
||||
|
||||
Quote:
Thanks bro! Now it's much better! But some indexes are still missing: Code:
[--] Up for: 6h 1m 4s (2M q [112.642 qps], 106K conn, TX: 3B, RX: 552M) [--] Reads / Writes: 82% / 18% [--] Total buffers: 602.0M global + 5.7M per thread (250 max threads) [OK] Maximum possible memory usage: 2.0G (49% of installed RAM) [OK] Slow queries: 0% (0/2M) [OK] Highest usage of available connections: 9% (24/250) [OK] Key buffer size / total MyISAM indexes: 64.0M/175.9M [OK] Key buffer hit rate: 100.0% (118M cached / 46K reads) [OK] Query cache efficiency: 66.6% (1M cached / 2M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (103 temp sorts / 140K sorts) [!!] Joins performed without indexes: 132 [OK] Temporary tables created on disk: 7% (3K on disk / 49K total) [OK] Thread cache hit rate: 99% (24 created / 106K connections) [OK] Table cache hit rate: 84% (347 open / 413 opened) [OK] Open file limit used: 5% (539/10K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) |
#299
|
|||
|
|||
I found another one that should propably be added:
Code:
ALTER TABLE `award` ADD INDEX `award_cat_id` ( `award_cat_id` ) Again, optimize table to fill the index: Code:
OPTIMIZE TABLE `award` That's all I spotted now. To further track down the issue I would suggest to turn on slow query log on the mysql server and enable the option "log-queries-not-using-indexes", which logs the querys to the slow query log. If you are on shared hosting, ask your provider to enable these options for you (normally they do such things as you are about to take load off their server ). If you run your own server I hope you know how to do this :P (if not, have a look at the documentation on mysql.com, search for the options and add them to my.cnf) |
#300
|
|||
|
|||
Question on this mod...I have a previous version installed but am about to drop this one in place and upgrade. Mine is also fairly modified to suit our needs. One thing I am working on is creating a page that would pull users based on their group, display their registered date, and display their awards. IE -
Person 1 . . . . . 08/08/2008 . . . . . AWARD 1 - AWARD 2 - AWARD 5 Person 3 . . . . . 08/12/2008 . . . . . AWARD 1 Person 4 . . . . . 08/15/2008 . . . . . AWARD 2 - AWARD 5 Person 9 . . . . . 08/18/2008 . . . . . AWARD 1 - AWARD 2 - AWARD 5 I have the page already showing everything but the awards...and just started looking at the code for that. Fairly heavy SQL query...anyone have any quick idea on how that would look? |
#301
|
||||
|
||||
Quote:
Thank for the advice! I've enabled slow query log with log-queries-not-using-indexes but how to find out where are the missing indexes? It store almost all queries |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|