EQdkp-Plus - DKP System - Raidplaner - Guildportal - Gildenportal - WoW, Lotro, Runes of Magic home of the EQDKP Plus Projekt

Hello there!

I, and my users, have been feeling that our EQDKP install has been extremely slow lately.
http://nylaathria.dk/eqdkp/
There's a fresh install on http://nylaathria.dk/eqdkp2/ which have hardly been set up, that's even slower - I've installed this weeks ago for backups sake.

I did a speedtest on http://www.iwebtool.com/speed_test?domain=www.nylaathria.dk%0D%0Awww.nighty.dk%0D%0Awww.nylaathria.dk%2Feqdkp%0D%0Awww.nylaathria.dk%2Feqdkp2%0D%0Awww.crimsoncarnage.dk%0D%0Awww.nighty.dk%2Fccforum%0D%0Awww.nylaathria.dk%2Fnyl with all my domains on that host, and some subpages, such as the two phpBB forum and normal sites I've got on the host.

# Domain name Size Load Time Average Speed per KB
1 http://www.nylaathria.dk 46.6 KB 0.97 seconds 0.02 seconds
2 http://www.nighty.dk 3.34 KB 0.4 seconds 0.12 seconds
3 http://www.nylaathria.dk/eqdkp 0.1 KB 4.93 seconds 50.47 seconds
4 http://www.nylaathria.dk/eqdkp2 0.08 KB 6.21 seconds 75.67 seconds
5 http://www.crimsoncarnage.dk 6.5 KB 0.63 seconds 0.1 seconds
6 http://www.nighty.dk/ccforum 9.08 KB 3.12 seconds 0.34 seconds
7 http://www.nylaathria.dk/nyl 16.76 KB 4.08 seconds 0.24 seconds

As you see all normal sites, and forums are at 0.xx seconds, but the two EQDKP installs are at 50 & 75s.

Let me start out with - I'm not all that very much into MySQL etc. I'm learning, but still got lots to go still.

Sooo, if anyone got any ideas, please let me know, and I'll try and provide any info you may ask of.

Just now going on the admin panel took 17 seconds.
If any of this helps:

PHP Setting name Value
PHP Safe Mode OFF
Register Globals ON
CURL ON (7.15.3)
Fopen ON
PHP Version 5.2.14
Mysql Version Client(5.0.67)
Server(5.1.49-log)
Mysql Strict Mode NO


Thanks, and best Regards
Rasmus / Nightzorn

Since it depends which sites of your EQDKP+ are called, i can make some guesses:

1. Your itemstats cache is not working, so EQDKP tries to pull the infos from external sites everytime you call the site
2.Your site doesn't support any of our caching modes, so you need to query every little information for every call
3. Your SQL server is a bit slow. The bottle neck of EQDKP are remote systems (Itemstats / RSS / etc) and your SQL server. Try to optimize your SQL tables.

Let me start out with - Thanks!

I'll try fooling around with itemstats now and see what happens.
- Caching I'm unsure about, in which ways you mean of this and in which ways it's used, my programming skills ain't in the advanced, it's limited to some html, css, php.
I saw Caching in one of the modules, it was set to database, changed it to cache, but later (yesterday I believe) I turned it off all together.

But since it's also on the "/eqdkp2/" install I have which only have standard settings, maybe it's down to some standard setting?

The system provides caching with APC and memcache. Both are PHP5 extensions and can only setup by your hoster.

Have you tried the SQL optimization?

Please check if the directory eqdkp2/itemstats/cache dir is set to chmod 0777.
Try to switch off the immediate search of itemstats.

is it bad if there's no eqdkp/itemstats/cache?
There's a xmlcache.

And I'm unsure what you mean with the SQL Optimization I'm afraid.
Something like, after a quick googling: http://www.basis.com/support/tips/sqloptimization.html? or is it some mod you guys have created?


Edit 1:
Also to just make sure.
nylaathria.dk/eqdkp is the EQDKP Plus we use.
nylaathria.dk/eqdkp2 is just one I installed for.. I'm not quite sure anymore actually, if the main one should fail.

Edit 2:
Updated itemstats and turned off immediate Search, no changes.

Edit 3:
Tried turning off itemstats, that sure made the site speedy compared to before! Still not 'fast', but a lot better.
So pretty sure the problem lies with that somewhere.

Edit 4: All folders in /eqdkp/ is 755, all files 644

Update to Edit 3 - Seems I was mistaken, it felt faster at first, then went back to slowpoke state *Shrugs*

I just checked my phpMyAdmin.

3.1 GB/50.0 GB used since the 6th of February, which seems like A LOT for me, as we're only some 20 people total that might be ever the slighest active on our forum.

And since the eqdkp is the only thing except the forum that's "interactive" then I got this feeling that there might be something eating the eqdkp.
But it's here where my knowledge comes to a lack, is there a way to see this?

I turned website statistics on, in 24 hours it'll start generating a chart which will hopefully tell me a bit more about what's using all that much bandwith.
http://nylaathria.dk/webalizer/index.html

I figured out the optimize!
With the most tiny bit of health from a pal.. Seems to go a whole lot faster now.

Thanks for the help!

I'll poke you if it should change

Edit: Alright that was fast.
It's slow again some 1m after the optimize.. It's more like, spiking extremely much.

Perhabs you can send me an admin login, so i can check somethings myself? Just create one, which you can dumb later.

http://nylaathria.dk/webalizer/usage_201102.html
The webalizer has updated, I'm unsure if this helps at all.

1 601 8.80% 2178 1.22% /eqdkp/admin/updateitemstats_include.php
is the most loaded file.

I'll sort the admin thing out tomorrow, about to head to bed!
Edit: Admin log for which part by the way? MySQL or EQDKP?


Rasmus

Admin Log to EQDKP and phpmyadmin.