possible bugs in beta core?
Using Jamroom
in dashboard:
very high cpu use
users online count only counts logged in users (again) (correction it only lists 1 or 2 no matter how many are logged in)
(ps currently NOT using redis..yet)
does not get cpu count
cpu goes through the roof over time. woke up to it above 20.9!
after restarting both apache and mysql it drops to about 3.6 but soon climbs to over 7 and causes service temporarily unavailable
my.cnf
[mysqld]
bind-address = 127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
key_buffer = 4096
max_allowed_packet = 32M
query_cache_size = 0
query_cache_type = 0
join_buffer_size = 500k
thread_cache_size = 4
key_buffer_size = 125M
innodb_log_file_size = 512M
innodb_buffer_pool_instances = 4
table_cache = 1536
tmp_table_size = 2096M
max_heap_table_size = 2096M
innodb_buffer_pool_size = 4096M
innodb_flush_method = O_DIRECT
max_allowed_packet=32M
symbolic-links=0
join_buffer_size = 4M
max_connections = 160
thread_cache_size = 160
open_files_limit = 65535
table_definition_cache = 8096
table_open_cache = 8096
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
further notes php_mod does not work on newer php versions aparently.
cant run nginx
(domain profiles)
still using fastcgi since it 'works' but not properly
although cpu was high..ish prior to update its gone off the charts since and the other issues are new since core update
i suspect its fastcgi not mysql (cant be certain)
but have not found a workaround forr php 7
but that doesnt explain the cpu count, the user count
or the fact that prior to update cpou times only showed what that site was using, not total cpu load
noticed in procedsslist large number of updates to cache during times of highest cpu load when things get unstable
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| 4344 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | SELECT UNIX_TIM | 0.000 |
| 4499 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | SELECT `_item_id` AS i,`key` AS k,`index` | 0.000 |
| 4694 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 4752 | greentec_jam | localhost | greentec_jam | Query | 0 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_e | 0.000 |
| 4758 | greentec_jam | localhost | greentec_jam | Query | 0 | update | INSERT INTO jr_jrcore_ | 0.000 |
| 4763 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | INSERT INTO jr_jrcore_cache | 0.000 |
| 4772 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | SELECT UNIX_TIMESTAMP() AS db_time, ca | 0.000 |
| 4773 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | INSERT INTO jr_jrprofile_item_key (`_item | 0.000 |
| 4776 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | SELECT UNIX_TIMESTAMP() AS db_ | 0.000 |
| 4777 | greentec_jam | localhost | greentec_jam | Query | 0 | statistics | SELE | 0.000 |
+------+--------------+-----------+--------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
13 rows in set (0.00 sec)
edit; discovered the users online issue however these cvounts dont add up see screenshot
cpu count still not showing after reverting to previous cores
im guessing thats no longer from core/
updated by @soaringeagle: 05/09/18 10:48:15PM
