1
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/23 14:13

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


@geekwright

FYI; reverted to old db 300000K+ users, 100K never logged in. Your changes still work.

...B



2
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/20 21:31

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


@geekwright

Thanks!!!
Replaced two files - can now see to admin->users (still at 200000 users)
Have not yet tried cleanup query

If you want/need a large users table for testing your changes on trunk, I can provide.

...B



3
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/19 13:47

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


@geekwright

You da man. Went above and beyond in this one. Will give it a spin late today or tomorrow once I untangle current (non-xoops) issues I am working on.

Surprises me that other xoops users have not run into this previously...

Thanks;
Bill



4
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/18 10:52

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


@geekwright

- my tables are too large for php(myadmin) import, am using using cli import
- original sites use sme-server 9.2 which has been replaced by sme-server 10. The sme 10 copies I am working on use sql exported (phpmyadmin) and imported (cli). Problem exists on old sme 9.2 and sme 10 sites.
- I always use expendable VM copy when doing dangerous stuff such as (db) global changes
- Disk layout or corruptions not the issue, since sme-10 VM's created from scratch. Xoops installation copied from old.

"try an index on the user_regdate column" HOW?, Just a matter of adding index property, or altering mysql queries? Ditto for limit clause.

"groups_users_link" dead entries. Problem?, how remove?

If your investigation requires access to 2.5.4, PM me and I will setup ssh (to a sme-10 copy VM, primary still running under sme-9.2 until migration complete) access for you. Or, you can DL entire VM, but my upload speed slow, will take hours to DL.

...B



5
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/17 21:32

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Thanks Alain;

Yes, aware of maintenance GUI, use the script after contents update (too lazy to unset / set caching) and (maybe, eventually) a cron job.

How 'bout this:
[ code]
#!/bin/sh

rm -rf ../xoops_data/caches/xoops_cache
rm -rf ../xoops_data/caches/smarty_cache
rm -rf ../xoops_data/caches/smarty_compile
mkdir -p ../xoops_data/caches/xoops_cache
mkdir -p ../xoops_data/caches/smarty_cache
mkdir -p ../xoops_data/caches/smarty_compile
cp ../xoops_data/caches/index.* ../xoops_data/caches/xoops_cache
cp ../xoops_data/caches/index.* ../xoops_data/caches/smarty_cache
cp ../xoops_data/caches/index.* ../xoops_data/caches/smarty_compile
chown -R www:sysops ../xoops_data/caches
[ /code]

Correct me if wrong: "cp -p" unnecessary since ownership explicitly set, mode is inherited from dest dir and, don't care about timestamps

Regards;
Bill



6
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/17 13:48

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Thanks Michael;

did this:
[ code]
mysql > use dbname;
mysql > DELETE FROM `xoops_users` WHERE `last_login` = 0 ORDER BY `last_login` ASC; #Not sure if ORDER BY and ASC neccessary
[ /code]
...and went from approx 300000 to approx 100000 users. Problem still persists

next (phpmyadmin), looked for duplicate url's (spam registrations). Approx 1000 users with url's so, not issue

Clean cache ineffective. Can you "bless" my clean cache script?:
[ code]
#!/bin/sh

rm -rf ../xoops_data/caches/xoops_cache
rm -rf ../xoops_data/caches/smarty_cache
rm -rf ../xoops_data/caches/smarty_compile
mkdir -p ../xoops_data/caches/xoops_cache
mkdir -p ../xoops_data/caches/smarty_cache
mkdir -p ../xoops_data/caches/smarty_compile
cp ../xoops_data/caches/index.html ../xoops_data/caches/xoops_cache
cp ../xoops_data/caches/index.html ../xoops_data/caches/smarty_cache
cp ../xoops_data/caches/index.html ../xoops_data/caches/smarty_compile
chown -R www:sysops ../xoops_data/caches
[ /code]

I guess I will have to use phpmyadmin for any user modifications.

Any other suggestions?

Thanks;
Bill



7
rossb
Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/16 22:03

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Hi;

My sites are popular and have accumulated may users over the years.

When I login as administrator and select "users", page times out and mysqld CPU is greater than 100%.
This state of affairs persists until site VM reboot.

xoops-2.5.4, php-5.4.16

I have much custom coding on these sites and no time / resources to update

Any quick-n-dirty suggestions?

Thanks;
Bill



8
rossb
Re: HowTo get per arcticle comments for publisher?
  • 2020/11/15 15:22

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Hi Mamba;

default and xswatch templates are virgin, no mods

change theme to (from xbootstrap, modified) to default or xswatch, result:
- no forum in article that should have one

clean cache:
xbootstrap - no forum
xswatch - no forum
default - no forum

Update system module: no forum

Forum for publisher per article is interim step. An alternative way to view other articles is using custom TreeList.php, example:

https://www.rossco.dynu.com/modules/Tr ... verview_And_Selection.htm

Ideally, what I would like is some footer code that would display a forum (name, ... extracted from article URL) specific to the article. If I fail at this, may port all articles to publisher, assuming I can get forum per publisher article working.

Total fail: look for 3rd party comment system...

Want me to PM you login creds so U can poke around?

Regards;
Bill



9
rossb
HowTo get per arcticle comments for publisher?
  • 2020/11/15 12:55

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Hi;

Xoops-2.5.9
Publisher 1.05 Final
Forum 4.33 Final
Site: www.rossco.org

I have configured Publisher for:
(module preferences): “Allow comments” set to TRUE
(module preferences): Control comments at the article level? YES
(article preferences, others): Can article be commented? YES

and no comment block on page...

What am I missing?

Thanks;
Bill



10
rossb
Re: Include all files (sorted) in a template directory
  • 2020/11/6 20:58

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


Thanks Mamba;

I assume using foreach...




TopTop
(1) 2 3 4 ... 7 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

53 user(s) are online (29 user(s) are browsing Support Forums)


Members: 0


Guests: 53


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits