Will CB be able to take it?

My server specs below:

CPU: Intel Quad Core 5430 2.66GHz/6M
Memory: 6GB
Hard Disk: 6 x 500GB 15K SAS (RAID 10, usable ~ 1.3TB)

---

I have configured CB to be a HR Management system and each user will have and estimate of 260 fields (varchars and dates) under _comprofiler.

The CB User Management is divided in various groups, users and administrators.. There will be administrators/moderators who will edit and modify the other user groups as individual personal records.. Therefore there is a possibility of a few hundred moderators who are modifying, adding or updating records of the other users (as moderators are given access to do this). basically CB acts as a user management suite..

Apart from that CB plugin auto action (about 160 actions) is also running to check on certain conditions and auto updating certain fields.

My question is will the server be able to take that load? I am getting messages like "Database connection error (2): Could not connect to MySQL.

Is it a problem if there are too many users(moderators) updating records at the same time? I see on this forum, it is very active, but the problem does not exist? I am trying to troubleshoot to isolate this problem.

PHPMYADMIN can be useless when this happen with user message "Too many connections"

I see SUHOSIN keeps on triggering as well.. e.g. ALERT - canary mismatch on efree() - heap overflow detected (attacker 'REMOTE_ADDR not set', file 'unknown')

My question is will the server be able to take that load? I am getting messages like "Database connection error (2): Could not connect to MySQL.

Joomla throws this error normally when the database name, username, or password are incorrect in configuration.php.

Joomla caches the connection so I don't think connection limits are even possible to hit with Joomla unless you're establishing external connections with your CB Auto Actions? Always use Internal if the query is on the same database as Joomla.

Is it a problem if there are too many users(moderators) updating records at the same time? I see on this forum, it is very active, but the problem does not exist? I am trying to troubleshoot to isolate this problem.

No, this shouldn't be an issue.

Configuration.php is right. It eas running earlier. If it was wrong earlier, the site would not have been working.

Anyway, today the CPU was running at 700%++ and the whole server hang.

Run on debug I saw the memory usage for loading a cb user list was 40mb.. Not so sure why.. I have only 5 fields listed..

All cb auto actions are internal..

Any experience on the high CPU usage.. Do you think updating 50 -70 fields in a single is too much too handle? Would Ajax field help?

Best I can suggest is install xdebug on your server or enable it if already installed then run an xdebug profile of your site. Once done open the cache file with webgrind, cachegrind, or other similar software to see where exactly it's slowing down as it'll tell you what exactly is taking a mass amount of memory.

Run on debug I saw the memory usage for loading a cb user list was 40mb.. Not so sure why.. I have only 5 fields listed..

The memory usage includes CB, CB Plugins, and of course Userlist output. So all of CB being 40mb depending on what is installed and used is reasonable. I assume you're reviewing the memory usage from debug mode, which includes everything needed to load the page so that's not just CB, but is also Joomla and any other extensions you've loaded on that page; again, reasonable.

Massive CPU usage suggests too many operations at once or you have something getting stuck in an infinite loop maybe. Enable debug mode and maximum error reporting in Joomla global configuration then browse your site to see if there are any errors, warnings, etc..

Do you think updating 50 -70 fields in a single is too much too handle?

50-70 fields in a single what? Single query? No, but if you're calling that query multiple times per page per user then that could cause massive usage.

Sorry.. It 50-70 fields in user profile form..

FYI, CPU was 700% for MySQL..

Tried to access CB User Manager and I got this:

DB function failed with error number 1030
Got error 134 from storage engine SQL=SELECT u.*, GROUP_CONCAT( DISTINCT g.title ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation FROM jos_users AS u LEFT JOIN jos_comprofiler AS ue ON u.id = ue.id INNER JOIN jos_user_usergroup_map AS aro ON aro.user_id = u.id INNER JOIN jos_usergroups AS g ON g.id = aro.group_id GROUP BY u.id LIMIT 0, 20

---

Now I am not sure if the server crashed caused this? Or the above is causing the server to misbehave?