View iionly's plugins
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
Forget these links about trying to tell you how to delete database entries this way. That's not solving your problem. Your problem with the size of the database is not (maybe never has been) the number of users. Though it might help to clean up unwanted users (and the Bulk User Admin plugin does exactly that! You only need the 1 minute cronjob of Elgg to work - and it seems at least this one works on your site).
As for the users: if the "Content Statistics" page shows you the expected number of users (i.e. the number of users you expect AFTER the user deletion) the user entities and their content has been deleted from the database and the server. The number of users would only be reduced if the Bulk User Admin plugin has deleted the accounts for real.
But your problem is caused be two other problems:
The entities table only has about 160 thousands entries. So even after removal of some 1000 users you won't see much of a difference.
The reason the log and sessions table got so big on your site is due to two different reasons.
The log table never got cleaned up because you had never set up the necessary cronjob (corresonding the the System Log plugin settings - as named on Elgg 3 while it was named Logrotate plugin on Elgg 2).
How to fix the log table problem:
How to fix the sessions table problem:
with a correct php installation the table wouldn't have gotten that large in the first place. Unfortunately, Elgg relies on some php variables having some specific values (but this is not the case by default on some servers) to clean up the table from outdated entries. These php variables are (together with some example values)
These variables must not be commented out or there will never be a cleanup of the sessions table taking place. You can set larger values for session.gc_maxlifetime (the number gives the number of seconds a session of a user is valid without some user action but don't set it too large).
You will have to set these variables in the php.ini of your server. If that's not possible it might work to set them in the php block within the .htaccess file of your Elgg installation.
See also some other discussions about the sessions table issue: https://elgg.org/discussion/view/2776966/elgg-user-sessions-table-corrupted, https://elgg.org/discussion/view/2873619/large-size-of-table-in-the-mysql-database and https://elgg.org/discussion/view/2470703/can-i-empty-elgg-users-sessions-table-too-big.
The fix the imminent problem with the current large size of the sessions table of your installation you probably have to "EMPTY" (again: NOT delete) the "ToEvolutionusers_sessions" table with phpMyAdmin. Best do it while not logged in on your site. When you empty the table all users will get logged out and will have to log in again.
Further things you should do (best would be to get it working AFTER you fixed the issue with the log and sessions table):
Anyway, your problems are not due to the Bulk User Admin plugin. So, I want to ask you to not post here in this page anymore in future if you have unrelated problems.