Jump to content

AlexJ

Clients
  • Posts

    4,200
  • Joined

  • Last visited

  • Days Won

    3

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Everything posted by AlexJ

  1. @All Astronauts How can i remove 51 more and show their names instead?
  2. You are asking for 40$/year for your plugin. You will earn more if you fix that 10$/3 months to 10$/6 months appx. Anyhow I purchased it but sharing feedback. But no way, i will be paying each renewal. Sorry being upfront honest.
  3. Q: Is the table schema correct? is their anything missing which can cause the slowness on update? Is any other customers that you aware off, facing same issue? PS You know well that hosting company will not do anything because IPS is not their application.
  4. Hosting datacenter doesn't know IPS application. It's IPS table and schema and MySQL is open source which you are recommending for your application. Please evaluate why this table is slow on updates or are you indirectly telling that their is no one in IPS team that can help with the issue?
  5. Yes - that was it! Thanks for the tip. I was surprised for not finding that table. It has only 77 records. So why it takes 10 sec and more to update this table? Showing rows 0 - 77 (78 total, Query took 0.0003 seconds.)
  6. It's on dedicated server and overall MySQL is optimized. I don't see any pending locks in last 7 days. Locks: Active Connections: Row operations: My thought was is if MySQL is not optimized - other queries will have issue as well.. but I don't see much for other queries. Those widget queries normally what I see very often. So i am targeting them first. Below are MySQL details from MySQLTuner. -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 26d 12h 52m 58s (182M q [79.787 qps], 4M conn, TX: 2754G, RX: 80G) [--] Reads / Writes: 96% / 4% [--] Binary logging is disabled [--] Physical Memory : 62.6G [--] Max MySQL memory : 25.0G [--] Other process memory: 0B [--] Total buffers: 14.6G global + 71.2M per thread (150 max threads) [--] P_S Max memory usage: 72B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 22.0G (35.16% of installed RAM) [OK] Maximum possible memory usage: 25.0G (39.93% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (290/182M) [OK] Highest usage of available connections: 71% (107/150) [OK] Aborted connections: 0.00% (217/4776645) [!!] Query cache may be disabled by default due to mutex contention. [!!] Query cache efficiency: 0.0% (10K cached / 159M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (236K temp sorts / 31M sorts) [!!] Joins performed without indexes: 2604207 [!!] Temporary tables created on disk: 31% (2M on disk / 9M total) [OK] Thread cache hit rate: 99% (107 created / 4M connections) [OK] Table cache hit rate: 99% (450M hits / 452M requests) [OK] table_definition_cache(4000) is upper than number of tables(1754) [OK] Open file limit used: 3% (193/5K) [OK] Table locks acquired immediately: 99% (8M immediate / 8M locks) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 18.7% (1.1G used / 6.0G cache) [OK] Key buffer size / total MyISAM indexes: 6.0G/121.3M [OK] Read Key buffer hit rate: 98.8% (70M cached / 813K reads) [!!] Write Key buffer hit rate: 18.7% (1M cached / 195K writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [--] InnoDB Thread Concurrency: 0 [OK] InnoDB File per table is activated [OK] InnoDB buffer pool / data size: 8.0G/5.4G [OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 1.0G * 2/8.0G should be equal to 25% [OK] InnoDB buffer pool instances: 8 [--] Number of InnoDB Buffer Pool Chunk : 64 for 8 Buffer Pool Instance(s) [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances [OK] InnoDB Read buffer efficiency: 100.00% (63801399921 hits/ 63801663635 total) [!!] InnoDB Write Log efficiency: 85.36% (35910577 hits/ 42069813 total) [OK] InnoDB log waits: 0.00% (0 waits / 6159236 writes) Now this is interesting: I don't even have that table. @Marc Stridgen Is it because, I am using Redis?
  7. /*xxxx::xxxx::IPS\_Widget::__toString:18476*/ UPDATE `ipb_core_widgets` `core_widgets` SET `caches`='{\"widget_topicFeed_86uiii4of_60d6ddb21f110bf3c9024baf58e4fcbd\":1676231243}' WHERE `key`='topicFeed' AND app='forums'; # Time: 2023-02-12T19:47:34.620616Z # User@Host: xxxx[xxxx] @ localhost [] Id: 4064016 # Query_time: 11.263576 Lock_time: 0.000029 Rows_sent: 0 Rows_examined: 1 SET timestamp=1676231254; I often see above in Slow Query log. Is their any reason why widget is taking 11 sec to update? I see problem with topicFeed, upcomingEvents, etc in widget. Is their any performance issues with Widgets getting updated? Thanks.
  8. Some users create empty Albums and never upload any pics. it would be nice to have an option to delete Albums without any images after xx days or months. Thanks
  9. Exactly - yes. So we are saying it's normal to go less memory consumption after few days? I thought cache should grow and not go less. I noticed that. had to restart Redis application.
  10. I have similar question. I am noticing odd pattern in reddis. Wouldn't memory consumption increase or remain same over the period? I am not able to follow how reddis consumption goes from 250MB appx to 40MB appx. Sharing since you folks are also using reddis and rather then creating new topic, this topic down the road, might hold useful info for other users as well.
  11. No change on my end. Can you please clarify: Admin CP or FTP issue? Update: I had display name login disabled. So i have updated email for it. Can you please re-try.
  12. That's not true, trust me. I think AlexWebsite note is right on the point i.e. monetizing. I have seen much larger groups for Trading and other things. I used to think as well i.e. Discord is popular in just gaming but when I noticed other groups focused on Infra/Ops Monitoring, Trading, OpenAI etc. my perspective has changed.
  13. You are not the only one. A lot of people are in the same boat. I have a feeling, eventually, folks will move to Discord or FB pages because both are complete free of cost. For those who can manage with current changes/cost, will continue to do so but I see slim chances, that initial forums will pay 90$/month i.e. 1K/year appx while they are just starting their forum. So discord would be massively popular down the road i.e. much more then now, unless XF or VB or phpBB alike, will fill in that spot. I haven't checked other forums in last decade. I would say 70-90% gaming communities have now discord available and it's picking up game by introducing threads, Q&A, etc. features. My only gripe is I don't own the data and if tomorrow Discord discontinues their service, all the valuable conversations, data, etc. is gone. It will be interesting times down the road for sure with IPS going Pro Cloud vs Discord, FB, etc. complete free of cost.
  14. Need help with Twitter login. Details and error shared in this post. Probably, I am doing something wrong but not sure what...Thanks in advance.
  15. Hi @Adriano Faria - Website shows 3 contact us and it's confusing for users.. Can you please take a look. May 1 at top and 1 at bottom might be ok?
  16. Have issue in Chrome latest version on default theme.
  17. AlexJ

    Radical Tags

    @Makoto Your latest 2nd update seems to have fixed an issue. Please let me know if you need ACP and I will PM u the info. Thanks much!
  18. Sorry, I don't have that set in conf_global.php. Interesting updating is when I updated another forum from 3.4.x to latest version, i see different behavior. The one in problem seems to be regularly updated. Is their anyway for me to figure out which tables are not used, so i can drop them permanently? Thank you both.
  19. Shared login detector -> Detects how many users from same Browser. MAD -> Detects how many users sharing same account based on IP and Device login? Did I got correct understanding? Thanks
  20. Then gallery becomes useless... So let me explain: Gallery permissions Profile permissions. Since profile permissions are useless i.e. it can be bypassed with Gallery permissions, we should fix Profile permissions. This way, even though it's uploaded in Gallery, user can't set those images as Profile. OR tell me how can I disable, option i.e. Set photo as profile image so users can't abuse it.
  21. Please read this topic, as it has good tips and suggestion. I hope your husband recovers faster. https://invisioncommunity.com/forums/topic/471617-spam/
×
×
  • Create New...