but now when i post..anything at all the spinner keeps spinning and mysql processlist shows
MariaDB [(none)]> SHOW PROCESSLIST;
+---------+--------------+-----------+--------------+---------+------+---------- +------------------------------------------------------------------------------- -----------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+---------+--------------+-----------+--------------+---------+------+---------- +------------------------------------------------------------------------------- -----------------------+----------+
| 1139415 | greentec_jam | localhost | greentec_jam | Query | 89 | updating | DELETE FROM jr_jrcore_cache WHERE (cache_item_id LIKE '%,85,%') | 0.000 |
| 1139432 | greentec_jam | localhost | greentec_jam | Query | 22 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139433 | greentec_jam | localhost | greentec_jam | Query | 16 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139444 | greentec_jam | localhost | greentec_jam | Query | 5 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139447 | greentec_jam | localhost | greentec_jam | Query | 49 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139450 | greentec_jam | localhost | greentec_jam | Query | 49 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139456 | greentec_jam | localhost | greentec_jam | Query | 39 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '31197d658d4b14d2b | 0.000 |
| 1139461 | greentec_jam | localhost | greentec_jam | Query | 33 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '1070b93117c90eede | 0.000 |
| 1139462 | greentec_jam | localhost | greentec_jam | Query | 31 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139463 | greentec_jam | localhost | greentec_jam | Query | 30 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '1c3e4ccca32695f0f | 0.000 |
| 1139465 | greentec_jam | localhost | greentec_jam | Query | 29 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139467 | greentec_jam | localhost | greentec_jam | Query | 29 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139468 | greentec_jam | localhost | greentec_jam | Query | 28 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139469 | greentec_jam | localhost | greentec_jam | Query | 27 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '26338f17a054da759 | 0.000 |
| 1139472 | greentec_jam | localhost | greentec_jam | Query | 26 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '638e799f8262b6f04 | 0.000 |
| 1139475 | greentec_jam | localhost | greentec_jam | Query | 25 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139476 | greentec_jam | localhost | greentec_jam | Query | 25 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139477 | greentec_jam | localhost | greentec_jam | Query | 24 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139480 | greentec_jam | localhost | greentec_jam | Query | 15 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139487 | greentec_jam | localhost | greentec_jam | Query | 11 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '62f9dabb4705ddac4 | 0.000 |
| 1139488 | greentec_jam | localhost | greentec_jam | Query | 9 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '56824e470ffbda06b | 0.000 |
| 1139491 | greentec_jam | localhost | greentec_jam | Query | 9 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139494 | greentec_jam | localhost | greentec_jam | Query | 7 | updating | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_ke y = '26338f17a054da759 | 0.000 |
| 1139495 | greentec_jam | localhost | greentec_jam | Query | 5 | update | INSERT INTO jr_jrcore_cache (cache_key,cache_expires,cache_module,cache_profil e_id,cache_user_id,cac | 0.000 |
| 1139498 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
+---------+--------------+-----------+--------------+---------+------+---------- +------------------------------------------------------------------------------- -----------------------+----------+
25 rows in set (0.00 sec)
MariaDB [(none)]>
it seems the db insert is held up by a whole lot of cache updating
this is all the full page caching right?
--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 12/09/17 04:27:13PM