931
alain01
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/17 16:49

  • alain01

  • Just can't stay away

  • Posts: 530

  • Since: 2003/6/20


cp -p ../xoops_data/caches/index.html ../xoops_data/caches/xoops_cache

"-p" to preserve mode,ownership,timestamps

There is a solution to delete all except 1 file,
in bash :
>shopt -s extglob
then
>rm -- !(index.html)
But be careful, test it on tempory directory and with recursive directories (rm -r)

Note A :
Since XOOPS 2.5.9, there is a admin maintenance page to do it , empty cache (smarty_cache / smarty_compile, xoops_cache)

Note B :
On the XOOPS 2.5.11, we use index.php with this content , not index.html :
header("HTTP/1.0 404 Not Found");



932
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



933
Mamba
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/17 9:22

  • Mamba

  • Moderator

  • Posts: 11373

  • Since: 2004/4/23


You might try to clear the cache via the Admin/Maintenance
I'm not sure if it will help, but you can try.

The other option is to delete user accounts that are old but never connected.

The best option is to update PHP to PHP7+, as it will speed things up, but for that, you would need to update XOOPS and your modules, which seems that it's not an option for your right now.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



934
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



935
alain01
Re: xmcontent 1.5 Final Released
  • 2021/3/16 17:59

  • alain01

  • Just can't stay away

  • Posts: 530

  • Since: 2003/6/20


Here the news (in french language) on the french XOOPS site, monxoops.fr



936
Yurdal
Re: xmcontent 1.5 Final Released
  • 2021/3/15 16:52

  • Yurdal

  • Friend of XOOPS

  • Posts: 386

  • Since: 2005/3/27


Thanks for sharing and maintaining



937
goffy
Re: xmcontent 1.5 Final Released
  • 2021/3/15 9:21

  • goffy

  • Just can't stay away

  • Posts: 535

  • Since: 2010/12/27


great news. thank you



938
Mage
xmcontent 1.5 Final Released
  • 2021/3/14 21:59

  • Mage

  • Core Developer

  • Posts: 206

  • Since: 2009/8/2 1


Hello,

We are happy to announce the release of version 1.5 of the module xmcontent.

This version brings 2 major new features:

- Modification of the content from the user part
- Possibility to include a page in another

The complete list:

-------------------------------------------------
Version: 1.5 Final
Date: 14.03.2021
-------------------------------------------------
Bug fixes:
- The search ignored permissions.
- Tempaltes encoding problem.
- Fixed an error with xmdoc.
- Fixed an error with the content filter (admin).

Improvements:
- Code optimization.
- Better integration of XMF.
- Added modification permission.
- The content is now editable from the user part.
- PHP8 compatibility.
- Integration of xmsocial to rate content and add social media.
- We can now include a page in another page.

Security:
- Users who had the rights to edit content could change the permissions.
Now only those who have the right to administer the module can do it.

To see the description of the module and download it:

xmcontent on http://www.monxoops.fr



939
Mage
Re: xmdoc
  • 2021/3/14 21:56

  • Mage

  • Core Developer

  • Posts: 206

  • Since: 2009/8/2 1


Thank you all for voting for my module!



940
alain01
Re: wgGithub on myXoops
  • 2021/3/9 21:31

  • alain01

  • Just can't stay away

  • Posts: 530

  • Since: 2003/6/20


Ok, I'm on this amazing module !

Goffy, you are not human !
This module seems to be crazy !

I'm exploring it to try to understand all tabs and parameters on this module.

Anyway, thank you for this amazing job you have done for the XOOPS community!




TopTop
« 1 ... 91 92 93 (94) 95 96 97 ... 29425 »



Login

Who's Online

560 user(s) are online (334 user(s) are browsing Support Forums)


Members: 0


Guests: 560


more...

Donat-O-Meter

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

Latest GitHub Commits