petrixstar Posted July 16, 2022 Share Posted July 16, 2022 Hello All! I tried to export to the database and it seems I couldn't!then I exported from vps via putty ssh and it worked and it seems that the table ps_jm_pagecach has 160mb and 18235000 lines. Does anyone know what is with this table and if I can delete it, that is to empty it? Thank you very much for the answer Link to comment Share on other sites More sharing options...
ps8modules Posted July 17, 2022 Share Posted July 17, 2022 Hi. This is a question for the page cache module author. 1 Link to comment Share on other sites More sharing options...
petrixstar Posted July 18, 2022 Author Share Posted July 18, 2022 ok, thanks, I found the module I also have spoken with the developer, I solved it, he told me that I can delete the table quietly! in the meantime I found another table : ps_page_viewed has 21 Mb and 400k rows. can it be emptied? I did not find anything concrete on the forum and on google Thanks 1 Link to comment Share on other sites More sharing options...
ps8modules Posted July 18, 2022 Share Posted July 18, 2022 hi ps_page_viewed is used for backoffice and graph display. Yes, you can empty it, but don't remove it. Link to comment Share on other sites More sharing options...
Rizzzle Posted July 11 Share Posted July 11 Can we delete ps_jm_pagecache? Mine is 11gb Link to comment Share on other sites More sharing options...
ps8modules Posted July 11 Share Posted July 11 SQL TRUNCATE TABLE ps_jm_pagecache; Link to comment Share on other sites More sharing options...
Rizzzle Posted July 11 Share Posted July 11 Thanks for the quick reply please can you write a basic description on how to do that in phpmyadmin? Thanks Link to comment Share on other sites More sharing options...
ps8modules Posted July 11 Share Posted July 11 (edited) Open the database, select a table, find SQL at the top, write a query in it and click the "save" button. https://wpengine.com/support/run-query-phpmyadmin/ Edited July 11 by ps8modules.com (see edit history) Link to comment Share on other sites More sharing options...
Rizzzle Posted July 17 Share Posted July 17 Hi, Thank you. The table that is huge is ps_jm_pagecache_bl Is this okay to TRUNCATE? Thanks Link to comment Share on other sites More sharing options...
Rizzzle Posted July 17 Share Posted July 17 And ps_jm_pagecache_mods Thanks Link to comment Share on other sites More sharing options...
scfrancis Posted December 9 Share Posted December 9 Hello, I allow myself to relaunch this topic, because I also have huge bases:ps_jm_pagecache_bl ps_guest ps_jm_pagecache_mods ps_jm_pagecache Do you have any information for the ps_jm bases, what module is it please? Can I empty them without risk? Thank you for your help Link to comment Share on other sites More sharing options...
Rizzzle Posted December 9 Share Posted December 9 Perhaps ps8modules could answer our query? Thanks 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now