jerzyk
Forum Replies Created
-
looks like it is working!
thnx
strange, as we never has an Pro version. More info (exception, data) I’ve sent you on slack.
Forum: Plugins
In reply to: [wp-Typography] flooded dbso far there are no problems with database, there are no pending transactions and no processes waiting for lock release. will be observing this closely – if there will be any issue, I’ll post update.
Forum: Plugins
In reply to: [wp-Typography] flooded dbI have w3total cache with memcache and opcache. Will try to enable plugin overnight.
Forum: Plugins
In reply to: [wp-Typography] flooded dbit will be a partial solution, in my opinion writing to the database on each page view is a huge price – busy sites without cache will be killed
maybe it will be better to set those caches on post/page save?
and if you are writing cache to the one single option – maybe it will be better to store data somewhere else:
– post options (then you eliminate deadlocks)
– memcache/redis – you gain some speed?Forum: Plugins
In reply to: [wp-Typography] flooded dbAt the moment plugin is disabled and will not be enabled on this site as it must stay operatinal. The only thing I’ve got for you is from my diagnostics, but those partial SQLs:
---TRANSACTION 44220701, ACTIVE 22 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 226, OS thread handle 140421858178816, query id 7812 10.80.10.2 wawawp updating UPDATE <code>wp_options</code> SET <code>option_value</code> = 'a:136403:{s:54:\"typo_CbNJ9z8M7/cynkWgE05WbKb7m3Jc+hJOIvTizr2HfcY=ftE@@\";b:1;s:54:\"typo_X3ZMskpLYi4WYT/Xh/4B26b7m3Jc+hJOIvTizr2HfcY=fsE@@\";b:1;s:53:\"typo_nju+Flcm4XnGY9sDp8ciMKb7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typo_M5QyMz9hL8K/33y/XVLKLab7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typo_obzHp1wY/3YwZYTvtfdOMKb7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typo_1B2M2Y8AsgTpgAmY7PhCfqb7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typo_vJZIFLkzTDFBldKMNoblpab7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typo_1UURBoFdhVFMXgYHNmkEQqb7m3Jc+hJOIvTizr2HfcY=tE@@\";b:1;s:53:\"typ ------- TRX HAS BEEN WAITING 22 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 174 page no 22 n bits 480 index option_name of table <code>wawawp</code>.<code>wp_options</code> trx id 44220701 lock_mode X locks rec but not gap waiting Record lock, heap no 261 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 15; hex 7479706f5f63616368655f6b657973; asc typo_cache_keys;; 1: len 8; hex 0000000000026368; asc ch;;Forum: Plugins
In reply to: [wp-Typography] flooded dbactually not, site was kept up-to-date, there was a latest (pre-5) version of the plugin, all the problems started after upgrade to 5.x
Forum: Plugins
In reply to: [Ad Inserter - Ad Manager & AdSense Ads] wrong urls in menuit is working, some code cleanups and will be ready for everybody! 🙂
thanks!